- Jan 22
- Introduction and class overview (chapter 1)
- Jan 27, 29, Feb 3
- Entity-Relationship modeling (chapter 6)
- Feb 5, 10
- The relational model and relational algebra (chapter 2)
- Feb 12, 17, 19, 24
- SQL (chapters 3-5)
- Feb 26
- Security (chapter 4.2, 4.7)
- Mar 2
- Application Programming and Database APIs
- Mar 4
- Key-value stores, document-stores, BigTable, Streaming data, Graph Databases (chapter 10.2, 10.5, 10.6)
- Mar 9
- Midterm review
- Mar 11
- Midterm exam
- Mar 23, 25
- Object-relational databases (chapter 8)
- Mar 30, Apr 1
- Storage and indexing (chapter 12, small parts of chapters 13, 14)
- Apr 6, 8
- Query processing and optimization (chapters 15, 16)
- Apr 13, 15
- Transactions (chapter 17, small parts of chapter 18)
- Apr 20, 22, 27
- Normalization (chapter 7)
- Apr 29
- Overflow material and/or additional topic.
- May 4
- Revision.
- May 11
- Tentative final exam date.
Ken Ross
2020-04-13