MySQL

• 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