The MySQL for Database Administrators course is for MySQL DBAs and other professionals who want to install and optimize MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
Install and configure the MySQL server.
Secure users and data.
Understand the use of the InnoDB storage engine with MySQL.
Configure privileges and access controls.
Work with stored procedures and triggers.
Plan for disaster recovery.
Configure the server for performance and high availability.
Benefits to YouAfter taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether your application uses complex queries or the NoSQL API, and whether your preferred challenge is replicated servers or highly-tuned transactional systems. Engage in Hands-On PracticesExtensive hands-on practices guide you through each concept.
You will install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more. Explore real-world problems and discover best practices as you work with the tools and techniques used by professional MySQL database administrators.
There are no prerequisites for this course.
Configure advanced replication topologies for high availability