Learning SQL /
Learning Structured Query Language
Alan Beaulieu.
- Second edition.
- xiii, 320 pages : illustrations ; 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. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn.