Timetable

Jan 17

Introduction and class overview (chapter 1)

Jan 22, 24, 29

Entity-Relationship modeling (chapter 6)

Jan 31, Feb 5

The relational model and relational algebra (chapter 2)

Feb 7, 12, 14, 19

SQL (chapters 3-5)

Feb 21

Security (chapter 4.2, 4.7)

Feb 26, 28

Object-relational databases (chapter 8)

Mar 4

Midterm review

Mar 6

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

Mar 18

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

Mar 20, 25

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

Mar 27, Apr 1, 3

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

Apr 8, 10

Transactions (chapter 17, small parts of chapter 18)

Apr 15, 17, 22

Normalization (chapter 7)

Apr 24

Overflow material

Apr 29

Revision and final exam review

May 8

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