I am working has MySQL DBA for around 5+ yrs, attached Course contents with this
Course Fee: Rs.7000
Hours : 24
MySQL DBA Training
Database Basics
Basics of RDBMS
ACID Properties
Isolation Levels
MySQL Intro
Architecture of MySQL(Physical, Logical)
Installation and Configuration
Installation of MySQL: Windows, Linux
Working with mysql objects: (Tables, Views, Stored procedure, Events)
Error handling
Pluggable engines: (MyISAM, InnoDB, Memory, CSV, Federated, Blackhole, Merge)
Working with MySQL configuration file.
Configuration
Config file for InnoDB in detail.
Congifuring log files (slow log, general log)
Users and security, Mysql Backup
Topics: Creating Users
Granting and revoking privileges
Taking user backup, changing password.
Topics: Backup requirement
Physical and logical backup
Cold and hot backup
Enabling and disabling binary logging
Understanding the binary log architecture
Different backup techniques in mysql (MySQL dump, Full backup, Transactional backup, Percona Xtrabackup)
Restoring mysql backup, Purging old logs
Mysql Binlog utility and PITR.
Trouble shooting and Performance Tuning/Optimization for large db’s
General Problems and their resolution,
Connection problems, and understanding the error log.
Performance tuning – Index suggestions
Usage of HeidiSQL Tool.
Optimization – Optimizing the Mysql database.
Replication
Master-Slave Replication
Master-Master replication
Monitoring and Security Practices
Monitoring the availability