| Week | Content | Material | Solutions |
|---|---|---|---|
| W01 | Introduction to MS Access | ||
| W02 | SQL Server Orientation - Account Setup - Home Installation Tips | ||
| W03 | ERDPlus and ER Examples (entities) | ||
| W04 | ER Examples on ERD+ | W05 | Project Assignment and Discussion + PHP and SQL Server | PDF, lab7-Supplemental.zip |
| W06 | Relational Algebra | ||
| W07 | SQL-DDL I | TXT | |
| W09 | SQL-DML I (Basic Block SELECT-FROM-WHERE, and Set operators) | PDF, Northwind.txt | |
| W10 | SQL-DML II (Joins, Aggregates, Nulls, Order, Like) | ||
| W11 | SQL-DML III (Views, Triggers) and DB Programming I (Sproc and Procedural) | ||
| W12 | DB Programming II (Selected topics: Indexes, Transactions, Graphs, Json , Administration, Role Management, etc.) | ||
| W13 | Project Phase B - Exam. |