Chapter 1, A Little Background
Explores the history of computerized databases, including the rise of the relational model and the SQL language.
Chapter 2, Creating and Populating a Database
Demonstrates how to create a MySQL database, create the tables used for the examples in this book, and populate the tables with data.
Chapter 3, Query Primer
Introduces the select statement and further demonstrates the most common clauses (select, from, where).
Chapter 4, Filtering
Demonstrates the different types of conditions that can be used in the where clause of a select, update, or delete statement.
Chapter 5, Querying Multiple Tables
Shows how queries can utilize multiple tables via table joins.
Chapter 6, Working with Sets
This chapter is all about data sets and how they can interact within queries.
Chapter 7, Data Generation, Manipulation, and Conversion
Demonstrates several built-in functions used for manipulating or converting data.
Chapter 8, Grouping and Aggregates
Shows how data can be aggregated.
Chapter 9, Subqueries
Introduces subqueries (a personal favorite) and shows how and where they can be utilized.
Chapter 10, Joins Revisited
Further explores the various types of table joins.
Chapter 11, Conditional Logic
Explores how conditional logic (i.e., if-then-else) can be utilized in select, insert, update, and delete statements.
Chapter 12, Transactions
Introduces transactions and shows how to use them.
Chapter 13, Indexes and Constraints
Explores indexes and constraints.
Chapter 14, Views
Shows how to build an interface to shield users from data complexities.
Chapter 15, Metadata
Demonstrates the utility of the data dictionary.
Chapter 16, Analytic Functions
Covers functionality used to generate rankings, subtotals, and other values used heavily in reporting and analysis.
Chapter 17, Working with Large Databases
Demonstrates techniques for making very large databases easier to manage and traverse.
Chapter 18, SQL and Big Data
Explores the transformation of the SQL language to allow retrieval of data from nonrelational data platforms.
