Course content
- Database Basics
- Basics of RDBMS
- ACID Properties
- Isolation Levels
- MySQL Intro
- The 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.
- Configuring log files (slow log, general log)
- Users and security, Mysql Backup
- Topics: Creating Users
- Granting and revoking privileges
- Taking user backup, changing passwords.
- 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.
- þÿ T r o u b l e s h o o t i n g a n d P e r f o r m a n c e T u n i n g / O p t i m i z a t i o n f o r l a r g e d b s
- General Problems and their resolution,
- Connection problems, and understanding the error log.
- þÿ P e r f o r m a n c e t u n i n g I n d e x s u g g e s t i o n s
- Usage of HeidiSQL Tool.
- þÿ O p t i m i z a t i o n O p t i m i z i n g t h e M y s q l d a t a b a s e .
- Replication
- Master-Slave Replication
- Master-Master replication
- Monitoring and Security Practices
- Monitoring the availability of MySQL,
- Monitoring different aspects of MySQL.
- Using tools for monitoring.
- Necessary Reporting for a MySQL DBA.
- Mysql Workbench, Percona Toolkit.
- Bash Scripting
- Scripting for monitoring and backup and other DBA related basic scripts.
Mode of Training
Online
Total duration of the course
5 to 7 weeks
Training duration per day
50 mins - 90 mins
Communication Mode
Go to meeting, WEB-EX
Software access:
Software will be installed/Server access will be provided, whichever is possible
Material
Soft copy of the material will be provided during the training.
Training
Both weekdays and weekends
Training Fee
$500