🏠 Dashboard · ☑ Progress · 🔎 Finder · 📚 Block · ← Previous · Next →
Sequence 084 — T4 - DDL, data types and constraints
Stage: Technology Gate A — Relational Foundation
Source: CDMP Master Execution Manual
When / purpose
Build only enough relational structure to support data-management labs.
What you should learn
CREATE TABLE.- Practical data types.
PRIMARY KEY,FOREIGN KEY,NOT NULL,UNIQUE,CHECK.- Identity/surrogate-key awareness.
What to read / study
| Priority | Resource | Use now | Stop point |
|---|---|---|---|
| MUST | Technology Competency Roadmap | Use the exact active technology block and stopping boundary. | Do not study later blocks. |
| REFERENCE | Detailed Technology Competency Reference | Use only the section named by this card. | Do not convert the reference into a separate curriculum. |
Do this in order
- Create a small practice schema/table set.
- Add constraints.
- Attempt one invalid insert and interpret the failure.
- Explain which rule is structural vs business governance.
Meridian application
Use Meridian synthetic data and the local lab environment only when the card calls for practice.
Create / save
DDL script + constraint evidence.
Stop / boundary
Stop at governance/data-management working depth; do not expand into DBA or engineering specialization.
Completion gate
You can create a constrained schema from SQL and explain why each constraint exists.
NEXT → Sequence 085 — T4 - transactions, roles and safe change
Operationalized from the verified canonical 00C Master Execution Manual; not a verbatim transcription.
🏠 Dashboard · ☑ Progress · 🔎 Finder · 📚 Block · ← Previous · Next →