Every module includes three substantial lessons, downloadable source files, practical exercises, explained solutions and a knowledge check. Modules marked free are available under the current public access rules. Protected self-learning modules are free after registration and email verification. Publication, prerequisites and explicit private-access rules still apply.
01Free module
ETL and ELT Pipeline Architecture
Separate pipeline stages, define contracts and prevent partial success from appearing complete.
- An ETL/ELT stage diagram
- A validated local snapshot run
- A publication and failure contract
Overview & practice files ↗View lesson outline
- Choose ETL or ELT from the workload
- Implement ingestion, transformation and validation
- Define publication and failure boundaries
02Free module
Data Warehouses and Data Lakes
Separate storage roles and design analytical facts without confusing format with governance.
- A storage-role decision record
- A fact/dimension grain model
- A partition/retention and reprocessing contract
Overview & practice files ↗View lesson outline
- Compare warehouse, lake and lakehouse roles
- Model facts, dimensions and historical context
- Define partitions, retention and quality contracts
03Free · verified account
Apache Spark and Distributed Processing
Understand partitions and shuffles with a tested local analogue and an optional Spark lab.
- A reconciled partition calculation
- An optional Spark transformation walkthrough
- An execution and verification record
View access requirements ↗View lesson outline
- Reason about partitions and partial aggregates · Verified account
- Read and transform a Spark DataFrame · Verified account
- Inspect execution, shuffles and operational limits · Verified account
04Free · verified account
Workflow Orchestration with Airflow
Declare dependencies and retries without confusing a DAG definition with a successful run.
- A dependency and failure graph
- A parse-time/task-time review
- A retry, backfill and acceptance policy
View access requirements ↗View lesson outline
- Define a DAG and dependency contract · Verified account
- Separate DAG parsing from task execution · Verified account
- Choose retry and scheduling policies deliberately · Verified account
05Free · verified account
Cloud Data Platforms
Compare service responsibilities and design a no-provisioning architecture exercise.
- A three-provider role matrix
- An access/region/cost decision record
- A justified local-versus-managed recommendation
View access requirements ↗View lesson outline
- Map managed services to responsibilities · Verified account
- Design access, region and cost boundaries · Verified account
- Compare a local baseline with a future managed option · Verified account
06Free · verified account
End-to-End Data Pipeline Project
Deliver an auditable pipeline with validation, failure evidence and an operating handover.
- A pipeline acceptance contract
- Executed baseline, rerun and failure tests
- An operating/recovery handover and extension
View access requirements ↗View lesson outline
- Define the pipeline contract and deliverables · Verified account
- Execute and test the workflow · Verified account
- Hand over operations and recovery · Verified account
07Free · verified account
Warehouse transformations, dbt and query review
Trace a corrected order through a warehouse model: use an original fictional source to implement, verify and explain three connected professional assignments.
- Source/metric/access contract
- Independent implementation and exact run instructions
- Unchanged control and changed-input/failure evidence
- Decision memo with limitations and next evidence
View access requirements ↗View lesson outline
- Trace a corrected order through a warehouse model · Verified account
- Build dbt-style transformations and meaningful data tests · Verified account
- Review a query plan without inventing a speed claim · Verified account
08Free · verified account
Governance, lineage and responsible AI review
Build a privacy-conscious reporting view: use an original fictional source to implement, verify and explain three connected professional assignments.
- Source/metric/access contract
- Independent implementation and exact run instructions
- Unchanged control and changed-input/failure evidence
- Decision memo with limitations and next evidence
View access requirements ↗View lesson outline
- Build a privacy-conscious reporting view · Verified account
- Trace data lineage and review a changed definition · Verified account
- Review AI risk, group metrics and audit evidence · Verified account
