Schedule & Notes

---

Notes are in a password-protected directory and can be accessed using the following:

username:  parkerdir
password:  notAhard1

---

	Topic
Database Overview
Database Lifecycle Business Rules Relational Databases
Entity-Relationship Model
Entity-Relationship Model II E-R exercise (answer) ERD Example
Normalization
Relational Algebra SQL
Apache, MariaDB, PHP, phpMyAdmin Installation Command Line Interface MySQL/MariaDB Scripting phpMyAdmin Tutorials
SQL Practice Sample Databases Exercise – SQL Queries
Advanced SQL
Relational Algebra in SQL
MySQL/MariaDB Reference
Views Exercise – Views
Transactions
Stored Programs     Stored Procedures
Stored Functions     Exercise – Stored Procedures     Exercise – Stored Procedures
Triggers     Exercise – Triggers     Stored Program Error Handling     Exercise – Error Handling
SQL Injection Prevention
Data Warehouse Concepts
Data Warehouse Modeling
Data Warehouse Implementation
Big Data
NoSQL
Data Analytics
Preprogrammed SQL PHP and MySQL Database Access
Related Specializations and Techniques
Concurrency Control
Distributed Databases
PHP Introduction
PHP Basics
PHP Control Structures
PHP Functions
PHP Arrays
PHP and MySQL
2220 Web Development notes