Yiga AI

Course 5 of 11

Intermediate SQL

Aggregation, CASE, Subqueries, and more.

Yiga AI

Intermediate en

Intermediate · 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 hoursAggregationModule 1 of 4 in Intermediate SQL.

  1. Overview and set-up

    Overview and set-up — Aggregation in Intermediate SQL.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Aggregation in Intermediate SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Aggregation in Intermediate SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Aggregation in Intermediate SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Aggregation

    Check what you learned in Aggregation before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedCASEModule 2 of 4 in Intermediate SQL.

  1. Overview and set-up

    Overview and set-up — CASE in Intermediate SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — CASE in Intermediate SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — CASE in Intermediate SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — CASE in Intermediate SQL.

    Lesson · Locked

    40 min

  5. Module quiz: CASE

    Check what you learned in CASE before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedSubqueriesModule 3 of 4 in Intermediate SQL.

  1. Overview and set-up

    Overview and set-up — Subqueries in Intermediate SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Subqueries in Intermediate SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Subqueries in Intermediate SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Subqueries in Intermediate SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Subqueries

    Check what you learned in Subqueries before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedCTEsModule 4 of 4 in Intermediate SQL.

  1. Overview and set-up

    Overview and set-up — CTEs in Intermediate SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — CTEs in Intermediate SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — CTEs in Intermediate SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — CTEs in Intermediate SQL.

    Lesson · Locked

    40 min

  5. Module quiz: CTEs

    Check what you learned in CTEs before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Intermediate SQL

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

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Intermediate 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
Daniel O., Data & analytics

Your instructor

Daniel O.

Data & analytics

Turns real African data problems into practical lessons learners can apply immediately.

Brian Okello, Yiga learner

“The course content made machine learning understandable, and the practice kept me moving.”

Brian Okello

Software developer, Kampala

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

Intermediate SQL

40 min · Resume

Course 6 in the track

Excel & Google Sheets for Analysts

Formulas, Pivot tables, Lookups, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 7 in the track

Window Functions & Advanced SQL

RANK/ROW_NUMBER, Running totals, LAG/LEAD, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 8 in the track

DAX Fundamentals

Measures, CALCULATE, Time intelligence, and more.

Intermediate · Course · 4 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseDashboard Design & StorytellingNext courseExcel & Google Sheets for Analysts

Keep going

Other courses in this track.

View full track