Module 1: MySQL Architecture and Fundamentals

• Introduction to MySQL

• MySQL Architecture

• Server and Client Architecture

• Real-World Use Cases

Module 2: Storage Engines

• Storage Engine Types

• Storage Engine Characteristics

• InnoDB

• MyISAM

Module 3: Installation, Networking and Security

• MySQL on Linux

• Installation MethodsRPM Installation
  Binary Installation
  Source Installation

• Operating System Security

• File System Security

• Network Security

Module 4: User and Database Administration

• User Account Management

• User Privileges

• Administrative Privileges

• Database Access Privileges

• System Variables

• Session and Global Configuration

• MySQL Configuration (my.cnf)

• MySQL Administration ToolsMySQLAdmin
  MySQLBinlog
  MySQLDump
  MySQLImport

Module 5: Database Maintenance

• Table MaintenanceAnalyze Table
  Check Table
  Checksum Table
  Optimize Table
  Repair Table
  

• Moving Tables Between Schemas, Servers and Tablespaces

Module 6: Locking, Backup and High Availability

• Locking MechanismsTable-Level Locking
  Row-Level Locking
  Internal and External Locking
  Deadlocks

• Backup and Recovery

• Backup Types

• Backup & Recovery Tools

• Load Data Infile

• Select Into Outfile

• Replication Fundamentals

• Master-Slave Replication

• Replication Filters

• MariaDB & Galera Replication

• Master-Master Replication

• MySQL Upgrade Process

Module 7: Monitoring and Performance Tuning

• Database Monitoring

• Information Schema

• Performance Schema

• MySQL LogsError Log
  Query Log
  Slow Query Log
  Binary Log
  Relay Log
  General Query Log

• Identifying Slow Queries

• ProcessList

• InnoDB Transactions

• Query Optimization

• EXPLAIN

• Performance Tuning Best Practices

Module 8: MySQL Development

• Basic SQL Queries

• JOIN Operations

• Subqueries

• UNION

• Built-in Functions

• User-Defined Functions

• Stored Procedures