| Date | Description |
|---|---|
| September 24 |
1. Introduction Slides |
| September 26 |
2. Data Models (2.1-2.3) Sqlite notes |
| September 29 |
3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) |
| October 1 |
4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, lec04-data.txt |
| October 3 | 5. SQL - Aggregates (6.3, 6.4) (concl.) |
| October 6 |
6. Basic Query Evaluation, Indexes (14.1) Slides |
| October 8 |
7. SQL - Nested Queries (6.3) Slides Sqlite notes, Additional notes |
| October 10 |
8. SQL Wrap-up (6.3, 2.4); System Architecture SQL Slides Architecture Slides |
| October 13 |
9. Relational Algebra (2.4, 5.1) Slides |
| October 15 | 10. Relational Algebra (concl.) |
| October 17 |
11. Datalog (5.3, 5.4) Slides Query Language Primer |
| October 20 |
12. Relational Calculus (5.3, 5.4) Slides |
| October 22 |
13. XML, XPath (11.1-11.3, 12.1) Slides Examples: XML XML with DTD |
| October 24 |
14. XQuery (12.2) Slides |
| October 27 |
15. E/R Diagrams (4.1-4.6) Slides |
| October 29 |
16. Constraints (7.1, 7.2, 7.4) Slides |
| October 31 |
17. Design Theory (3.1-3.4) Slides |
| November 5 | 19. Design Theory (concl.) |
| November 7 |
20. Views Slides |
| November 10 |
21. Transactions Intro Sqlite Notes |
| November 12 |
22. Transactions I (18.1-18.3) Slides |
| November 14 |
23. Transactions II (18.3-18.4, 6.6) Slides |
| November 17 |
24. Transactions (concl.); Parallel Databases (start) Slides |
| November 19 | 25. Parallel Databases (cont.) |
| November 21 | No lecture today |
| November 24 |
26. Parallel Databases (concl.); MapReduce Slides |
| November 26 |
27. Parallel Databases - MapReduce, PigLatin Slides Pig examples |
| December 1 |
28. Parallel Databases - Wrapup Slides |
| December 3 |
29. NoSQL Slides |
| December 5 |
30. Final Review Slides |