Is your MySQL database secure? Do your users have the correct privileges and access rights?
Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
Do you want to save time using features like Stored Procedures, Triggers and Views?
Do you want to utilize the new enterprise features of MySQL 5.0?
Then MySQL 5.0 for DBA's is the class for you! An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!
This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new 5.0 features such as creating and using Stored Procedures, Triggers and Views.
Skills Gained
At the completion of this course, you should be able to:
Describe the MySQL Architecture, general operational characteristics and resources utilized for running it.
Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application
Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
Use the INFORMATION_SCHEMA database to access metadata
Install and Upgrade MySQL 5.0 for the most common operating systems
Perform the MySQL start and shutdown operations
Configure MySQL server options at runtime
Activate and manage numerous server logs
Evaluate data types and character sets for performance issues
Understand data locking concepts and the different levels of locking in MySQL
Differentiate between the multiple storage engines available in MySQL
Create, Maintain and Manage MySQL tables
Perform backup and restore operations utilizing multiple MySQL tools
Manage user maintenance and access to a MySQL Server
Maintain integrity of a MySQL installation utilizing security protocols
Use stored routines and triggers for administration tasks
Manage, apply and understand the reason for using views
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!
This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new 5.0 features such as creating and using Stored Procedures, Triggers and Views.
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
