MySQL DBA Training

Training in BTM Layout is a leading Training as well as Placement company with experience in leading IT Sectors of India. Our training reproduces the latest technologies, techniques, as well as processes that are advanced in practical knowledge collected from years of experience. 

MySQL DBA Training in BTM Layout offers planned training paths intended for the certification skills necessary to work in latest technological environment, while offering a wide-ranging curriculum of application centric courses for customers looking to implement upgraded/new business applications. 

The purpose of software Professional training is to help students to advance their knowledge overtime while being acknowledged for their achievement.

MySQL DBA Training in BTM Layout is an outstanding Online and corporate training center. We provide a number of tailored training programs for small, medium along with big organizations in Bangalore and across India. 

Our training courses are very cost effective for all clients/students plus students. Our training Syllabus is prepared from the team of experts and the students can improve from basic knowledge to advance level. 

Our Syllabus includes Database Basics , Installation and Configuration , Configuration , Users and security, Mysql Backup , Trouble shooting and Performance Tuning/Optimization for large db’s , Trouble shooting and Performance Tuning/Optimization for large db’s , Monitoring and Security Practices , Bash Scripting with real time experience.

Training in BTM Layout is one of the greatest Software training institutes in Bangalore with 100% placement support. It has well defined training modules in addition to training sessions for pupils. 

At MySQL DBA Training in BTM Layout, training is conducted in day time classes on all weekdays as well as weekends to suit the timings for all students and working professionals .MySQL DBA Training in BTM Layout helps you acquire a foothold in the growing IT & ITeS industry. 

100% Placement Assistance- While a student finishes his/ her course effectively, our dedicated Placement Cell arranges interviews with major companies. This wide hands-on experience in Software training ensures that you captivate the knowledge as well as skills that you can apply at work after your placement. 

All of our mentors are work specialists with years of experience in well recognized IT sectors. Learning from the work experts is the only method to understand what happens in the actual IT world.

Syllabus:

• 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.