MySQL DBA Advanced

Name: MySQL DBA Advanced
Price: 8000 INR

This course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, configuration and optimization.

89 STUDENTS ENROLLED

MySQL DBA Online Training

The MySQL DBA Online Training course includes Installation to advanced performance tuning. Most noteworthy, the course have been delivered by the Instruction for many corporate clients. Therefore, with our MySQL DBA Online Training you’ll learn concepts in detailed and with hands on examples.

About This course

MySQL DBA Online Training designed for freshers and experienced professionals. MySQL, an open-source relational database management system (RDBMS) is the most trusted. It is used by the Banking sectors, Health Insurance companies and several other companies including Facebook. Companies whose business is based on complex transactions, payroll processes opt for Mysql. And Mysql Enterprise Version comes with Oracle Support. In addition the MySQL DBA Online Training has evolved over the years.

Course Objectives

First of all, this course is designed to give administrators the knowledge and skills. The Skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services. Consequently, Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases. They will have in depth knowledge on Replication, High availability features of MySQL and in depth knowledge Security.

Practical Includes:

Using Stored Procedures for Database Administration Tasks
User Management
Securing the Server
Upgrade-Related Security Issues
Optimizing Queries
Optimizing Schemas
Optimizing the Server
The Event Scheduler
Partitioned Tables
Interpreting Error Messages
Optimizing the Environment
MySQL Replication
MySQL Cluster

Course Curriculum

Variables and Stored Routines
	MySQL DBA 16. User Variables and Prepared Statements	24 hours
	MySQL DBA 17. Stored Procedures and Functions in MySQL	24 hours
	MySQL Lab 9 Stored Routines	10, 00:00
	MySQL DBA 18. Triggers in MySQL	24 hours
	MySQL DBA 19. Partitioned Tables in MySQL	24 hours
	MySQL Lab 10 Partitioning in MySQL	10, 00:00
Security
	MySQL DBA 20. Securing MySQL Server	24 hours
Optimization and Performance Tuning
	MySQL DBA 21. Optimizing MySQL Queries	24 hours
	MySQL DBA 22. Optimization and Indexes in MySQL	24 hours
	MySQL DBA 23. Optimizing MySQL Schemas	24 hours
	MySQL DBA 24. Optimizing MySQL Server	24 hours
	MySQL Lab 11 Benchmarking your MySQL servers	10, 00:00
	MySQL DBA 25. Optimizing MySQL Environment	24 hours
Scaling and High Availability
	MySQL DBA 28. MySQL Clusters Introduction	24 hours
	MySQL DBA 26. Understanding Replication Concepts	24 hours
	MysQL DBA 27. GTID Based Replication in MySQL	24 hours
	MySQL Lab 12 Replication in MySQL	10, 00:00
	MySQL DBA 28. Cluster Part 1	00:30:00
	MySQL DBA 29. Cluster Part 2	00:20:00
	MySQL Lab 14 MySQL Cluster Setup on CentOS	10, 00:00