Previous edition: 2010. Includes index. "A Wiley Brand."

Introduction -- Part 1. Getting started with SQL. Relational database fundamentals -- SQL fundamentals -- The components of SQL -- Part II. Using SQL to build databases. Building and maintaining a simple database structure -- Building a multitable relational database -- Part III. Storing and retrieving data. Manipulating database data -- Handling temporal data -- Specifying values -- Using advanced SQL value expressions -- Zeroing in on the data you want -- Using relational operators -- Delving deep with nested queries -- Recursive queries -- Part IV. Controlling operations. Providing database security -- Protecting data -- Using SQL within applications -- Part V. Taking SQL to the real world. Accessing data with ODBC and JDBC -- Operating on XML data with SQL -- Part VI. Advanced topics. Stepping through a dataset with cursors -- Adding procedural capabilities with persistent stored modules -- Handling errors -- Triggers -- Part VII. The part of tens. Ten common mistakes -- Ten retrieval tips -- Appendix: SQL: 2011 reserved words -- Index. Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease.