SQL Practice Tracks

Use practice to move from syntax knowledge to query fluency.

This section has three modes:

• Skill Drills: short targeted exercises (easy → hard)
• Timed Tracks: speed-focused autograded sprints (10/20/30 min)
• Industry Tracks: realistic datasets and business-style assignments

Start with:

• SQL Core 10-Exercise Track
• SQL foundations
• Join fundamentals
• GROUP BY
• CASE WHEN
• Date functions
• Window functions
• Subqueries & set operations
• Joins and aggregation
• Event funnels

Start with:

• Timed Tracks Overview
• 10-Minute Foundations Sprint
• 20-Minute Joins and KPI Sprint
• 30-Minute Business Case Sprint

Eight pages from schema to capstone: premiums, claims, loss ratios, and claims aging. Start with the Insurance Track Overview, then follow its flow: star schema → meet the dataset → data quality audit → graded drills → KPI assignments → loss ratio trends → capstone.

Orders, returns, customer value, and conversion. Start with the E-commerce Track Overview, then follow its flow: star schema → meet the dataset → data quality audit → graded drills → KPI assignments → RFM segmentation → funnel analysis → capstone.

MRR, churn, net revenue retention, and the MRR bridge. These are the metrics every SaaS analytics interview asks about. Start with the SaaS Track Overview, then follow its flow: star schema → meet the dataset → graded drills → KPI assignments → capstone.

Common mistakes:

• jumping to complex joins before validating row counts and grain assumptions
• finishing a query without basic validation checks against expected totals

Next step:

• choose one track and complete the first two drills in sequence before switching tracks.
• not sure where to begin? start with the SQL Core 10-Exercise Track.