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 |