Stage 8: Generate and review DDL
Knobit of Data modelling · K-859 · Knowledge
Explains testing DDL by execution and detecting drift
What it means
DDL is proven by running it, and the deployed catalogue compared with the model.
How it is assessed
Designs the execution test and drift check for sample deployments
Builds on
- Explains forward and reverse engineering of data modelsK-914 · Knowledge
Needed by
- Recognises SQL reviewed without being runK-825 · Skill
- Recognises undetected drift between database and modelK-826 · Skill