| Date | Description |
|---|---|
| January 4 |
1. Introduction Slides large and small |
| January 6 |
2. Data Models (2.1-2.3) SQL queries |
| January 8 |
3. SQL Basics (6.1, 6.2) SQL queries |
| January 11 |
4. SQL Aggregates (6.3, 6.4) Slides large Slides small SQL queries Data |
| January 13 |
5. More SQL Aggregates (6.3, 6.4) Slides large Slides small SQL queries Data |
| January 15 |
6. SQL Subqueries (6.3) Slides large Slides small |
| January 20 |
7. SQL Wrapup Slides large Slides small |
| January 22 |
8. Relational Algebra Slides large Slides small |
| January 25 |
9. Relational Algebra (cont) and Query Evaluation (guest lecturer) Slides large Slides small SQL queries |
| January 27 |
10. Basics of Data Storage and Indexing (14.1) Slides large Slides small |
| January 29 |
11. Basics of Query Optimization and Query Cost Estimation Slides large Slides small |
| February 1 |
12. Relational calculus Slides large Slides small |
| February 3 |
13. Datalog (guest lecturer) Slides large Slides small |
| February 5 | Midterm Review (guest lecturer) |
| February 10 |
15. Data Formats and Semistructured Data Slides large Slides small |
| February 12 |
16. NoSQL Slides large Slides small |
| February 17 |
17. E/R Diagrams & Constraints (Reading: 12.1-12.2, 4.1-4.6, 7.1, 7.2, 7.4) Slides large Slides small |
| February 19 |
18. Design theory (Reading: 3.1-3.4) Slides large Slides small |
| February 22 | 19. Design theory continued |
| February 24 |
20. Intro to transactions (Reading: 18.1) Slides large Slides small Sqlite demo |
| February 26 |
21. More transactions (Reading: 18.1-3) Slides large Slides small |
| February 29 |
22. Transaction implementations (Reading: 18.3) Slides large Slides small |
| March 2 |
23. Parallel databases (Reading: 20-20.1.3) Slides large Slides small |
| March 4 | 24. Parallel databases (continued) |
| March 7 |
25. MapReduce Slides large Slides small |
| March 9 |
26. Spark Slides large Slides small |
| March 11 | 27. Final Review |