Make this skill yours.
Query relational data, build dependable transformations, and design a small analytics pipeline with quality checks.
Your learning path
Relational querying
- Tables, keys, and the grain of a dataset
- SELECT, WHERE, and explicit ordering
- NULL and conditional logic
- Aggregations and HAVING
Analytical SQL
- Inner and outer joins without row explosions
- Common table expressions and readable queries
- Window functions and rankings
- Dates and period comparisons
Pipelines and data quality
- Dimensional models and a sales fact table
- Incremental loads and idempotency
- Data quality and reconciliation
- Pipeline documentation and operational handover
Build something useful
Build a repeatable retail analytics pipeline with staging tables, a sales fact table, and documented quality checks.
What to expect
Twelve guided reading lessons, worked examples, practice worksheets, a subject knowledge check, and an applied project. Allow approximately 40 minutes per lesson, with additional time for your project. The first lesson is available as a free preview.