* 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.
| Week | Date | Topic | Notes* | Slides** |
| 1 | 08-25 | Introduction | PDF | PDF |
| 08-27 | Relational model and algebra | PDF | PDF |
| 08-29 | More relational algebra; database design in E/R | PDF | PDF |
| 2 | 09-01 | More database design in E/R | PDF | PDF |
| 09-03 | Database design theory | PDF | PDF |
| 3 | 09-08 | SQL: basics | PDF | PDF |
| 09-10 | SQL: subqueries, aggregation, NULL's | PDF | PDF |
| 4 | 09-15 | SQL: outerjoin, modification, constraints, triggers | PDF | PDF |
| 09-17 | SQL: views, indexes, transactions | PDF | PDF |
| 5 | 09-22 | SQL: transactions, programming | PDF | PDF |
| 09-24 | SQL: programming, recursion | PDF | PDF |
| 6 | 09-29 | SQL: more database design theory | PDF | PDF |
| 10-01 | Data warehousing and mining | PDF | PDF |
| 7 | 10-06 | Keyword search on relational databases | | |
| | Part 1 PDF by Behnood Minachi; part 2 PDF by Jun Yang; part 3 PDF by Seth Lankford |
| 10-08 | Midterm exam (in class) | | |
| 8 | 10-13 | Fall break | | |
| 10-15 | XML, DTD, XPath | PDF | PDF |
| 9 | 10-20 | XQuery | PDF | PDF |
| | Toy XML document and "QuiPified" XQuery examples used in lecture |
| 10-22 | XSLT | PDF | PDF |
| 10 | 10-27 | SAX, DOM | PDF | PDF |
| 10-29 | Supporting XML in relational databases | PDF | PDF |
| 11 | 11-03 | Physical data organization | PDF | PDF |
| 11-05 | Indexing | PDF | PDF |
| 12 | 11-10 | Query processing | PDF | PDF |
| 11-12 | Query processing | PDF | PDF |
| 13 | 11-17 | Query optimization | PDF | PDF |
| 11-19 | More query optimization; transaction processing | PDF | PDF |
| 14 | 11-24 | More transaction processing; Web indexing | | PDF |
| 11-26 | Thanksgiving recess | | |
| 15 | 12-01 | Stream processing; course review | | PDF |
| | Part 1 PDF by Isaac Park; part 2 PDF by Pallavi Pratapa; part 3 PDF by Daminda Manoj Rajapaksa |
| 12-03 | Semantic Web; course evaluation | | |
| | Part 1 PDF by Morgan Qualls; part 2 PDF by Roy Williams; part 3 PDF by Sam Hummel |
| 16 | 12-13 | Final exam (Saturday 2-5pm) | | |