Week | Dates | Topics | Chapters |
1 | Jan 18 - Jan 20 |
Introduction to DBMS and SQL Developer |
MDM Ch. 1 |
2 | Jan 23 - Jan 27 |
SQL Basics |
OSE Ch. 1 -5 |
3 | Jan 30 - Feb 03 |
SQL Functions and Joins |
OSE Ch. 6 - 10 |
4 | Feb 06 - Feb 10 |
SQL Data Manipulation and Definition |
OSE Ch. 11 - 15 |
5 | Feb 13 - Feb 17 |
Reg Ex, Test 1, and SQL Optimization |
OSE Ch. 16, 18 |
6 | Feb 20 - Feb 24 |
Modeling Data |
MDM Ch. 2 |
7 | Feb 27 - Mar 02 |
Enhanced E-R Model |
MDM Ch. 3 |
8 | Mar 05 - Mar 09 |
Logical Database Design |
MDM Ch. 4 |
9 | Mar 19 - Mar 23 |
Physical Database Design |
MDM Ch. 5 |
10 | Mar 26 - Mar 30 |
Review & Test 2 |
|
11 | Apr 02 - Apr 06 |
Data Warehousing |
MDM Ch. 9 and OSE Ch. 17 |
12 | Apr 09 - Apr 13 |
Database API (Python) |
Class Notes |
13 | Apr 16 - Apr 20 |
Content Management System |
Class Notes |
14 | Apr 23 - Apr 27 |
Content Management System |
Class Notes |
15 | Apr 30 - May 04 |
Review & Test 3 |
|