SQL: CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, joins, aggregates and GROUP BY

What this note covers

1. Creating tables with constraints and referential integrity
2. INSERT, UPDATE, ALTER and DELETE (including cascading deletes)
3. SELECT: filtering, pattern matching and sorting
4. Aggregate functions and GROUP BY
5. Inner joins across up to four tables
6. Calculated and concatenated fields with aliases
7. Cleaning data for import, and exam technique

7 sections · 12 key terms & formulas · 6 common mistakes