Date | Description |
---|---|
September 25 |
1. Introduction Slides |
September 27 |
2. Data Models (2.1-2.3) Sqlite notes |
September 30 |
3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) |
October 2 |
4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, data |
October 4 |
5. SQL - Aggregates (6.3, 6.4) same materials from last lecture |
October 7 |
6. Basic Query Evaluation, Indexes (14.1) Slides |
October 9 |
7. SQL - Nested Queries (6.3) Slides Sqlite notes, Additional notes |
October 11 |
8. SQL Wrap-up and RDBMs Architecture (6.3, 2.4) Slides |
October 14 |
9. Relational Algebra (2.4, 5.1) -- guest Lecturer Sudeepa Roy Slides |
October 16 |
10. Relational Algebra Wrapu and Architectures Slides |
October 18 |
11. Datalog (5.3, 5.4) Slides |
October 21 |
12. Relational Calculus (5.3, 5.4) Slides, Query Language Primer |
October 23 |
13. XML, XPath (11.1-11.3, 12.1) Slides XML XML with DTD |
October 25 |
14. XPath and XQuery (12.1 - 12.2) Slides |
October 28 |
15. E/R Diagrams (4.1-4.6) Slides |
October 30 |
16. Constraints (7.1, 7.2, 7.4) Slides |
November 1 |
17. Design Theory (3.1-3.4) Slides |
November 6 |
19. Midterm Discussion, Design Theory Wrap-up, Views Slides |
November 8 | 20. Views (continue lecture from last week) |
November 13 |
21. Transactions Sqlite Notes |
November 15 |
22. Transactions Slides |
November 18 |
23. Transactions Slides |
November 20 |
24. Parallel Databases Slides |
November 22 | 25. Parallel Databases |
November 25 |
26. Parallel Databases - MapReduce Slides |
November 27 | 27. Parallel Databases - MapReduce |
December 2 |
28. Parallel Databases - MapReduce, PigLatin Slides |
December 4 |
29. Parallel Databases - Wrapup Slides |
December 6 |
30. Final Review Slides |