Table of Contents -- Introduction -- About This Book -- Who Should Read This Book? -- Icons Used in This Book -- Where to Go from Here -- Part I: Getting Started with SQL -- Chapter 1: Relational Database Fundamentals -- Keeping Track of Things -- What Is a Database? -- Database Size and Complexity -- What Is a Database Management System? -- Flat Files -- Database Models -- Database Design Considerations -- Chapter 2: SQL Fundamentals -- What SQL Is and Isn't -- A (Very) Little History -- SQL Statements -- Reserved Words -- Data Types -- Null Values -- Constraints -- Using SQL in a Client/Server System -- Using SQL on the Internet or an Intranet -- Chapter 3: The Components of SQL -- Data Definition Language -- Data Manipulation Language -- Data Control Language -- Part II: Using SQL to Build Databases -- Chapter 4: Building and Maintaining a Simple Database Structure -- Using a RAD Tool to Build a Simple Database -- Building POWER with SQL's DDL -- Portability Considerations -- Chapter 5: Building a Multitable Relational Database -- Designing a Database -- Working with Indexes -- Maintaining Data Integrity -- Normalizing the Database -- Part III: Storing and Retrieving Data -- Chapter 6: Manipulating Database Data -- Retrieving Data -- Creating Views -- Updating Views -- Adding New Data -- Updating Existing Data -- Transferring Data -- Deleting Obsolete Data -- Chapter 7: Handling Temporal Data -- Understanding Times and Periods in SQL: 2011 -- Working with Application-Time Period Tables -- Working with System-Versioned Tables -- Tracking Even More Time Data with Bitemporal Tables -- Chapter 8: Specifying Values -- Values -- Value Expressions -- Functions -- Chapter 9: Using Advanced SQL Value Expressions -- CASE Conditional Expressions -- CAST Data-Type Conversions -- Row Value Expressions -- Chapter 10: Zeroing In on the Data You Want.

Modifying Clauses -- FROM Clauses -- WHERE Clauses -- Logical Connectives -- GROUP BY Clauses -- HAVING Clauses -- ORDER BY Clauses -- Limited FETCH -- Peering through a Window to Create a Result Set -- Chapter 11: Using Relational Operators -- UNION -- INTERSECT -- EXCEPT -- Join Operators -- ON versus WHERE -- Chapter 12: Delving Deep with Nested Queries -- What Subqueries Do -- Chapter 13: Recursive Queries -- What Is Recursion? -- What Is a Recursive Query? -- Where Might You Use a Recursive Query? -- Where Else Might You Use a Recursive Query? -- Part IV: Controlling Operations -- Chapter 14: Providing Database Security -- The SQL Data Control Language -- User Access Levels -- Granting Privileges to Users -- Granting Privileges across Levels -- Granting the Power to Grant Privileges -- Taking Privileges Away -- Using GRANT and REVOKE Together to Save Time and Effort -- Chapter 15: Protecting Data -- Threats to Data Integrity -- Reducing Vulnerability to Data Corruption -- Constraints Within Transactions -- Chapter 16: Using SQL within Applications -- SQL in an Application -- Hooking SQL into Procedural Languages -- Part V: Taking SQL to the Real World -- Chapter 17: Accessing Data with ODBC and JDBC -- ODBC -- ODBC in a Client/Server Environment -- ODBC and the Internet -- ODBC and an Intranet -- JDBC -- Chapter 18: Operating on XML Data with SQL -- How XML Relates to SQL -- The XML Data Type -- Mapping SQL to XML and XML to SQL -- SQL Functions That Operate on XML Data -- Predicates -- Transforming XML Data into SQL Tables -- Mapping Non-Predefined Data Types to XML -- The Marriage of SQL and XML -- Part VI: Advanced Topics -- Chapter 19: Stepping through a Dataset with Cursors -- Declaring a Cursor -- Opening a Cursor -- Fetching Data from a Single Row -- Closing a Cursor.

Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules -- Compound Statements -- Flow of Control Statements -- Stored Procedures -- Stored Functions -- Privileges -- Stored Modules -- Chapter 21: Handling Errors -- SQLSTATE -- WHENEVER Clause -- Diagnostics Areas -- Handling Exceptions -- Chapter 22: Triggers -- Examining Some Applications of Triggers -- Creating a Trigger -- Firing a Succession of Triggers -- Referencing Old Values and New Values -- Firing Multiple Triggers on a Single Table -- Part VII: The Part of Tens -- Chapter 23: Ten Common Mistakes -- Assuming That Your Clients Know What They Need -- Ignoring Project Scope -- Considering Only Technical Factors -- Not Asking for Client Feedback -- Always Using Your Favorite Development Environment -- Using Your Favorite System Architecture Exclusively -- Designing Database Tables in Isolation -- Neglecting Design Reviews -- Skipping Beta Testing -- Not Documenting Your Process -- Chapter 24: Ten Retrieval Tips -- Verify the Database Structure -- Try Queries on a Test Database -- Double-Check Queries That Include Joins -- Triple-Check Queries with Subselects -- Summarize Data with GROUP BY -- Watch GROUP BY Clause Restrictions -- Use Parentheses with AND, OR, and NOT -- Control Retrieval Privileges -- Back Up Your Databases Regularly -- Handle Error Conditions Gracefully -- Appendix: SQL: 2011 Reserved Words -- Index -- About the Author -- Dedication -- Author's Acknowledgments.