Yiga AI

Course 10 of 11

Introduction to SQL

Databases, SELECT, Filtering, 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 hoursDatabasesModule 1 of 4 in Introduction to SQL.

  1. Overview and set-up

    Overview and set-up — Databases in Introduction to SQL.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Databases in Introduction to SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Databases in Introduction to SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Databases in Introduction to SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Databases

    Check what you learned in Databases before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedSELECTModule 2 of 4 in Introduction to SQL.

  1. Overview and set-up

    Overview and set-up — SELECT in Introduction to SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — SELECT in Introduction to SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — SELECT in Introduction to SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — SELECT in Introduction to SQL.

    Lesson · Locked

    40 min

  5. Module quiz: SELECT

    Check what you learned in SELECT before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedFilteringModule 3 of 4 in Introduction to SQL.

  1. Overview and set-up

    Overview and set-up — Filtering in Introduction to SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Filtering in Introduction to SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Filtering in Introduction to SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Filtering in Introduction to SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Filtering

    Check what you learned in Filtering before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedSortingModule 4 of 4 in Introduction to SQL.

  1. Overview and set-up

    Overview and set-up — Sorting in Introduction to SQL.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Sorting in Introduction to SQL.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Sorting in Introduction to SQL.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Sorting in Introduction to SQL.

    Lesson · Locked

    40 min

  5. Module quiz: Sorting

    Check what you learned in Sorting before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Introduction to SQL

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

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Introduction to 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
Mariam K., Software & cloud

Your instructor

Mariam K.

Software & cloud

Helps new developers build reliable products through clear explanations and guided practice.

Diana Nsiiza, Yiga learner

“I use what I learned in my work now, not in some distant future project.”

Diana Nsiiza

Data analyst, Entebbe

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

Introduction to SQL

40 min · Resume

Course 11 in the track

Joining Data in SQL

Inner/outer joins, Self joins, Set operations, 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 courseDatabase Design BasicsNext courseJoining Data in SQL

Keep going

Other courses in this track.

View full track