Subscribe to this calendar (Google, iCal, etc.)
| Date | Description |
|---|---|
| January 7 | Unit 1 Intro |
| January 9 | Unit 2 Relational Data Model (2.1-3) Sqlite (data model) |
| January 11 | Joins (continued), Aggregates (6.3-4) Sqlite (joins) Sqlite (aggregates) |
| January 14 | CANCELED (makeup: 1/10, 4:30pm, BAG 131) |
| January 16 | CANCELED (makeup: 1/22, 5:30pm, BAG 131) |
| January 18 | Aggregates (6.3-4) |
| January 23 | SQL wrap-up. Relational algebra (2.4 & 5.1) |
| January 25 | More relational algebra (2.4 & 5.1) |
| January 28 | Datalog (5.3-5.4) |
| January 30 | Datalog (5.3-5.4) |
| February 1 | Unit 3 |
| February 4 | CANCELED (Snow day) |
| February 6 | JSon and SQL++ |
| February 8 | CANCELED (Snow day) |
| February 11 | CANCELED (Snow day) |
| February 13 | JSon and SQL++ |
| February 20 | Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) |
| February 22 | Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) |
| February 25 | Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) |
| February 27 | Unit 5 Parallel Databases (20.1) Introduction to Spark (no reading) |
| March 1 | Unit 6 E/R Diagrams and Constraints (4.1-4.6) |
| March 4 | Integrity Constraints |
| March 6 | BCNF (3.1-3.4) |
| March 8 | Unit 7 Introduction to Transactions (18.1) Sqlite demo |
| March 11 | More Transactions (18.1-3) |
| March 13 | Transaction Implementations (18.1-3) |
| March 15 | Final Review |