Querying data
From zero to genuinely comfortable writing SQL against real tables.
- Relational thinking: tables, rows, keys, relationships
- SELECT, WHERE, ORDER BY, GROUP BY and aggregate functions
- Joins — inner, left, and the mistakes everyone makes with them
- Cleaning messy data: nulls, duplicates, types, dates