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.		Draft Model
10.27	Tue	Normal Forms, cont. Denormalization		Project Model
10.29	Thu	Database Programming
11.03	Tue	Database Programming		Project DB Implementation
11.05	Thu	Test 3
11.10	Tue	TBA
11.12	Thu	TBA
11.17	Tue	Transactions		Project App Dev 1
11.19	Thu	Transactions, cont.	Transactions	Lab 4
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
12.08	Tue	Data Privacy Data Security		Project App Dev 2
12.10	Thu	Indexing Final Review		Lab 5