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.
Covering database management systems - including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 - this book helps you master the SQL fundamentals. It also helps you move quickly through SQL basics and learn several advanced features as well as use SQL data statements to generate, manipulate, and retrieve data.