Course Calendar - Spring 2025
The schedule is tentative and subject to change.
Session |
Date |
Topic |
Readings |
|---|---|---|---|
Week 1 |
1/7/2025 |
Introduction to Database Systems and Relational Data Model (2 classes) |
Chapters 1, 2.1, 2.2 |
Week 2-3 |
1/14/2025 |
Data Modeling - Normalization (3 classes) |
Chapter 2, 3 |
Week 3-4 |
1/21/2025 |
Entity Relationship Models (3 classes) |
Chapter 4 |
Week 5 |
2/4/2025 |
Catch up (1 class) |
|
Week 5 |
2/7/2025 |
Test #1 |
|
Week 6-7 |
2/11/2025 |
SQL Language (3 classes) |
Chapter 6 |
Week 8 |
2/25/2025 |
Constraints and Triggers (1 class) |
Chapter 7 |
Week 8 |
2/28/2025 |
Views and Indexes (1 class) |
Chapter 8 |
Week 9 |
3/4/2025 |
Spring Break |
|
Week 10 |
3/11/2025 |
SQL in a server environment (2 lectures) |
Course notes, Chapter 9 |
Week 11 |
3/18/2025 |
Catch up (1 class) |
|
Week 11 |
3/21/2025 |
Test #2 |
|
Week 12 |
3/25/2025 |
Secondary Storage Management (1 class) |
Chapter 13 |
Week 12-13 |
3/28/2025 |
Index Structures (2 classes) |
Chapter 14 |
Week 13 |
4/4/2025 |
Query Execution (1 class) |
Chapter 15 |
Week 14 |
4/8/2025 |
Query Optimization (1 class) |
Chapter 16 |
Week 14-15 |
4/11/2025 |
Transaction Management (3 classes) |
Chapters 17, 18, 19 |
Week 16 |
4/22/2025 |
Catch up (1 class) |
|
Finals Week |
Final Exam |