MySQL for DBAs (5 days)

• Do you want to have hands-on experience administering a MySQL database?
• Are you concerned about your MySQL database being secure?
• Do your users have the correct privileges and access rights?
• Do you want to develop and implement a backup strategy for you MySQL data?
• Do you want to utilize the latest features of the MySQL server to improve efficiency?

Then MySQL for DBAs is the class for you! An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, implement partitioning, manage users and so much 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 the latest features such as Partitioning, Stored Procedures, Triggers and Views.

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
• Use the INFORMATION_SCHEMA database to access metadata
• Install and upgrade MySQL 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 Explain and utilize Partioning
• 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
• Understand how stored routines and triggers can be used for administration tasks
• Manage, apply and understand the reason for using views
• Describe ways that MySQL performance can be improved
• Describe how MySQL can be used for high availability

Certification

• Combined with sufficient practical experience, this course prepares you for the Database Administrator Certification Exams

Who should Attend

• DBAs and developers who want to administer MySQL

Prerequisites

• Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL.

Format

• Instructor led, with hands-on lab exercises
• Each student will be provided with their own computer

Applies to MySQL Version

• 5.0, 5.1

Duration

• 5 Days

Upcoming Sessions