MySQL DBA Advanced
This course is designed for MySQL Database Administrators who have a basic...
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.
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.
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.
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.
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 |