Full syllabus

Beginner

Python Programming Basics

  1. Syntax, Variables and Data Structures
  2. Functions, Modules and Working with Files
  3. Introduction to pandas

SQL Basics

  1. Tables, SELECT and Filtering
  2. Joins, GROUP BY and Aggregation

Git and the Command Line

  1. Command Line Essentials
  2. Git and GitHub Basics

Intermediate

Advanced SQL and Data Modelling

  1. Window Functions and CTEs
  2. Data Modelling: Facts, Dimensions and Normalisation

ETL/ELT Pipelines and Orchestration

  1. ETL vs ELT and Pipeline Design
  2. Orchestration with Apache Airflow
  3. Transformations with dbt

Advanced

Big Data Processing with Spark

  1. How Distributed Processing Works
  2. PySpark DataFrames

Cloud Warehouses and Lakehouses

  1. Cloud Data Warehouses
  2. Data Lakes and the Lakehouse

Streaming and Data Quality

  1. Streaming with Apache Kafka
  2. Data Quality, Testing and Observability

Data Engineer Practice and Interview Prep

  1. An End-to-End Portfolio Pipeline
  2. SQL, Coding and Pipeline Design Rounds