Tutorial

Grouping and Joining Data with SQL

8 steps

With the basics covered, let's take it to the next level! In order to level up first, we will touch on aggregate functions and joins next, with both being instrumental in analysing and retrieving data on a deeper level.

Join us on Discord

Helpful prior knowledge

SQL

Learning Outcomes

By the end of this tutorial, you will be able to:

  • Group data and utilise aggregate functions to summarise data
  • Use various different join methods to combine rows from different tables

Tutorial Steps

Total steps: 8

  • Step 1: Grouping Our Data
  • Step 2: Aggregate Functions for Calculations
  • Step 3: Connecting Tables
  • Step 4: Introduction to Join Statements
  • Step 5: Left Join
  • Step 6: Right Join
  • Step 7: Inner Join
  • Step 8: Full Join
Help Center Need help?

Find articles to support you through your journey or chat with our support team.

Help Center