SQL All-in-One Desk Reference for Dummies
- 10h 30m
- Allen G. Taylor
- John Wiley & Sons (US)
- 2007
Your one-stop guide to building and maintaining relational databases with SQL
If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.
- Tackle a database development project
- Formulate SQL queries
- Build database applications
- Secure your database
- Handle XML data
- Tune and optimize a database
About the Author
Allen G. Taylor is a 30-year veteran of the computer industry and the author of 25 books, including SQL For Dummies, Crystal Reports 10 For Dummies, Database Development For Dummies, Access 2003 Power Programming with VBA, and SQL Weekend Crash Course. He lectures internationally on databases, networks, innovation, and entrepreneurship. He also teaches database development through a leading online education provider and teaches microprocessor design at Portland State University.
In this Book
-
Relational Database Basics
-
Modeling a System
-
SQL Overview
-
SQL and the Relational Model
-
The Major Components of SQL
-
SQL Characteristics
-
System Development Overview
-
Building a Database Model
-
Balancing Performance and Correctness
-
Creating a Database with SQL
-
Values, Variables, Functions, and Expressions
-
Select Statements and Modifying Clauses
-
Querying Multiple Tables with Subqueries
-
Querying Multiple Tables with Relational Operators
-
Cursors
-
Protecting Against Hardware Failure and External Threats
-
Protecting Against User Errors and Conflicts
-
Assigning Access Privileges
-
Error Handling
-
Database Development Environments
-
Interfacing SQL to a Procedural Language
-
Using SQL in an Application Program
-
Designing a Sample Application
-
Building a Sample Application
-
SQL's Procedural Capabilities
-
Connecting to a Remote Database
-
XML/SQL Basics
-
Storing XML Data in SQL Tables
-
Retrieving Data from XML Documents
-
Tuning the Database
-
Tuning the Environment
-
Finding and Eliminating Bottlenecks
