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 |