TY - BOOK AU - Beaulieu,Alan TI - Learning SQL SN - 9780596520830 AV - QA76.73.S67 B43 2009 U1 - 005.756 BE.L 2009 23 PY - 2009/// CY - Beijing PB - O'Reilly KW - SQL (Computer program language) N1 - 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 N2 - 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 ER -