Timetable

Jan 11

Introduction and class overview (chapter 1)

Jan 13, 20, 25

Entity-Relationship modeling (chapter 6)

Jan 27, Feb 1

The relational model and relational algebra (chapter 2)

Feb 3, 8, 10, 15

SQL (chapters 3-5)

Feb 17

Security (chapter 4.2, 4.7)

Feb 22

Key-value stores, document-stores, BigTable, Streaming data, Graph Databases (chapter 10.2, 10.5, 10.6)

Feb 24

Midterm review

Feb 25

Midterm exam (24 hour window starting at 1pm; 75 minute test, details to be provided later)

Mar 8, 10

Object-relational databases (chapter 8)

Mar 15, 17

Storage and indexing (chapter 12, small parts of chapters 13, 14)

Mar 22, 24

Query processing and optimization (chapters 15, 16)

Mar 29, 31

Transactions (chapter 17, small parts of chapter 18)

Apr 5, 7, 12

Normalization (chapter 7)

Apr 14

Final exam review

April 21

Tentative final exam date (24 hour window starting at 1pm; untimed test, roughly 3 hours work expected, details to be provided later)