January 2025
M T W Thursday F
6 
Class:
Introductions
Syllabus
Review of entity relationships
Review of normalization forms
7 
8 
9 
Syllabus
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 1 (Optional)
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 2 (if needing a refresher)
Review of normalization forms
Module 01 Exercises
Deadline for full refund
10 
13 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 3

Class:
Review of normalization forms
Enhanced ER Model (summary, slides)
14 
15 
16 
Review Module 01 Exercise Answers
Module 02 Exercises

Due:
ER & EER Discussion (Due Saturday Night)
17 
20 
MLK Holiday (no class)
21 
22 
23 
24 
27 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 5

Class:
Advanced SQL I (slides, exercises, exercises (in-class))
28 
29 
30 
SQL I Exercises
31 

February 2025
M T W Thursday F
3 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 6

Class:
Advanced SQL II (slides)
4 
5 
6 
SQL 2 Exercises
7 
10 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 7

Class:
Physical Database Design and Performance I
11 
12 
13 
14 

Legend

Read
YouTube video
Assignment (submit through CougarVIEW)
CougarVIEW Quiz
Project (submit through CougarVIEW)