Unit D20-U02 · Data literacy, SQL, and knowledge lifecycle
SQL and relational thinking
Query related tables with keys, joins, and aggregation.
Outline only
This is an outline, not a lesson yet
The full lesson for this unit has not been written. This page shows what it is planned to teach, how long it is planned to take, and the reading chosen to support it. No explanation, worked example, quiz or task is published for it yet. See content status.
Planned outcome
Query related tables with keys, joins, and aggregation.
How it would be assessed
Assessed outcome: Query related tables with keys, joins, and aggregation.
Evidence: A task artifact demonstrating the stated action, a verification or comparison record, and a short explanation of uncertainty or failure. Use a new input for the completion check. Allocate the scheduled time across reading, demonstration, lab, quiz, and feedback rather than treating it as reading alone.
Planned time and place
- Planned time
- 3.33333 h in total, including practice and assessment (a planning figure, not tested with learners)
- Module
- D20: Data literacy, SQL, and knowledge lifecycle
- Chapter
- D20-C01: Data quality and SQL
- Prerequisite modules
- D10
- Used in programs
- P06, P07
Selected reading for this topic
Core reading
- PostgreSQL tutorial Tables, querying, joins, and transactions; match installed database version.Try it: Query related tables with keys, joins, and aggregation.About this reference (W11)
Optional
- Designing Data-Intensive Applications Data models, transactions, reliability, and distributed-system tradeoffs; use the learner-held edition index.Try it: Query related tables with keys, joins, and aggregation.About this reference (B08)
Reading is chosen to support the outcome; none of it is compulsory homework. Links go to the owners' own sites and some resources cost money. Reviewed 2026-11-17.