| Date | Description |
|---|---|
| March 30 |
1. Introduction Slides |
| April 1 |
2. Data Models (2.1-2.3) Sqlite notes |
| April 3 |
3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) |
| April 6 |
4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, lec04-data.txt |
| April 8 | 5. SQL - Aggregates (6.3, 6.4) (concl.) |
| April 10 |
6. Basic Query Evaluation, Indexes (14.1) Slides |
| April 13 |
7. SQL - Nested Queries (6.3) Slides Sqlite notes, Additional notes |
| April 15 |
8. SQL Wrapup (6.3, 2.4); System Arch. SQL Slides, Arch. Slides |
| April 17 |
9. Relational Algebra (2.4, 5.1, 5.2) Slides |
| April 20 | 10. Relational Algebra (cont.) |
| April 22 |
11. Relational Algebra (concl.); Query Impl. (15.1-15.6) Slides |
| April 24 | 12. Query Implementation |
| April 27 |
13. XML, XPath (11.1-11.3, 12.1) Slides Examples: XML XML with DTD |
| April 29 | 13. XPath (concl.) |
| May 1 |
14. XQuery (12.2) Slides |
| May 6 |
15. E/R Diagrams (4.1-4.6) Slides |
| May 8 |
16. Constraints (7.1, 7.2, 7.4) Slides |
| May 11 |
17. Design Theory (3.1-3.4) Slides |
| May 13 |
20. Theory (concl.); Views Slides |
| May 15 |
21. Views (concl.); Transactions Intro Sqlite Notes |
| May 18 |
22. Transactions I (18.1-18.3) Slides |
| May 20 |
23. Transactions II (18.3-18.4, 6.6) Slides |
| May 22 |
24. Transactions (concl.); Parallel Databases (start) Slides |
| May 27 |
25. Parallel Databases - MapReduce Slides |
| May 29 |
26. Parallel Databases - MapReduce, PigLatin Slides Pig examples |
| June 1 |
27. Parallel Databases - Parallel SQL & Wrapup Slides |
| June 3 |
28. Parallel Databases - Wrapup; NoSQL Slides |
| June 5 |
30. NoSQL (concl.); Final Review Slides |