Skip to main content
ANVISoftware Solutions

Module 03 of 06 · SQL & Database Fundamentals

Combining and Summarising

Answer questions that span tables, and reduce many rows to the numbers someone asked for.

4 of 4 lessons available

Lessons in this module

  1. 01

    Joins

    Intermediate

    Combine tables with inner, left, right and full joins, and predict the row count.

    22 min
  2. 02

    Grouping and Aggregation

    Intermediate

    Summarise rows into totals and counts, and filter groups with HAVING.

    18 min
  3. 03

    Subqueries

    Intermediate

    Use a query inside another, and know when a join is clearer.

    17 min
  4. 04

    Common Table Expressions

    Intermediate

    Break a complex query into readable named steps.

    16 min

Have a project worth talking through?

Tell us what you're building or what's slowing your current system down. We'll give you a direct read on scope and approach.

Start a ConversationExplore Our Services