Data Science · generic · intermediate
Data Engineering Foundations
A hands-on introduction to the modern data stack. Learn advanced SQL, build ETL pipelines with Python and Airflow, load data into cloud warehouses, process real-time streams with Kafka, and transform data with dbt. Finish with an end-to-end data platform capstone.
- 8 hours
- 25 lessons
- 6 modules
- updated April 2026
Try it before you sign up
Read a full lesson and answer 3 questions from the Module 1 quiz. No account needed.
Window Functions & CTEs
6 modules, 25 lessons
Module 1 is free — lessons, hands-on walkthrough and quiz.
- readWindow Functions & CTEs15 min
- videoSQL Window Functions Tutorial12 min
- readQuery Optimisation & EXPLAIN15 min
- hands-onSQL Lab: Analytical Queries on Real Data30 min
- quizQuiz: Advanced SQL10 min
Built by the CloudaQube team
No celebrity instructor — here is exactly what goes into the course instead.
- 01 6 guided hands-on walkthroughs you run in a real environment.
- 02 6 module quizzes — every answer comes with an explanation.
- 03 Last updated April 2026.
- 04 Any module can become a hands-on lab in Labs Studio.
What you'll be able to do
- 01 Write advanced SQL with window functions, CTEs, and query optimisation
- 02 Build and schedule ETL pipelines with Python and Apache Airflow
- 03 Design star schemas, optimise Redshift tables with distribution and sort keys, and understand Snowflake's compute-storage separation architecture
- 04 Process real-time event streams with Apache Kafka
- 05 Transform and test data in the warehouse with dbt
- 06 Build an end-to-end data platform from ingestion to visualisation
- — Python basics (functions, loops, file I/O)
- — Familiarity with SQL SELECT statements
Before you start
How long does it take?
About 8 hours of lessons, videos and hands-on walkthroughs across 6 modules.
What’s free?
Module 1 in full — lessons, hands-on walkthrough and quiz — with no card required. Any paid plan (from $8.99/mo) unlocks all 6 modules, and starts with a 14-day free trial.
Start the course with Module 1 free.
No card required. Unlock every module from $8.99/mo when you’re ready.