| Date | Description |
|---|---|
| January 7 |
1. Introduction Slides |
| January 9 |
2. Data Models (2.1-2.3) Sqlite notes |
| January 11 |
3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) |
| January 14 |
4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, data |
| January 16 | 5. SQL - Aggregates (6.3, 6.4) |
| January 18 |
6. Basic Query Evaluation, Indexes (14.1) Slides |
| January 23 |
8. SQL - Nested Queries (6.3) (guest lecturer: Paris Koutris) Slides Sqlite notes, Additional notes |
| January 25 |
9. SQL Wrap-up and RDBMs Architecture (6.3, 2.4) Slides |
| January 28 |
10. Relational Algebra (2.4, 5.1) Slides |
| January 30 | 11. Relational Algebra and Query Evaluation (2.4, 5.1) |
| February 1 |
12. Datalog (5.3, 5.4) Slides |
| February 4 |
13. Relational Calculus (5.3, 5.4) Slides, Query Language Primer |
| February 6 |
14. XML, XPath (11.1-11.3, 12.1) Slides XML XML with DTD |
| February 11 |
16. XPath and XQuery (12.1 - 12.2) Slides |
| February 13 |
17. E/R Diagrams (4.1-4.6) Slides |
| February 15 |
18. Constraints (7.1, 7.2, 7.4) Slides |
| February 20 |
20. Design Theory (3.1-3.4) Slides |
| February 22 |
21. Views Slides |
| February 25 |
22. Transactions Slides |
| February 27 |
23. Transactions Slides |
| March 1 |
24. Transactions Slides |
| March 4 |
25. Parallel Databases Slides |
| March 6 |
26. Parallel Databases - MapReduce Slides |
| March 8 |
27. Parallel Databases - Pig Latin Slides |
| March 11 |
28. Parallel Databases - Wrap Up Slides |
| March 13 |
29. Parallel Databases - Wrap Up Slides |
| March 15 |
30. Final Review Slides |