Course Schedule

* Lecture slides are available at the UAlbany Blackboard System.

01/24 Introduction (Chapter 1) [slides] [slides]

01/29 Relational Model (Chapter 2) [slides]

01/31 Relational Model (Chapter 2)

02/05 Storage and File Structure (Chapter 10) [slides]

02/07 Indexing and Hashing (Chapter 11) [slides]

02/12 Indexing and Hashing (Chapter 11)

02/14 SQL (Chapter 3) [slides]

02/19 SQL (Chapter 4) [slides]

02/21 Advanced SQL (Chapter 5) [slides]

02/26 Other Relational Languages (Chapter 6) [slides]

02/28 E-R Model (Chapter 7) [slides]

03/05 E-R Model (Chapter 7)

03/07 Relational Database Design (Chapter 8) [slides] [examples]

03/12 Midterm Review

03/14 Midterm Exam

03/19 No class

03/21 No class

03/26 Relational Database Design (Chapter 8)

03/28 Query Processing (Chapter 12) [slides]

04/02 Query Processing (Chapter 12)

04/04 Query Optimization (Chapter 13) [slides]

04/09 Query Optimization (Chapter 13)

04/11 Transactions (Chapter 14) [slides]

04/16 Concurrency Control (Chapter 15) [slides]

04/18 Concurrency Control (Chapter 15)

04/23 Failure Recovery (Chapter 16) [slides]

04/25 Failure Recovery (Chapter 16)

04/30 Parallel Databases (Chapter 18) [slides]

05/02 Distributed Databases (Chapter 19) [slides]

05/07 Final Review; Stream Processing [slides]; Graph Analytics [slides]

05/16 Final Exam (10:30am - 12:30pm)