Schedule & Notes

Week Title Exercises Reading
Introduction
Database Overview

Database Design
Relational Databases

Relational Databases (concluded)
Entity-Relationship Model
Entity-Relationship Model (concluded)
E-R exercise (answer)
ERD Example
Project Introduction
Entity-Relationship Model II
Independent Exercises
Normalization
Normalization (continued)
Normalization (concluded)
(Normalization exercises)
(Normalization exercises)
(answer)
Relational Algebra
SQL
SQL (concluded) (ZDNet SQL Reference – Part I)  Word version
EasyPHP Installation
Command Line Interface
MySQL Scripting
MySQL Workbench
Exercise – MySQL (creation/manipulation)
Advanced SQL
Advanced SQL (concluded)
Relational Algebra in SQL
MySQL Reference
Review
Sample Databases
Exercise – SQL Queries
(ZDNet SQL Reference – Part II)  Word version
Exam 1
Preprogrammed SQL
PHP Crash Course
    PHP Introduction
    PHP Installation
    PHP Basics
    PHP Control Structure
    PHP Functions
    PHP Arrays
    PHP and MySQL
    PHP Includes
PHP and MySQL Database Access
PHP Form Handling
Transactions
Spring Break  
Spring Break
Transactions (concluded)
Stored Programs
Exercise – Stored Programs
Exercise – Stored Programs
Triggers
Exercise – Triggers
Concurrency Control
Concurrency Control (continued)
Concurrency Control (concluded)
Distributed Databases
Distributed Databases (concluded)
Views
Exercise – Views
SQL Injection Attacks
Big Data
NoSQL
Data Analytics
Data Analytics (concluded)
Tue, 4/30 Final Exam: 12:30-2:30 p.m.