Learning SQL /
Learning Structured Query Language
Alan Beaulieu.
- 2nd ed.
- Beijing ; Sebastopol : O'Reilly, c2009.
- xiii, 320 p. : ill. ; 24 cm.
Includes index.
A little background -- Creating and populating a database -- Query primer -- Filtering -- Querying multiple tables -- Working with sets -- Data generation, conversion, manipulation -- Grouping and aggregates -- Subqueries -- Joins revisited -- Conditional logic -- Transactions -- Indexes and constraints -- Views -- Metadata -- ER diagram for example database -- MySQL extensions to the SQL language.
"Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server2008.