SQL cheat sheets
One page per module: every concept in a sentence or two with a short example. Free to read and print, and handy for a last look before an interview.
- Module 1SQL Basics cheat sheet Your first queries: pick columns, filter rows and sort results from a single table.12 concepts
- Module 2Summarizing Data cheat sheet Count, add up and average: turn thousands of rows into a few useful numbers.5 concepts
- Module 3Joining Tables cheat sheet Combine tables without losing or duplicating rows.9 concepts
- Module 4Window Functions cheat sheet Rankings, running totals and comparisons with the previous row, while keeping every row.12 concepts
- Module 5CTEs & Reshaping Data cheat sheet Break hard questions into steps, work with dates, and pivot rows into columns.9 concepts
- Module 6Interview Classics cheat sheet The patterns that come up again and again in data analyst SQL screens.12 concepts
- Module 7Database Analyst cheat sheet Find and fix bad data, and change data safely with UPDATE, DELETE and upserts.10 concepts
- Module 8Analytics Patterns cheat sheet Retention cohorts, sessionization, gaps and islands, attribution: real product analytics.15 concepts