MySQL DBA Training Course in Jaipur
Industry-oriented certification Digital Marketing training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate
Professional expert Sr. Digital Marketing Institute With 15+ Years of working experience will provide you industrial level training.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete E-liteworkshop.
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 |