Free download
The Everyday SQL Pack
The SQL that does most of the work, and the logic that makes it click.
Two one-page references in a single PDF: the five clauses that answer most business questions, and the five ideas that explain why SQL behaves the way it does. Print it, pin it, keep it open next to your editor.
What's inside
- The 20% of SQL that does 80% of the work: SELECT, WHERE, GROUP BY, JOIN and HAVING
- The order SQL actually runs your query in, and why it matters
- WHERE vs HAVING, settled
- Subqueries, sets not rows, and how NULL really behaves
- A worked query that uses all of it