Chapter D20-C01 · Data literacy, SQL, and knowledge lifecycle
Data quality and SQL
Document units of observation, missingness, duplicates, and provenance; Query related tables with keys, joins, and aggregation.
Units in this chapter
- 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
Reading that connects these units
Reading
- Datasheets for Datasets Motivation, composition, collection, intended use, maintenance, and accountability.About this reference (P04)
- pandas introductory tutorials Table selection, derived columns, summaries, joins, and file input/output.About this reference (W10)
- PostgreSQL tutorial Tables, querying, joins, and transactions; match installed database version.About this reference (W11)
- Designing Data-Intensive Applications Data models, transactions, reliability, and distributed-system tradeoffs; use the learner-held edition index.About this reference (B08)
Selected, not required. Reviewed 2026-11-17.