Course Schedule

Week Date Topic Reading
1 1/6 Logistics & Intro PPT Ch. 1
1/8 ER-Model PPT Ch. 2
1/10 ER-Model Cont.
2 1/13 Relational Model Ch. 3
1/15 Relational Model Cont.
1/17 Relational Algebra Ch. 4
3 1/20 Holiday - No Class
1/22 Relational Algebra Cont.
1/24 Intro to SQL Ch. 5
4 1/27 SQL Cont.
1/29 SQL Cont.
1/31 Advanced SQL
5 2/3 Advanced SQL
2/5 Review
2/7 Midterm
6 2/10 Storage and Indexing Ch. 8
2/12 Storage and Indexing Cont. Ch. 9
2/14 Tree Indexing Ch. 10
7 2/17 Holiday - No Class
2/19 Hash Indexing Ch. 11
2/21 Query Optimization
8 2/24 Query Optimization Cont. Ch. 12
2/26 Transaction Processing Ch. 16
2/28 Transaction Processing Cont.
9 3/2 Parallel Databases
3/4 Issues with Parallel Databases
3/6 NoSQL Databases
10 3/9 NoSQL Databases Cont.
3/11 Review
3/13 Prof. attending conference
11 3/19 Final Exam (11:30 AM - 2:30 PM)