SQL joins and GROUP BY, with free practice databases

10 steps · about 3 h 45 min · Beginner

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.