Tentative Class Schedule - Fall 2019ΒΆ

WEEK DAY TOPIC READING LIST
Week 1 8/29 Database Systems & Relational Data Model Chapter 1, 2.1, 2.2
Week 2 9/3 Data modeling Chapter 2
Week 2 9/5 Data modeling Chapter 3
Week 3 9/12 Data modeling Chapter 4
Week 5 9/23 Catch up  
Week 5 9/26 Exam #1  
Week 6 9/30 SQL Chapter 6
Week 7 10/10 Constraints and Triggers Chapter 7
Week 8 10/17 Views and Indices Chapter 8
Week 9 10/21 SQL in a server environment Course notes, Chapter 9,10
Week 10 10/28 Catch up  
Week 10 10/31 Exam #2  
Week 11 11/4 Secondary Storage Management Chapter 13
Week 11 11/7 Index Structures Chapter 14
Week 12 11/14 Query Execution Chapter 15
Week 13 11/21 Query Compiler Chapter 16
Week 15 12/2 Transaction Management Chapter 17,18
Week 16 12/9 Transaction Management Chapter 19
Finals week 12/16-12/20 Final Exam (comprehensive)