Step 1

Intro

Step 2

Data and Tables: A place for everything

Step 3

The SELECT Statement: Gifted data retrieval

Step 4

DELETE and UPDATE: A change will do you good

Step 5

Smart Table Design: Why be normal?

Step 6

appendix ii: MySQL installation

Step 7

ALTER: Rewriting the past

Step 8

Advanced SELECT: Seeing your data with new eyes

Step 9

Multi-table Database Design: Outgrowing your table

Step 10

Joins and Multi-table Operations: Can’t we all just get along?

Step 11

Subqueries: Queries Within Queries

Step 12

Outer Joins, Self Joins, and Unions: New maneuvers

Step 13

Constraints, Views, and Transactions: Too many cooks spoil the database

Step 14

appendix iii: tools roundup

Step 15

Security: Protecting your assets

Step 16

appendix i: leftovers