Chapter 1: IntroductionCourse Outline and Intro to MySQL and Database MySQL Architecture and Installation of MySQL Installation Demo – Part 1 Installation Demo – Part 2 Chapter 2: Database Design Database Design MySQL Workbench Download Database Table and Constraints Database Designing and Normalization – Part 1 Database Designing and Normalization – Part 2 Storage and Data Types Data Types Demo ACID and Transactions Locks, Deadlocks, Isolation Levels and Logging Isolation Levels and Locking Demo Locking Mechanism Demo and MySQL ACID Support Chapter 3: Administration Responsibilities of a Database Administrator Creating a User and Limiting Access to a Database; Basic Table Maintainance Function Protecting your Database; How to Perform Database Backup Performance Monitoring Chapter 4: Indexing for Performance InnoDB Indexing and Clustered vs. Unclustered Index Query and Where Clause Impact of Indexing on Database Performance Performance Optimization Chapter 5: SQL for Developers Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers Data Definition Language; How to Create Database Objects SQL Select Statements SQL Select Statements Demo Joins Combining Related Table Using Joins Insert, Update and Delete Commands Insert, Update, and Delete Commands Demo Chapter 6: Query Analysis and Optimization Query Optimization Query Optimization Demo Chapter 7: Data Replication Database Replication Setting Up Replication in MySQL Data Encryption Column-Level Database Encryption Demo High Availability Chapter 8: Conclusion
