Skilirium

All stages of Data modeller

Stage 8

Generate and review DDL

Generates DDL per target dialect and reviews it against model, engine, data and deployment

37 knobits (9 knowledge, 28 skills) · Produces: generated DDL · Builds on: Derive data quality rules, Design the physical data model

Knobit map

Each mark is one knobit. Knobits higher up build on the ones below them; select one to open it.

K-801 Recognises generated SQL edited by hand801K-802 Recognises DDL older than its model802K-803 Recognises an object in the SQL missing from the model803K-804 Recognises generator warnings carried without a decision804K-310 Recognises a constraint claimed by a rule and missing from the schema310K-806 Recognises a configured dialect left unregenerated806K-313 Recognises a declared constraint the target platform does not enforce313K-808 Recognises a CHECK constraint parsed and ignored808K-809 Recognises an expression running on one engine only809K-810 Recognises a truncated identifier taken as the real name810K-811 Recognises a reserved word used as an identifier811K-812 Recognises a type meaning something else on another engine812K-813 Recognises an index the target engine cannot create or run813K-814 Recognises a foreign-key cycle taken as resolved814K-618 Recognises binary floating point used for an exact quantity618K-816 Recognises one decimal scale for every currency816K-817 Recognises a length taken from sample data817K-827 Recognises an event timestamp stored without a time zone827K-828 Recognises a business date stored with a time of day828K-819 Recognises a collation changing what a key means819K-820 Recognises a default inventing a business fact820K-821 Recognises a restricted column without access design821K-822 Recognises greenfield DDL aimed at a populated database822K-823 Recognises a drop script used as a rollback823K-824 Recognises an environment baked into the script824K-825 Recognises SQL reviewed without being run825K-826 Recognises undetected drift between database and model826K-851 Explains generated artefacts and their single source of truth851K-852 Explains SQL dialect differences852K-853 Explains currency minor units853K-854 Explains time zones in timestamps and business dates854K-855 Explains collation and case or accent sensitivity855K-856 Explains access design for classified data856K-857 Explains schema migration and rollback857K-858 Explains environment-independent deployment858K-859 Explains testing DDL by execution and detecting drift859K-641 Routes a defect to the deliverable responsible for it641
  • Circle: skill
  • Square: knowledge

Knobits of this stage

KnobitType
K-801Recognises generated SQL edited by handSkill
K-802Recognises DDL older than its modelSkill
K-803Recognises an object in the SQL missing from the modelSkill
K-804Recognises generator warnings carried without a decisionSkill
K-310Recognises a constraint claimed by a rule and missing from the schemaSkill
K-806Recognises a configured dialect left unregeneratedSkill
K-313Recognises a declared constraint the target platform does not enforceSkill
K-808Recognises a CHECK constraint parsed and ignoredSkill
K-809Recognises an expression running on one engine onlySkill
K-810Recognises a truncated identifier taken as the real nameSkill
K-811Recognises a reserved word used as an identifierSkill
K-812Recognises a type meaning something else on another engineSkill
K-813Recognises an index the target engine cannot create or runSkill
K-814Recognises a foreign-key cycle taken as resolvedSkill
K-618Recognises binary floating point used for an exact quantitySkill
K-816Recognises one decimal scale for every currencySkill
K-817Recognises a length taken from sample dataSkill
K-827Recognises an event timestamp stored without a time zoneSkill
K-828Recognises a business date stored with a time of daySkill
K-819Recognises a collation changing what a key meansSkill
K-820Recognises a default inventing a business factSkill
K-821Recognises a restricted column without access designSkill
K-822Recognises greenfield DDL aimed at a populated databaseSkill
K-823Recognises a drop script used as a rollbackSkill
K-824Recognises an environment baked into the scriptSkill
K-825Recognises SQL reviewed without being runSkill
K-826Recognises undetected drift between database and modelSkill
K-851Explains generated artefacts and their single source of truthKnowledge
K-852Explains SQL dialect differencesKnowledge
K-853Explains currency minor unitsKnowledge
K-854Explains time zones in timestamps and business datesKnowledge
K-855Explains collation and case or accent sensitivityKnowledge
K-856Explains access design for classified dataKnowledge
K-857Explains schema migration and rollbackKnowledge
K-858Explains environment-independent deploymentKnowledge
K-859Explains testing DDL by execution and detecting driftKnowledge
K-641Routes a defect to the deliverable responsible for itSkill