Data Engineering Foundations
A foundation for data engineering work: schema design and integrity, transformation and cleaning, CTE pipelines, window functions, dimensional models, data-quality validation and performance. The capstones build a reporting dataset from a star schema and optimise queries on a large table. This pathway covers SQL foundations only, not orchestration or streaming tools.
1. Tracks
- 01SQL Foundations10 lessons
- 02Retrieving and Filtering Data14 lessons
- 03Aggregation and Business Reporting13 lessons
- 04Joining Tables15 lessons
- 05Subqueries and Advanced Filtering12 lessons
- 06Intermediate and Advanced Analytics14 lessons
- 07Data Cleaning and Transformation13 lessons
- 08Database Creation and Management15 lessons
- 09Performance and Query Optimization11 lessons
- 11SQL for Data Analytics and Business Intelligence11 lessons
2. Capstone projects
- Business-intelligence reporting datasetValidate a star schema, respect slowly changing dimensions and the fiscal calendar, and ship a dashboard-ready view with funnel and marketing KPIs.
- Advanced SQL performance and analysisAnswer real questions on 300,000 events and 100,000 orders, read query plans, add exactly the right indexes and rewrite slow patterns without changing a single result.