Week 4
Nested Queries
Querying the CAP Database 1) on our postgres server:
- CAP database creation script
- Starter script: cap-queries-nested.sql
- Class exercise: solutions to queries
Reading assignment for next week:
- zyBook Chapter 3: Database Design
HW for next week:
- Querying the CAP database using joins
- For a nice reference on joins, see the SQL cheatsheet PDF in the left sidebar
1)
with thanks to Alan Labouseur for permission to use his materials!