Learning SQL /
Beaulieu, Alan,
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.
9780596520830
2009497287
SQL (Computer program language)
QA76.73.S67 / B43 2009
005.756 BE.L 2009
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.
9780596520830
2009497287
SQL (Computer program language)
QA76.73.S67 / B43 2009
005.756 BE.L 2009
