Practice by topic
Drill one skill at a time, pulled from every module and ordered easiest first. Preparing for an interview? Start with interview questions. New to SQL? The learning path takes you through everything in order.
- Selecting & filtering SELECT, WHERE, AND/OR, LIKE, IN, BETWEEN, sorting and LIMIT: getting exactly the rows you need.10 drills · 9 free
- Aggregation & GROUP BY COUNT, SUM, AVG, GROUP BY, HAVING and conditional counts.17 drills · 7 free
- Joins INNER and LEFT joins, anti-joins, self-joins, multi-table joins and UNION.15 drills · 8 free
- Subqueries & CTEs Break a hard question into steps with subqueries, WITH and recursive CTEs.9 drills · 1 free
- Window functions RANK, ROW_NUMBER, LAG/LEAD, running totals, moving averages and NTILE.16 drills · 1 free
- Dates & time Date math, grouping by month, streaks, retention windows and sessions.18 drills · 2 free
- NULLs & CASE IS NULL, COALESCE, NULLIF and CASE WHEN: the logic that trips people up.10 drills · 3 free
- Interview questions The classic SQL screen patterns: top N per group, Nth highest, duplicates, funnels, streaks and ratios.18 drills · 1 free
- Data cleaning & changes Data quality checks, deduplication, parsing messy text, UPDATE, DELETE and upserts.10 drills · Pro
- Product analytics Retention, DAU/MAU, churn, attribution, sessionization and growth metrics.15 drills · Pro