Course Schedule :
| Week |
Date |
Session |
Topic |
Textbook |
Assignment |
Project |
| 1 |
01/19 |
1 |
No Class: MLK Holiday |
|
|
|
01/21 |
2 |
Course Overview |
CH 1 |
| 2 |
01/26 |
3 |
Course Overview |
CH 1 |
|
|
01/28 |
4 |
Project Ideas |
- |
| 3 |
02/02 |
5 |
Data Modeling |
CH 2,3 |
#1a Assigned
|
Group |
02/04 |
6 |
Data Modeling |
CH 2,3 |
| 4 |
02/09 |
7 |
Relational Algebra and Calculus |
CH 4 |
|
|
02/11 |
8 |
SQL Overview |
CH 5 |
| 5 |
02/16 |
9 |
SQL Overview |
CH 5 |
|
|
02/18 |
10 |
Normalization Theory |
CH 19 |
| 6 |
02/23 |
11 |
Normalization Theory |
CH 19 |
|
|
02/25 |
12 |
Disks and Files |
CH 9 |
| 7 |
03/02 |
13 |
Disks and Files |
CH 9 |
|
|
03/04 |
14 |
Indexing Overview |
CH 8 |
| 8 |
03/09 |
15 |
Tree Indexes |
CH 10 |
|
|
03/11 |
16 |
Hash Indexes |
CH 11 |
| 9 |
03/16 |
17 |
Spatial Indexes |
- |
|
|
03/18 |
18 |
Midterm Exam |
|
| 10 |
03/23 |
19 |
No Class: Spring Break!
|
|
|
|
03/25 |
20 |
No Class: Spring Break! |
|
| 11 |
03/30 |
21 |
Query Evaluation Overview |
CH 12 |
|
|
04/01 |
22 |
Operator Evaluation |
CH 13,14 |
| 12 |
04/06 |
23 |
Operator Evaluation |
CH 13,14 |
|
|
04/08 |
24 |
Query Optimization |
CH 15 |
| 13 |
04/13 |
25 |
Query Optimization |
CH 15 |
|
|
04/15 |
26 |
Transaction Management Overview |
CH 16 |
| 14 |
04/20 |
27 |
Concurrency Control |
CH 17 |
|
|
04/22 |
28 |
Recovery |
CH 18 |
| 15 |
04/27 |
29 |
Big Data Management |
- |
#2 Due |
|
04/29 |
30 |
Big Data Management |
- |
| 16 |
05/04 |
31 |
Project Presentation |
|
|
Report & Present |
05/06 |
32 |
Project Presentation |
|
| 17 |
TBD |
33 |
Final Exam |
|
|
|
|
|
