Timetable

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