Introduction
- Course Outline and Intro to MySQL and Database
- READ ME: Essential Information for a Successful Training Experience
- MySQL Architecture and Installation of MySQL
- Installation Demo - Part 1
- Installation Demo - Part 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
Administration
- Responsibilities of a Database Administrator
- Creating a User and Limiting Access to a Database; Basic Maintainance Function
- Protecting your Database; How to Perform Database Backup
- Performance Monitoring
Indexing for Performance
- Course Review
- InnoDB Indexing and Clustered vs. Unclustered Index
- Query and Where Clause
- Impact of Indexing on Database Performance
- Performance Optimization
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
Query Analysis and Optimization
- Query Optimization
- Query Optimization Demo
Data Replication
- Database Replication
- Setting Up Replication in MySQL
- Data Encryption
- Column-Level Database Encryption Demo
- High Availability
Conclusion
- Closing
- MySQL Quiz
