Tentative
Schedule (MW: 4:00 – 5:15)
|
Week |
Date |
Topic |
Slides |
Comments |
|
1 |
Wed 01/17/07 |
Ch. 1: Overview of Database Systems |
|
|
|
2 |
Mon 01/22/07 |
Ch. 2: ER Model |
|
|
|
Wed 01/24/07 |
Ch 3: Relational Model |
|
|
|
|
3 |
Mon 01/29/07 |
Ch 4: Relational Algebra |
|
|
|
Wed 01/31/07 |
Ch 5: SQL Queries |
|
Hw 1 Out |
|
|
4 |
Mon 02/05/07 |
Ch 8: Overview of Storage and Indexing |
|
|
|
Wed 02/07/07 |
Ch 9:Data Storage |
|
|
|
|
5 |
Mon 02/12/07 |
Ch 9:Data Storage |
|
Lab 1 Out |
|
Wed 02/14/07 |
Ch 10:Tree Indexes |
|
Hw 1 Due |
|
|
6 |
Mon 02/19/07 |
Ch 10:Tree Indexes |
|
Hw 2 Out |
|
Wed 02/21/07 |
Ch 11:Hash Indexes |
|
|
|
|
7 |
Mon 02/26/07 |
Ch 11:Hash Indexes |
|
|
|
Wed 02/28/07 |
Midterm Exam 1 |
|
|
|
|
8 |
Mon 03/05/07 |
Ch 12:Overview of Query Evaluation |
|
Lab 1 Due |
|
Wed 03/07/07 |
Ch 13: External Sorting |
|
Hw 2 Due / Lab 2 Out |
|
|
9 |
Mon 03/12/07 |
Spring Break |
|
|
|
Wed 03/14/07 |
Spring Break |
|
|
|
|
10 |
Mon 03/19/07 |
Ch 13: External Sorting |
|
|
|
Wed 03/21/07 |
Ch 14: Evaluation of Relational Operators |
|
Hw 3 Out |
|
|
11 |
Mon 03/26/07 |
Ch 14: Evaluation of Relational Operators |
|
|
|
Wed 03/28/07 |
Ch 15: A Typical Relational Optimizer |
|
Lab 2 Due / Lab 3 Out |
|
|
12 |
Mon 04/02/07 |
Ch 15: A Typical Relational Optimizer |
|
|
|
Wed 04/04/07 |
Ch 16:Overview of Transaction Management |
|
|
|
|
13 |
Mon 04/09/07 |
Ch 17: Concurrency Control |
|
Hw 3 Due |
|
Wed 04/11/07 |
Ch 17: Concurrency Control |
|
Hw 4 Out |
|
|
14 |
Mon 04/16/07 |
Midterm Exam 2 |
|
Lab 3 Due |
|
Wed 04/18/07 |
Ch 18: Crash Recovery |
|
Lab 4 Out |
|
|
15 |
Mon 04/23/07 |
Ch 18: Crash Recovery |
|
|
|
Wed 04/25/07 |
Advanced Topics |
|
|
|
|
16 |
Mon 04/30/07 |
Advanced Topics |
|
Hw 4 Due |
|
Wed 05/02/07 |
Advanced Topics |
|
Lab 4 Due |