Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Online MySQL DBA Training - Basic Level

No Reviews Yet

Course type: Online Instructor led Course

Platform: Online

Course ID: 37333

Course type: Online Instructor led Course

Platform: Online

No Reviews Yet

Date and Time

Not decided yet.

About Sarath

I did Microsoft Certifications and Oracle Certifications.I had around 12+ years of industry experience working on Oracle,MS SQL Server,MySQL database platforms as Sr Database Administrator. He has worked with Oxford Groups, EDS – Mphasis Company, Cognizant Technology Solutions.

I worked in United States and worked on large scale projects like EDS – General Motors, Rodale Inc., Houghton Mifflin Harcourt Inc. Pfizer Pharmaceuticals, AstraZeneca Pharmaceuticals, Blue Shield of California ,Cognizant etc..

Post graduated from Mahindra Engineering College, Tamilnadu.

I had a passion for providing SQL Server trainings and knowledge sharing sessions. I am conducting Online training and Corporate training as well. His main areas of focus include Performance Tuning, Clustering Issues, and Troubleshooting Principles in all rdbms as well Cloud Computing administration.

I am good at MSSQL Clustering, Oracle RAC and Performance Tuning.
No reviews currently Be the First to Review

About the Course


  • Real Time Scenarios and solutions

  • DBA Real time tools

  • ITIL Infrastructure Methods

  • Real Time Project with live demo

  • Interview Questions

  • Interview Preparation Sessions

  • Resume preparation

  • Mock Interviews

  • 6 Months Free Email Support,Call Support & Chat Support

Open Source Introduction
• Overview of MySQL
• History of MySQL
• The Main Features of MySQL
MySQL Installation

How to start, stop and restart the server
1.How to check the MySQL status
2.How to set /update the MySQL root/user password
• Mysql_install_db
• Mysql_secure_installation
• Mysql_tzinfo_to_sql

MySQL user management.
•How to maintain the user privileges using DDL & DCL Commands
•How to maintain the user privileges using DML Commands

MySQL Programs.
MySQL Client Programs.
• Mysql — the MySQL Command-Line Tool.
• Mysqladmin — Client for Administering MySQL Server
• Mysqlcheck — A Table Maintenance Program.
• Mysqldump — A Database Backup Program.
• Mysqlimport — A Data Import Program.
• Mysqlshow — Display Database, Table and Column Information
• Mysqlslap — Load Emulation Client

Storage Engines with Simple Examples

Configuring InnoDB
• InnoDB Table and Index Structures.
• Managing InnoDB Data and Log Files.
• InnoDB Startup Options.
• InnoDB Multi-Versioning.
• Restrictions on InnoDB Tables
• Memory allocation for Innodb
• Turnoff Innodb
• Innodb startup options

8.MySQL server logs
• Error Log
• General
• Slow Log
• Binary Log

Database Backup Methods
• Using mysqldump for Backups
• Dumping Data in SQL Format.
• Backup Tools ( Oracle Enterprise Backup (or) Percona XtraBackup )
• Restore & Recovery.

• Overview Replication
• Master-Slave Configuration
• Master-Master Configuration
• Replication trouble shooting / errors

Managing Multiple instances
• Setting Up Multiple Data Directories
• Running Multiple MySQL Instances on UNIX
• Running Multiple MySQL Instances on Windows
• Using mysqld_multi for Managing Multiple MySQL Servers

Performance Tuning
• InnoDB
• Performance Tuning
• Isolation Levels
• Error Handling

• Buffering and Caching
• The MyISAM Key Cache
• The InnoDB Buffer Pool

Locking Issues
• Internal Locking Methods
• Table Locking Issues
• Concurrent Inserts
• External Locking

Upgrading MySQL and Features.


No reviews currently Be the First to Review


Post your requirement and let us connect you with best possible matches for MySQL DBA Training Post your requirement now