January 2025
Monday T W Thursday F Saturday
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 
11 
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 
18 
20 
MLK Holiday (no class)
21 
22 
23 
24 
25 
27 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 5

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

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

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

Class:
Physical Database Design and Performance I (slides, SQL 2 exercises answers)
11 
12 
13 
14 
15 
17 
Before Class:
Modern Database Management, 13th Edition Cover Modern Database Management: Chapter 8

Class:
Physical Database Design and Performance II (slides)
18 
19 
20 
Due:
SQL 2 Homework
21 
22 
24 
Before Class:
Big Data Fundamentals Concepts, Drivers & Techniques Cover Big Data Fundamentals: Chapter 1

Class:
Understanding Big Data

Due:
Project 1
25 
College Career Fair 12-2 PM Student Recreation Center (Extra Credit)
26 
27 
28 

March 2025
Monday T W Thursday F Saturday
1 

Legend

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