====== Week 4 ======

===== Nested Queries =====

Querying the CAP Database ((with thanks to Alan Labouseur for permission to use his materials!)) on our postgres server:
  * CAP database creation {{ :courses:cs311-2021:cap.txt |script}}
  * {{cap.pdf|CAP snapshot}}
  * Starter script: {{ cap-queries-nested.sql.txt |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.txt |cap-queries-joins.sql}}
  * For a nice reference on joins, see the [[https://www.jrebel.com/sites/rebel/files/pdfs/sql-cheat-sheet-2021-web.pdf|SQL cheatsheet PDF]] in the left sidebar