SQL Foundations, Start to Finish

Every core SQL idea in the order they build on each other: tables and grain, the six clauses and the order they really run in, NULL, filtering, aggregation, GROUP BY and HAVING, joins, CASE, subqueries, CTEs, window functions, keys and indexes.