Learning pathsql
SQL Analyst Path
Build confidence with read-only investigation: duplicates, cohorts, windows, stable ordering, and audit-friendly result sets.
Path reward
SQL Analyst
Analysts, students, and backend engineers who need SQL that survives real business questions.
Demo progress: start the first mission to begin tracking.
Read-only investigator
Filter, group, and order results safely. Required clears: 2.
Cohort builder
Join event and user data without double counting. Required clears: 5.
Analytics finisher
Explain business meaning and edge cases. 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 retention cohort matrix
Easy SQL arena: date bucketing, joins, and cohort aggregation
Step 3
Warm up with window ranking leaderboard
Easy SQL arena: RANK, ROW_NUMBER, partitions, and deterministic tie breakers
Step 4
Stabilize duplicate transaction detector
Medium SQL arena: GROUP BY, HAVING, tie-safe ordering, and read-only analysis
Step 5
Stabilize retention cohort matrix
Medium SQL arena: date bucketing, joins, and cohort aggregation
Step 6
Stabilize window ranking leaderboard
Medium SQL arena: RANK, ROW_NUMBER, partitions, and deterministic tie breakers
Step 7
Harden duplicate transaction detector
Hard SQL arena: GROUP BY, HAVING, tie-safe ordering, and read-only analysis
Step 8
Harden retention cohort matrix
Hard SQL arena: date bucketing, joins, and cohort aggregation