Week 9 - Advanced database topics

Learning objectives

Exposure to the concepts of:
- Concurrency and transactions
- Backups
- Indexes

Slides

Instructor materials

Instructor notes

Instructor files:

Resources

Jeffrey D. Ullman and Jennifer Widom (2008). A First Course in Database Systems. 3rd ed. Upper Saddle River, NJ: Pearson/Prentice Hall.
Access via Library Catalog
- Complete but theoretical introduction to relational databases, data modeling, and relational algebra.

Homework

What makes a good index?