Module D20
Data literacy, SQL, and knowledge lifecycle
Prepare and query trustworthy data with traceable sources and reproducible quality checks.
Why this module
Prepare and query trustworthy data with traceable sources and reproducible quality checks.
What you produce
A versioned dataset and searchable store. Assess the output against the unit outcomes, explanation, safe handling, and independent transfer. Do not require public sharing or use of real sensitive records.
Chapters and units
D20-C01: Data quality and SQL
Document units of observation, missingness, duplicates, and provenance; Query related tables with keys, joins, and aggregation
- D20-U01 Data models and quality Document units of observation, missingness, duplicates, and provenance
- D20-U02 SQL and relational thinking Query related tables with keys, joins, and aggregation
D20-C02: Extraction and pipelines
Validate extracted fields against source evidence; Trace an input through transformation and correction
- D20-U03 Documents, parsing, OCR, and tables Validate extracted fields against source evidence
- D20-U04 Pipelines, versions, and effective dates Trace an input through transformation and correction
D20-C03: Lifecycle and reproducibility
Demonstrate removal or access restriction in downstream results; Reproduce an ingestion run and explain remaining limitations
- D20-U05 Permissions, retention, and deletion Demonstrate removal or access restriction in downstream results
- D20-U06 Dataset card and ingestion project Reproduce an ingestion run and explain remaining limitations