Mysql

Modules / Chapter

Module 1: Introduction

• Course Outline and Intro to MySQL and Database
• Essential Information for a Successful Training Experience
• MySQL Architecture and Installation of MySQL 
• Installation Demo - Part 1 
• Installation Demo - Part 2 

Module 2: Database Design

• MySQL Workbench Download
• Database Table and Constraints
• Database Designing and Normalization - Part 1
• Database Designing and Normalization - Part 2
• Data Types Demo
• ACID and Transactions 
• Locks, Deadlocks, Isolation Levels and Logging 
• Isolation Levels and Locking Demo
• Locking Mechanism Demo and MySQL ACID Support

Module 3: Administration

• Responsibilities of a Database Administrator 
• Creating a User and Limiting Access to a Database; Basic Maintenance Function
• Protecting your Database; How to Perform Database Backup
• Performance Monitoring 

Module 4: Indexing for Performance

• Course Review
• Innocent Indexing and Clustered vs. Uncluttered Index
• Query and Where Clause
• Impact of Indexing on Database Performance
• Performance Optimization

Module 5: SQL for Developers

• Char vs. Var char 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

Module 6: Query Analysis and Optimization

• Query Optimization
• Query Optimization Demo

Module 7: Data Replication

• Database Replication 
• Setting Up Replication in MySQL 
• Data Encryption
• Column-Level Database Encryption Demo 
• High Availability

Module 8: Conclusion

• Closing 
• MySQL Quiz