Lecture 1: SQL¶
Slides¶
SQL Part 1: Basic Queries¶
SQL Part 2: Joins and Subqueries¶
Lecture notes¶
SQL Part 1: Basic Queries¶
SQL Part 2: Joins and Subqueries¶
Reading & resources¶
- Review relational terminology: relation, tuple, attribute, domain, and key.
- Read PostgreSQL's SQL syntax overview.
- Practice predicting the result of joins and aggregate queries before running them.
Related assignment¶
Assignment 0: Environment setup prepares your local tools.