Schedule

Date		Topic	Reading	Due
08.27	Thu	Intro to Databases Relational Model	Relational Fundamentals
09.01	Tue	SQL Basics Quiz 1	SQL Tutorial - Basics
09.03	Thu	SQL Joins	SQL Tutorial - Aggregate Calculations	SQL Ex 1
09.08	Tue	Quiz 2 SQL Set Operations	SQL Tutorial - Joins
09.10	Thu	SQL Self Joins SQL Conditional Logic SQL Null Values Test 1 Review	SQL Tutorial - Nested Queries; SQL Tutorial - Miscellaneous	SQL Ex 2
09.15	Tue	Test 1
09.17	Thu	E-R Modeling I	Database Design Ch. 2
09.22	Tue	E-R Modeling II		Model Ex 1
09.24	Thu	Modeling Tips
09.29	Tue	Database Development Test 2 Review		Model Ex 2
10.01	Thu	Data Integrity Test 2
10.06	Tue	Intro to MySQL
10.08	Thu	Microsoft Access
10.10	Sat	TBA		Lab 1
10.13	Tue	Views Normal Forms
10.15	Thu	Project Intro Normal Forms
10.17	Sat	TBA		Lab 2
10.20	Tue	Fall Break (No Class)
10.22	Thu	Normal Forms, cont. Denormalization		Draft Model
10.27	Tue	Normalization Exercise Test 3 Review		Phase 1
10.29	Thu	Test 3
11.03	Tue	Database Programming
11.05	Thu	Database Programming
11.10	Tue	Database Programming
11.12	Thu	Database Programming		Phase 2
11.17	Tue	Transactions	Transactions
11.19	Thu	Transactions, cont.		Lab 3
11.24	Tue	Thanksgiving Break (No Class)
11.26	Thu	Thanksgiving Break (No Class)
12.01	Tue	Disaster Recovery
12.03	Thu	MySQL Disaster Recovery		Phase 3
12.08	Tue	Data Privacy Data Security
12.10	Thu	Indexing Final Review		Lab 4