Subscribe to this calendar (Google, iCal, etc.)
| Date | Description |
|---|---|
| March 25 | Introduction (2.1-3) |
| March 27 | SQL Basics (6.1 - 6.2) |
| March 29 | SQL Joins (6.1 - 6.2) |
| April 1 | SQL: NULLs, Aggregates |
| April 3 | SQL Aggregates cont. demo queries |
| April 5 | SQL Review demo queries |
| April 8 | Subqueries in SQL |
| April 10 | SQL Wrapup |
| April 12 | Relational Algebra |
| April 15 | ER Diagrams (2.1) |
| April 17 | ER Diagrams cont. (2.1) |
| April 19 | Functional Dependencies (2.2 - 2.3) |
| April 22 | BCNF (3.4 - 3.6) |
| April 24 | Midterm review |
| April 29 | TXN Basics (18.1 - 18.2) demo (sqlite, python) |
| May 1 | Serializability (18.1 - 18.2) |
| May 3 | Locks |
| May 6 | Isolation Levels |
| May 8 | TXN Wrapup demo |
| May 10 | Practical Data Management demo |
| May 13 | Query Execution |
| May 15 | Disks and Indexes |
| May 17 | Query Optimization (8.3-4, 14.1-7) |
| May 20 | Semistructured Data |
| May 22 | SQL++ demo |
| May 24 | SQL++ (VIDEO ONLY!) demo |
| May 29 | Review |
| May 31 | Final Exam Review (selected problems from here) |