This MySQL for Database Administrators training is a foundation course. It teaches database administrators and developers how to use this powerful database. Learn how to secure users privileges, set resource limitations and access controls. Instructors will show you how to create and use Stored Procedures, Triggers and Views.
The learning objectives including Install and Upgrade MySQL for the most common operating systems, Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server, Use the INFORMATION_SCHEMA database to access metadata, Perform the MySQL start and shutdown operations and many more.
This MySQL Database Administrator course is available at our public class training in Kuala Lumpur or In-House training at your venue, throughout Malaysia.
Who should attend?
A working knowledge of MySQL is required or attended on the Introduction to MySQL course.
The MySQL Server
Configuring the MySQL Server
Overview of Data Types
Transactions and Locking
Security and User Management
Exporting and Importing Data
Programming with MySQL
Backup and Recovery
Introduction to Performance Tuning
Introduction to High Availability