SQLRepPracticeMock interviewGuidesPlaygroundLearning path

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.

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