Skill Drills
Learn SQL skill drills with practical examples and guided drills on dbSyntax.
Start with SQL Core 10-Exercise TrackSQL Core 10-Exercise Track
This is a full graded practice track from easy to hard. Prerequisites: SELECT, WHERE, GROUP BY JOIN basics CTEs and window function basics...
SQL foundations: three drills
Target skills: SELECT/FROM/WHERE ORDER BY/LIMIT basic GROUP BY...
Join fundamentals: five drills
Five JOIN-only drills, ordered easy → hard. Each one isolates a single JOIN concept. The default editor shows a working solution. Try cleari...
GROUP BY: five drills
Five GROUP BY drills, ordered easy to hard. Each isolates one aggregation concept. The default editor shows a working solution - try clearin...
CASE WHEN: five drills
Five CASE drills, ordered easy to hard. Each isolates one conditional-logic concept - first CASE as a row-level expression, then CASE inside...
Date functions: six drills
Six date-function drills, ordered easy to hard. Each isolates one date pattern. The default editor shows a working solution - try clearing i...
Window functions: five drills
Five window-function drills, ordered easy to hard. Each isolates one window concept. The default editor shows a working solution - try clear...
Subqueries & set operations: five drills
Five drills on subqueries and set operations, ordered easy → hard. Each one isolates a single pattern. The default editor shows a working so...
Joins and aggregation: three drills
Target skills: joining fact and dimension tables grouped metrics filtering after joins...
Event funnels: four drills
Four funnel drills, ordered easy to hard, all on one clickstream table. The funnel is view → add_to_cart → checkout → purchase. The default ...