Data Engineering
Master the fundamentals of data pipelines, SQL, cloud warehouses, and system design to land a data engineering role.
Modules
SQL Foundations
Window functions, CTEs, subqueries, and query optimisation — the SQL skills every data engineering interview tests.
SQL Practice Quiz
20 questions covering window functions, CTEs, joins, and query optimisation.
Data Modelling
Star schema, snowflake schema, normalisation, slowly changing dimensions, and wide tables.
Pipeline Architecture
Batch vs streaming, orchestration with Airflow, idempotency, and fault tolerance.
dbt Fundamentals
Models, materializations, tests, sources, and the dbt project structure.
dbt Practice Quiz
15 questions on dbt models, tests, materializations, and Jinja macros.
System Design: Data Warehouse
Design a scalable data warehouse for a growing e-commerce company. Walk through decisions on storage, processing, modelling, and serving.
Interview Prep: Behavioural & Technical
Common data engineering interview questions, the STAR framework, and what interviewers actually look for.