Week | Date | Topic | Notes* | Slides** |
1 | 2002-08-27 | Introduction | ||
2002-08-29 | Relational model & algebra | |||
2 | 2002-09-03 | Database design in E/R model | ||
2002-09-05 | Database design in E/R model | |||
3 | 2002-09-10 | Relational database design theory | ||
2002-09-12 | SQL: basics | |||
4 | 2002-09-17 | SQL: aggregation, grouping, ordering, NULL's, outerjoins | ||
2002-09-19 | SQL: modifications, constraints, triggers | |||
5 | 2002-09-24 | SQL: views, indexes, transactions | ||
2002-09-26 | SQL: transactions (cont'd), programming | |||
6 | 2002-10-01 | SQL: recursion | ||
2002-10-03 | More relational database deisgn theory | |||
7 | 2002-10-08 | Data warehousing and data mining | ||
2002-10-10 | Midterm exam | |||
8 | 2002-10-15 | Fall break | ||
2002-10-17 | XML and DTD | |||
9 | 2002-10-22 | XPath and XQuery | ||
2002-10-24 | XSLT | |||
10 | 2002-10-29 | SAX and DOM | ||
2002-10-31 | Supporting XML in relational databases | |||
11 | 2002-11-05 | Physical data organization | ||
2002-11-07 | Indexing | |||
12 | 2002-11-12 | Indexing continued | ||
2002-11-14 | Query processing | |||
13 | 2002-11-19 | Query processing | ||
2002-11-21 | Query optimization | |||
14 | 2002-11-26 | Transaction processing | ||
2002-11-28 | Thanksgiving break | |||
15 | 2002-12-03 | Transaction processing continued | ||
2002-12-05 | Web crawling, indexing, and ranking | |||
16 | 2002-12-13 | Final exam (Friday, 7:00pm-10:00pm) |
* Generally available in the morning on the day of the lecture. They are intentionally made incomplete in order to keep the lectures more lively. You can print these slides out and use them for taking notes during the lecture. These slides may contain typos/errors that are corrected only in the complete version.
** Available on the same day after the lecture. They are complete, with typos/errors corrected.
Assignment | Download | Assigned | Due |
Homework #1 | Tuesday, 2002-09-03 | Thursday, 2002-09-12 | |
Homework #2 | Tuesday, 2002-09-17 | Thursday, 2002-09-26 | |
Optional Problem Set #1 | Thursday, 2002-10-03 | Tuesday, 2002-10-08 | |
Homework #3 | Tuesday, 2002-10-29 | Thursday, 2002-11-07 | |
Homework #4 | Tuesday, 2002-11-19 | Tuesday, 2002-12-03 | |
Project | Thursday, 2002-09-12 | See project description | |
Optional Problem Set #2 | Friday, 2002-12-06 | Wednesday, 2002-12-11 |