Yiga AI

Course 4 of 11

Advanced SQL for Engineers

Performance, Partitioning, Transactions, and more.

Yiga AI

Intermediate en

Intermediate · Course · 4 weeks at 5 hrs/week

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

What you’ll learn

Skills you can put to work.

Data Engineering Foundations

Advanced SQL for Engineers

Python for Data Engineering

Data Warehousing

Syllabus

Every module, step by step.

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

1008 minutes of guided lesson time.

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

Module 1 · 7 lessons · 3.8 hoursPerformanceModule 1 of 4 in Advanced SQL for Engineers.

  1. Quick start: your first useful AI result

    A 5–10 minute win you can use today.

    Lesson

    8 min

  2. Overview and set-up

    Overview and set-up — Performance in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  3. Core concepts

    Core concepts — Performance in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  4. Worked example

    Worked example — Performance in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  5. Hands-on practice

    Hands-on practice — Performance in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  6. Common pitfalls

    Common pitfalls — Performance in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  7. Module quiz: Performance

    Check what you learned in Performance before moving on.

    Quiz · Locked

    20 min
Module 2 · 6 lessons · 3.7 hours LockedPartitioningModule 2 of 4 in Advanced SQL for Engineers.

  1. Overview and set-up

    Overview and set-up — Partitioning in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Partitioning in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Partitioning in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Partitioning in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Partitioning in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  6. Module quiz: Partitioning

    Check what you learned in Partitioning before moving on.

    Quiz · Locked

    20 min
Module 3 · 6 lessons · 3.7 hours LockedTransactionsModule 3 of 4 in Advanced SQL for Engineers.

  1. Overview and set-up

    Overview and set-up — Transactions in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Transactions in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Transactions in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Transactions in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Transactions in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  6. Module quiz: Transactions

    Check what you learned in Transactions before moving on.

    Quiz · Locked

    20 min
Module 4 · 7 lessons · 5.7 hours LockedProceduresModule 4 of 4 in Advanced SQL for Engineers.

  1. Overview and set-up

    Overview and set-up — Procedures in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Procedures in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Procedures in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Procedures in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Procedures in Advanced SQL for Engineers.

    Lesson · Locked

    40 min

  6. Module quiz: Procedures

    Check what you learned in Procedures before moving on.

    Quiz · Locked

    20 min

  7. Graded project: Advanced SQL for Engineers

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

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Advanced SQL for Engineers 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
Joel N., Career readiness

Your instructor

Joel N.

Career readiness

Connects technical learning to portfolios, interviews and confident career moves.

Amina Hassan, Yiga learner

“The track removed the uncertainty. I knew what to learn next and what to show employers.”

Amina Hassan

Career switcher, Dar es Salaam

Continue with

Your next best step.

Following the order of Data Engineer.

See the full chain

Next lesson

Quick start: your first useful AI result

Advanced SQL for Engineers

8 min · Resume

Course 5 in the track

Data Quality & Governance

Validation, Lineage, Privacy, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 6 in the track

Data Engineering Foundations

Roles, Architectures, Batch vs streaming, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 7 in the track

Big Data with Spark

RDDs & DataFrames, Transformations, Optimisation, 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 coursePython for Data EngineeringNext courseData Quality & Governance

Keep going

Other courses in this track.

View full track
Streaming with Kafka cover illustration
Data

16 lessons · 14h · Advanced

Streaming with Kafka

Topics, Producers/consumers, Stream processing, and more.

Yiga Plus
Cloud Data Platforms cover illustration
Data

20 lessons · 16.7h · Intermediate

Cloud Data Platforms

AWS/GCP/Azure services, Storage, IAM, and more.

Yiga Plus