Defining columns
Every column type, the modifiers you can chain, and how identifiers are validated.
Keys and indexes
Primary keys, unique constraints, foreign keys and indexes, and the names they are given.
Altering tables
Adding, dropping, renaming and changing columns and keys on a table that already exists.