Pusaram AI Academy
Pusaram sites

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 PostgreSQL Global Development Group · documentation · FreeTables, querying, joins, and transactions; match installed database version.Try it: Query related tables with keys, joins, and aggregation.About this reference (W11)

Optional

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.