Maquina.KANIKI@SQL

A Little Background, explores the history of computerized databases, including the rise of the relational model and the SQL language

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

Query Primer, introduces the select statement and further demonstrates the most common clauses (select, from, where).

Filtering, demonstrates the different types of conditions that can be used in the where clause of a select, update, or delete statement

Querying Multiple Tables, shows how queries can utilize multiple tables via table joins.

Data Generation, Conversion, and Manipulation, demonstrates several built-in functions used for manipulating or converting data.

Grouping and Aggregates, shows how data can be aggregated.

Subqueries, introduces the subquery (a personal favorite) and shows how and where they can be utilized.

Joins Revisited, further explores the various types of table joins

Conditional Logic, explores how conditional logic (i.e., if-then-else) can be utilized in select, insert, update, and delete statements

Transactions, introduces transactions and shows how to use them

Indexes and Constraints, explores indexes and constraints.