Chapter 3: Querying and Filtering
SELECT, FROM, WHERE, ORDER BY, LIMIT, predicates, and basic query literacy.
Chapter 4: Joins
Inner, outer, cross, self joins, join keys, duplication, and cardinality.
Chapter 5: Views
Reusable query interfaces, abstraction, governance, and view tradeoffs.