Yiga AI

Course 7 of 11

Window Functions & Advanced SQL

RANK/ROW_NUMBER, Running totals, LAG/LEAD, 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 hoursRANK/ROW_NUMBERModule 1 of 4 in Window Functions & Advanced SQL.

  1. Overview and set-up

    Overview and set-up — RANK/ROW_NUMBER in Window Functions & Advanced SQL.

    Lesson

    40 min

  2. Core concepts

    Core concepts — RANK/ROW_NUMBER in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — RANK/ROW_NUMBER in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — RANK/ROW_NUMBER in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  5. Module quiz: RANK/ROW_NUMBER

    Check what you learned in RANK/ROW_NUMBER before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedRunning totalsModule 2 of 4 in Window Functions & Advanced SQL.

  1. Overview and set-up

    Overview and set-up — Running totals in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Running totals in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Running totals in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Running totals in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Running totals

    Check what you learned in Running totals before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedLAG/LEADModule 3 of 4 in Window Functions & Advanced SQL.

  1. Overview and set-up

    Overview and set-up — LAG/LEAD in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — LAG/LEAD in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — LAG/LEAD in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — LAG/LEAD in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  5. Module quiz: LAG/LEAD

    Check what you learned in LAG/LEAD before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedQuery optimisationModule 4 of 4 in Window Functions & Advanced SQL.

  1. Overview and set-up

    Overview and set-up — Query optimisation in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Query optimisation in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Query optimisation in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Query optimisation in Window Functions & Advanced SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Query optimisation

    Check what you learned in Query optimisation before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Window Functions & Advanced SQL

    Apply everything from Window Functions & Advanced SQL in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Window Functions & Advanced 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

Window Functions & Advanced SQL

40 min · Resume

Course 8 in the track

DAX Fundamentals

Measures, CALCULATE, Time intelligence, and more.

Intermediate · Course · 4 weeks at 5 hrs/week

Course 9 in the track

Database Design Basics

Tables & keys, Normalisation, Schemas, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 10 in the track

Introduction to SQL

Databases, SELECT, Filtering, and more.

Beginner · Course · 3 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 courseExcel & Google Sheets for AnalystsNext courseDAX Fundamentals

Keep going

Other courses in this track.

View full track