MySQL DBA Training Course in Jaipur

Certification

Industry-oriented certification Digital Marketing training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate

Experienced Faculty

Professional expert Sr. Digital Marketing Institute With 15+ Years of working experience will provide you industrial level training.

Placement Assistance

Receive placement assistance after completion of 70% training, E-liteteam will arrange interviews till you’ll get the placement.

LAB Facility

You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.

Workshop Sessions

You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete E-liteworkshop.

Admin Support

E-LITE's 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.

MySQL DBA Programme Details

Course Duration:50 HRS with Highly Skilled Corporate Trainers

MySQL DBA Training for Modules – Weekdays / Weekend

E-Lite Institute Jaipur – SQL Server DBA Certification Training Delivery Method:

  • Web / Desktop Base.
  • Instructor-Led Classroom Sessions.
  • Presentations/Demonstration/Practicals of concepts.
  • Handouts/Assignments/Real-time Exposure to work on Clients.

MySQL DBA Programme Modules

MySQL DBA Training Modules

  • Basics of RDBMS
  • ACID Properties
  • Isolation Levels
  • MySQL Intro
  • Architecture of MySQL(Physical, Logical)
  • 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)
  • 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.
  • 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 the availability of MySQL
  • Monitoring different aspects of MySQL.
  • Using tools for monitoring.
  • Necessary Reporting for a mysql DBA.
  • Mysql Workbench,Percona Toolkit.
  • Scripting for monitoring and backup and other DBA related basic scripts.

Find the MySQL DBA course details below.

Duration of Module

MySQL DBA Course Module Course Duration
MySQL DBA 40 – 50 (Hours)

Batch Timings

MySQL DBA Course Schedule Course Timing
Monday to Friday 8:00 AM – 10:00 AM
Monday to Friday 10:00 AM – 12:00 PM
Monday to Friday 2:00 PM – 4:00 PM
Monday to Friday 4:00 PM – 6:00 PM
Saturday/Sunday 8:00 | 12:00 | 2:00 | 4:00
Sunday 8:00 AM – 10:00 AM
Sunday 10:00 AM – 12:00 PM
Sunday 2:00 PM – 4:00 PM
Sunday 4:00 PM – 6:00 PM