Timetable

Sep 3

Introduction and class overview (chapter 1)

Sep 8, 10, 15

Entity-Relationship modeling (chapter 6)

Sep 17, 22

The relational model and relational algebra (chapter 2)

Sep 24, 29, Oct 1, 6

SQL (chapters 3-5)

Oct 8

Security (chapter 4.2, 4.7)

Oct 13

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

Oct 15

Midterm review

Oct 20

Midterm exam (75 minute in-class test, details to be provided later)

Oct 22, 27

Object-relational databases (chapter 8)

Oct 29, Nov 5

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

Nov 10, 12, 17

Query processing and optimization, materialized views (chapters 15, 16)

Nov 19, 24

Transactions (chapter 17, small parts of chapter 18)

Nov 26, Dec 1, 3

Normalization (chapter 7)

Dec 8

Revision and final exam review

Dec 15

Tentative final exam date (2hr 50 min in-class test, details to be provided later)