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 3, 5

Object-relational databases (chapter 8)

Mar 10

Midterm review

Mar 12

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

Mar 24

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

Mar 26, 31

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

Apr 2, 7, 9

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

Apr 14, 16

Transactions (chapter 17, small parts of chapter 18)

Apr 21, 23, 28

Normalization (chapter 7)

Apr 30

Overflow material

May 5

Revision and final exam review

May 14

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