Yiga AI

Course 10 of 17

SQL for Analysts

SELECT & WHERE, Joins, Group by, and more.

Yiga AI

Beginner en

Beginner · Course · 4 weeks at 5 hrs/week

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

What you’ll learn

Skills you can put to work.

Introduction to Python

Intermediate Python

Data Manipulation with pandas

Data Cleaning in Python

Syllabus

Every module, step by step.

4 modules · 25 lessons · 17 hours · 1 graded project

1000 minutes of guided lesson time.

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

Module 1 · 6 lessons · 3.7 hoursSELECT & WHEREModule 1 of 4 in SQL for Analysts.

  1. Overview and set-up

    Overview and set-up — SELECT & WHERE in SQL for Analysts.

    Lesson

    40 min

  2. Core concepts

    Core concepts — SELECT & WHERE in SQL for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — SELECT & WHERE in SQL for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — SELECT & WHERE in SQL for Analysts.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — SELECT & WHERE in SQL for Analysts.

    Lesson · Locked

    40 min

  6. Module quiz: SELECT & WHERE

    Check what you learned in SELECT & WHERE before moving on.

    Quiz · Locked

    20 min
Module 2 · 6 lessons · 3.7 hours LockedJoinsModule 2 of 4 in SQL for Analysts.

  1. Overview and set-up

    Overview and set-up — Joins in SQL for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Joins in SQL for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Joins in SQL for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Joins in SQL for Analysts.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Joins in SQL for Analysts.

    Lesson · Locked

    40 min

  6. Module quiz: Joins

    Check what you learned in Joins before moving on.

    Quiz · Locked

    20 min
Module 3 · 6 lessons · 3.7 hours LockedGroup byModule 3 of 4 in SQL for Analysts.

  1. Overview and set-up

    Overview and set-up — Group by in SQL for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Group by in SQL for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Group by in SQL for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Group by in SQL for Analysts.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Group by in SQL for Analysts.

    Lesson · Locked

    40 min

  6. Module quiz: Group by

    Check what you learned in Group by before moving on.

    Quiz · Locked

    20 min
Module 4 · 7 lessons · 5.7 hours LockedSubqueriesModule 4 of 4 in SQL for Analysts.

  1. Overview and set-up

    Overview and set-up — Subqueries in SQL for Analysts.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Subqueries in SQL for Analysts.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Subqueries in SQL for Analysts.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Subqueries in SQL for Analysts.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Subqueries in SQL for Analysts.

    Lesson · Locked

    40 min

  6. Module quiz: Subqueries

    Check what you learned in Subqueries before moving on.

    Quiz · Locked

    20 min

  7. Graded project: SQL for Analysts

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

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: SQL for Analysts 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 Python.

See the full chain

Next lesson

Overview and set-up

SQL for Analysts

40 min · Resume

Course 11 in the track

Intermediate Python

Loops & logic, Error handling, Modules, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 12 in the track

Hypothesis Testing in Python

t-tests, Chi-square, A/B testing, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 13 in the track

Project: Agricultural Yield Analysis (Uganda)

Import data, Seasonal trends, Regional comparison, and more.

Intermediate · 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 courseData Manipulation with pandasNext courseIntermediate Python

Keep going

Other courses in this track.

View full track
Python for Beginners cover illustration
Programming

24 lessons · 19.3h · Beginner

Python for Beginners

Write your first programs, work with data, and build a small command-line project.

Yiga Plus
Data Analysis with Pandas cover illustration
Data

25 lessons · 19.5h · Intermediate

Data Analysis with Pandas

Clean, explore and visualise real African datasets to answer practical questions.

Yiga Plus
Data Cleaning in Python cover illustration
Data

16 lessons · 14h · Intermediate

Data Cleaning in Python

Missing values, Duplicates, Types & dates, and more.

Yiga Plus