Week
of |
Monday |
Wednesday |
Friday |
March 31
|
Intro;
SQL
pdf / ppt |
SQL
Reading:
Chapter 6
pdf / ppt |
SQL
pdf / ppt
HW0 due in class |
April 7
|
SQL
pdf / ppt |
Views,
Constraints
Reading:
Chapters 6, 7
pdf / ppt
Project
0 due |
SQL in C#, Project
pdf / ppt
Reading:
Chapter 8
HW1 due Sat. 9 pm |
April 14 |
ER
Diagrams
pdf / ppt
Reading: Chapter 2, 3.2,
3.3
|
Database
Design
pdf / ppt
Reading:
Secs.3.1, 3.4 |
Database
Design, cont.
Project
1 due Sat 9 pm |
April 21 |
XML/XPath/XQuery
pdf / ppt
Reading: Chapter 4.6, 4.7
Project 1 due
9 pm |
XML/XPath/XQuery
pdf / ppt |
XML/XPath/XQuery
pdf / ppt
HW2 due Sat 9 pm |
April 28 |
Midterm Review
pdf / ppt |
Midterm
Exam |
Security
pdf / ppt
Reading: SQL Security 8.7
Project
2 due Sat 9 pm |
May 5 |
Transactions
pdf / ppt
Reading:
Sec.8.6
Project 2 due
9 pm |
Transactions
pdf / ppt
Reading:
Secs.17.2-17.4 |
Transaction,
Recovery
HW3
due Sat 9 pm |
May 12 |
Concurrency
Control
Reading:
Secs.18.1-18.4, 18.7-18.9
pdf / ppt |
Concurrency
Control 2 |
Concurrency
Control 3
Project
3 due Sat 9 pm |
May 19 |
Data
storage and Indexes
pdf / ppt
Reading: 12, 13.1, 13.2,
13.3 |
Query
Execution: Relational Algebra
Reading: 5.1-5.4
pdf / ppt |
Query
Execution 2
pdf / ppt
HW4 due Sat 9 pm |
May 26 |
Memorial
Day
No Class
|
Query
Execution 3 |
Query
Optimization
pdf / ppt
Reading: 16.2, 16.5,
16.6, 16.4
Project
4 due Sat 9 pm |
June 2 |
Query Optimization
|
Query Optimization
|
Final
Review
pdf / ppt |
June 12 |
Final
exam
8:30-10:20 |
|
|