Timetable

Jan 18

Introduction and class overview (chapter 1)

Jan 23, 25, 30

Entity-Relationship modeling (chapter 6)

Feb 1, 6

The relational model and relational algebra (chapter 2)

Feb 8, 13, 15, 20

SQL (chapters 3-5)

Feb 22

Security (chapter 4.2, 4.7)

Feb 27, Mar 1

Object-relational databases (chapter 8)

Mar 6

Midterm review

Mar 8

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

Mar 20

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

Mar 22, 27

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

Mar 29, Apr 3, 5

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

Apr 10, 12

Transactions (chapter 17, small parts of chapter 18)

Apr 17, 19, 24

Normalization (chapter 7)

Apr 26

Overflow material

May 1

Revision and final exam review

May 10

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