UNIT 016 h allocated
Data modelling
- Relational schemas
- event data
- identifiers
- ownership
← Course catalogue
MATHEMATICS & DATA / SPECIALIST
DAT210Data engineering, ETL & quality contracts
24 h productive allocation9 h 36 m learning + 14 h 24 m training4 units · 1 assessed practical brief
Detailed course plan and training brief. A complete taught course pack is in preparation. The linked foundation module, where shown, is a smaller available resource.
BEFORE YOU BEGIN
A clear starting point.
Specialist studio; environment and faculty must be confirmed before scheduling
WHAT YOU SHOULD BE ABLE TO DEMONSTRATE
- Explain the assumptions and failure modes in data modelling.
- Complete the practical: build an incremental synthetic-data pipeline that rejects bad records and safely replays a batch.
- Defend the resulting pipeline code with reproducible evidence.
THE SUBJECTS / FOUR CONNECTED UNITS
What you will study.
UNIT 026 h allocated
ETL and ELT
- Ingestion
- transforms
- incremental loads
- idempotency
UNIT 036 h allocated
Quality contracts
- Schema
- ranges
- uniqueness
- lineage and reconciliation
UNIT 046 h allocated
Operational data
- Scheduling
- late arrivals
- backfills
- failure and recovery
THE TRAINING STUDIO
Make the subject
visible in your work.
Build an incremental synthetic-data pipeline that rejects bad records and safely replays a batch.
Evidence to produce
- Pipeline code
- data contracts
- reconciliation counts
- replay test
Training brief for supervised delivery. Code, datasets, answer keys and environment acceptance must be completed in the full course pack before delivery is confirmed.
ASSESS THE REASONING
A question you
should be able to answer.
What prevents a retry from duplicating the same observations?
Review dimensions
Technical correctness · reproducibility · interpretation of results · failure analysis · individual explanation. Course-level rubric and faculty moderation form part of the final adopted teaching pack.
External reference access, hardware, cloud accounts and paid services are separate. No third-party certification is included by implication.