Oracle Certified Professional (OCP) MySQL 5 Database Administrator

Note: This course was formerly called Sun Certified MySQL Database Administrator.

Oracle OCP MySQL 5 Database Administrator is the world's most popular open source database because of its fast performance, high reliability, ease of use, and dramatic cost savings.

Firebrand Training’s accelerated 5 day OCP MySQL 5 Database Administrator provides students with an intense immersion into MySQL version 5.0 & 5.1. The program is an accelerated course that provides experienced developers and administrators with the necessary skills to successfully develop and administer MySQL 5 applications. Students will learn from MySQL-Certified experts through a combination of lab exercises, lectures, and presentations.

This is an intense immersion learning experience - live, breathe, eat, drink, MySQL 5.0 administration and development for one week!

Students who can benefit from this course are Developers and DBAs with the following questions and needs:

• Is my MySQL database secure?
• Do my users have the correct privileges and access rights?
• Is your MySQL database operating at optimal efficiency?
• Do I want to increase the performance of your database and make sure it scales?
• Do I want to save time using features like Stored Procedures, Triggers and Views?
• Do I want to utilise the new enterprise features of MySQL 5.0?

During this course you will learn how to:

• Properly install MySQL
• Create Triggers and Views.
• Create and execute Backup Strategies
• Create secure Stored Procedures to update and access data
• Secure users privileges
• Set resource limitations, and access controls

Firebrand Training’s accelerated MySQL course will cover the following curriculum:

• 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
• Utilise the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
• Utilise MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performance
• Explain the MySQL connectors that provide connectivity for client programs
• 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
• Maintain integrity of a MySQL installation utilizing security protocols
• Manage user maintenance and access to a MySQL Server
• Manage the structural characteristics of your databases
• Create, Maintain and Manage MySQL tables
• Manage the structural characteristics of the tables within your databases
• Select the best data type for representing information and managing performance in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Perform bulk data import and export operations
• Utilize the SELECT statement to retrieve information from database tables
• Utilize expressions in SQL statements to retrieve more detailed information
• Write join expressions in your SQL statements to obtain information from multiple tables
• Utilise SQL statements to modify the contents of database tables
• Utilise subqueries in your SQL statements
• Understand data locking concepts and the different levels of locking in MySQL
• Perform backup and restore operations utilizing multiple MySQL tools
• Improve performance though query optimization
• Optimise Schemas (Databases) utilizing multiple techniques
• Create user defined variables, prepared statements and stored routines
• Create and manage triggers
• Use the INFORMATION_SCHEMA database to access metadata
• Manage, apply and understand the reason for using views
• Debug MySQL applications
• Scale-out deployments of MySQL

To succeed fully in this course, students should have 1 year's experience with Relational Databases and SQL.