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 |