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

Courses