[ 9/25 ] Ch 2. Index, Ex
2.2
[ 9/27 ]
Lab: IST
VLab and MS SQL Server tutorial
[ 10/2 ]
Ch 3. ER Basics
+ HW#1:
Ch. 2, Question 19, 22, 25, and Exercise 3, 4
[ 10/4 ] Ch
3. PBL
3.1 (AFV Case)
[
10/9 ] Ch 3. ER
Advanced
[ 10/11 ] Ch
3. E/R
Jeopardy, Proj #1
[ 10/16 ]
Ch 5. Relational
Model, B+ Tree example
+ HW#2:
Ch. 3, Question 8, 13, 16, and Minicase 2
[ 10/18 ]
Ch 5. PBL
5.1 (Salesperson Case)
[ 10/23 ]
Ch 6. Relational Model I
[ 10/25 ]
Ch
7. Relational Model II
[ 10/30 ]
Midterm Exam (In-class, Open Book, NO computer access)
[ 11/1] Midterm
Discussion, Proj #2
[
11/6 ] Ch 9. SQL basic
[ 11/8 ] Ch
9. SQL join
[ 11/13 ] Ch 9. SQL grouping
[ 11/15
] Ch 9. SQL
lab, groupby solution
+ DUE:
Proj#2
[ 11/20 ] Ch 9. SQL
subquery & update, Proj#3
[ 11/22
] NO Class:
Thanksgiving
[ 11/27 ] Ch 9. SQL
lab, HW#3 (Ch.9, Minicase 2, p 227)
[ 11/29
] SQL Jeopardy
(solution)
[ 12/4 ] Project Presentation,
Presentation Rules
[ 12/
6 ] Project Presentation
[ 12/11 ]
Final
Exam (In-class, Open Book, NO computer access)
[ 12/13
] Final Discussion
[ 12/18 ] DUE:
Proj#3
|