Week 4

Querying the CAP Database ¹⁾ on our postgres server:

• CAP database creation script
• CAP snapshot
• 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
• cap-queries-joins.sql
• For a nice reference on joins, see the SQL cheatsheet PDF in the left sidebar