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) |