Learning pathsql
SQL Mastery Path
Train analytics-grade SQL: duplicates, cohorts, ranking, recursion, indexing, and fraud-style investigation.
Path reward
SQL Knight
Analysts, backend engineers, data candidates, and anyone prepping for SQL-heavy interviews.
Demo progress: start the first mission to begin tracking.
Query blade
Write deterministic read-only investigations. Required clears: 2.
Warehouse tactician
Use windows, cohorts, and recursion safely. Required clears: 5.
Fraud hunter
Reason about scale and correctness under noisy data. Required clears: 8.
Mission chain
Step 1
Find duplicate checkout transactions
Easy SQL arena: GROUP BY, HAVING, tie-safe ordering, and read-only analysis
Step 2
Warm up with window ranking leaderboard
Easy SQL arena: RANK, ROW_NUMBER, partitions, and deterministic tie breakers
Step 3
Stabilize retention cohort matrix
Medium SQL arena: date bucketing, joins, and cohort aggregation
Step 4
Stabilize query plan index choice
Medium SQL arena: index selectivity, WHERE clauses, and explain-plan reasoning
Step 5
Harden window ranking leaderboard
Hard SQL arena: RANK, ROW_NUMBER, partitions, and deterministic tie breakers
Step 6
Harden recursive org chart
Hard SQL arena: recursive CTEs, depth limits, and cycle safety
Step 7
Rescue query plan index choice
Extreme SQL arena: index selectivity, WHERE clauses, and explain-plan reasoning
Step 8
Master duplicate transaction detector
Insane SQL arena: GROUP BY, HAVING, tie-safe ordering, and read-only analysis