Session : 1 – Database Basics

  • Basics of RDBMS
  • ACID Properties
  • Isolation Levels
  • MySQL Intro
  • Architecture of MySQL(Physical, Logical)

Session : 2 – 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.

Session : 3 – Configuration

  • Config file for InnoDB in detail.
  • Congifuring log files (slow log, general log)

Session : 4 – 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.

Session : 5 – 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.

Session : 6 – Replication

  • Master-Slave Replication
  • Master-Master replication

Session : 7 – 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.

Session : 8 – Bash Scripting

  • Scripting for monitoring and backup and other DBA related basic scripts.

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya