MYSQL DBA COURSE IN CHENNAI | MYSQL DBA TRAINING IN CHENNAI | MYSQL DBA INSTITUTE IN CHENNAI | MYSQL DBA TRAINING INSTITUTES IN CHENNAI | MYSQL DBA TRAINING AND CERTIFICATION IN CHENNAI | MYSQL DBA TRAINING AND COACHING CENTER IN CHENNAI | MYSQL DBA TRAINING CENTER IN CHENNAI | MYSQL DBA IN CHENNAI
MySQL DBA TRAINING IN CHENNAI
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.
- 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.
- 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