Subscribe to this calendar (Google, iCal, etc.)
| Date | Description |
|---|---|
| April 1 | Unit 1 Intro |
| April 3 | Unit 2 Relational Data Model (2.1-3) Sqlite (data model) |
| April 5 | SQL Basics (6.1-2) Sqlite (joins) |
| April 8 | Joins |
| April 10 | Aggregates (6.3-4) |
| April 12 | SQL Subqueries (6.3) |
| April 15 | [RESCHEDULED ON 4/18] SQL wrap-up. Relational algebra (2.4 & 5.1) |
| April 17 | More relational algebra (2.4 & 5.1) |
| April 19 | Datalog (5.3-5.4) |
| April 22 | Datalog (5.3-5.4) |
| April 24 | Unit 3 |
| April 26 | JSon and SQL++ |
| April 29 | JSon and SQL++ |
| May 1 | JSon and SQL++ |
| May 6 | Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) |
| May 8 | Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) |
| May 10 | Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) |
| May 13 | Query Optimization wrapup |
| May 15 | Unit 5 |
| May 17 | Parallel Databases (20.1) |
| May 20 | Unit 6 E/R Diagrams and Constraints (4.1-4.6) |
| May 22 | Integrity Constraints (4.1-4.6) |
| May 24 | BCNF (3.1-3.4) |
| May 29 | Unit 7 Introduction to Transactions (18.1) Sqlite demo |
| May 31 | More Transactions (18.1-3) |
| June 3 | Transaction Implementations (18.1-3) |
| June 5 | Transaction Implementations (18.1-3) |
| June 7 | Final Review |