SQL joins and GROUP BY, with free practice databases
10 steps · about 3 h 45 min · Beginner
- SQL JOIN for Beginners with Diagrams & Interactive Examples (interactive, Beekeeper Studio, 25 min)
Diagrams and in-browser exercises on a tiny employees/departments dataset show what each join does.
- SQL Joins Explained: INNER, LEFT, RIGHT, CROSS (and the Comma Join) (tutorial, DbGate, 15 min)
A second short explanation reinforces the four core join types and shows how the old comma join relates to CROSS JOIN.
- SQL Joins with WHERE - Interactive Tutorial (interactive, SQL Easy, 15 min)
You practise filtering joined rows on a real SQLite database in your browser, with hints.
- SQL Multiple joins - Interactive Tutorial (interactive, SQL Easy, 15 min)
Real data is spread over several tables, and this exercise has you chain two joins through a linking table.
- SQL JOIN Practice Exercises Online (interactive, site-ql, 40 min)
Graded JOIN exercises on live PostgreSQL, from reading a join to writing one, lock in the skill before you add aggregation.
- SQL GROUP BY (tutorial, SQLTutorial.org, 20 min)
This introduces grouping rows and applying COUNT, SUM, AVG, MIN and MAX to each group, using a sample employees database.
- SQL GROUP BY: Group & Aggregate Data (with Examples) (tutorial, ThoughtSpot, 20 min)
It adds ordering and limits to grouped results and ends with practice problems on a stock price table.
- SQL GROUP BY — Aggregate Data Tutorial with Practice Exercises (interactive, py-spark-sql.com, 25 min)
It clarifies WHERE versus HAVING (filtering rows before grouping versus groups after) in a free browser SQL editor.
- SQL GROUP BY Statement (interactive, sql-practice.com, 20 min)
Run grouped counts on a realistic patients database to see aggregation on data that isn't a toy example.
- SQL GROUP BY Tutorial — Aggregation, HAVING, and the 5 Mistakes Most Analysts Make (article, SQLQuest, 30 min)
Finish with the grouping rule, conditional aggregation and common bugs, so your joined and grouped queries come out right.