Yiga AI

Course 11 of 11

Joining Data in SQL

Inner/outer joins, Self joins, Set operations, and more.

Yiga AI

Beginner en

Beginner · Course · 3 weeks at 5 hrs/week

Duration
3 weeks
Effort
5 hrs/week
Lessons
16
Hands-on exercises
16
Projects
1
Language
en

What you’ll learn

Skills you can put to work.

Introduction to SQL

Joining Data in SQL

Intermediate SQL

Window Functions & Advanced SQL

Syllabus

Every module, step by step.

4 modules · 21 lessons · 14 hours · 1 graded project

840 minutes of guided lesson time.

Sign in and enrol to unlock every lesson. The first lesson is open as a preview.

Module 1 · 5 lessons · 3 hoursInner/outer joinsModule 1 of 4 in Joining Data in SQL.

  1. Overview and set-up

    Overview and set-up — Inner/outer joins in Joining Data in SQL.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Inner/outer joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Inner/outer joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Inner/outer joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Inner/outer joins

    Check what you learned in Inner/outer joins before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedSelf joinsModule 2 of 4 in Joining Data in SQL.

  1. Overview and set-up

    Overview and set-up — Self joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Self joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Self joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Self joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Self joins

    Check what you learned in Self joins before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedSet operationsModule 3 of 4 in Joining Data in SQL.

  1. Overview and set-up

    Overview and set-up — Set operations in Joining Data in SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Set operations in Joining Data in SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Set operations in Joining Data in SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Set operations in Joining Data in SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Set operations

    Check what you learned in Set operations before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedCross joinsModule 4 of 4 in Joining Data in SQL.

  1. Overview and set-up

    Overview and set-up — Cross joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Cross joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Cross joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Cross joins in Joining Data in SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Cross joins

    Check what you learned in Cross joins before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Joining Data in SQL

    Apply everything from Joining Data in SQL in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Joining Data in SQL to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Apply the course’s core skillMake and explain practical decisionsCreate evidence you can share
Grace A., AI for professions

Your instructor

Grace A.

AI for professions

Shows working professionals how to use AI responsibly inside everyday workflows.

Samuel Mwangi, Yiga learner

“The examples felt relevant to public service and worked on the connection I actually have.”

Samuel Mwangi

Public service officer, Nairobi

Continue with

Your next best step.

Following the order of Data Analyst with SQL & Power BI.

See the full chain

Next lesson

Overview and set-up

Joining Data in SQL

40 min · Resume

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseIntroduction to SQL

Keep going

Other courses in this track.

View full track