Oracle Certified Professional (OCP) MySQL 5 Database Administrator
Exam
Exam fees included
Course code
mysql
Course pricing varies based on delivery method and location.
Why choose Firebrand
150,000 +
professionals trained worldwide
25+
years of delivering accredited IT training
Top 20
IT training company globally
70%
of learners return for another course
What you’ll learn
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
Curriculum
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
Prerequisites
To succeed fully in this course, students should have 1 year's experience with Relational Databases and SQL.
Exam info
As part of this accelerated course, you will prepare for this exam, covered by our Certification Guarantee:
MySQL 5 Database Administrator Certified Professional Exam, Part I - 1Z0-873
MySQL 5 Database Administrator Certified Professional Exam, Part II - 1Z0-874
Please note that it is not possible to sit Oracle exams onsite. As part of this course, delegates receive an exam voucher to take exams remotely.
70% of our customers return to book more training. Here's why.
Interested in this course?
Speak to one of our learning advisors for information on upcoming course dates, pricing, delivery options and team training.
No obligation • Free consultation
Talk to a Firebrand expert
Get personalised guidance from our learning advisors and discover the best way to achieve your training goals.
- Course recommendations
- Flexible training options
- Team and private delivery available
FAQs
Yes, we do provide courses suitable for beginners. However, Firebrand's accelerated courses aren't easy and it's essential that you are interested and actively pursuing a career in IT.
Traditional training providers usually run their courses from 9am to 5pm. At Firebrand Training we maximise the number of learning hours to minimise the number of training days, so you’ll be back to your job as quickly as possible. You don’t waste time travelling to several courses and finding an exam centre after that.
Firebrand's accelerated courses are constantly reviewed. We ask our delegates for feedback after every course. We are official partners with leading vendors and therefore, we're provided with certification changes and updates, which we can then implement in our course delivery at a very early stage. This feedback is then analysed in view of changes or discrepancies. We will then address the topics mentioned and have a panel of subject matter experts provide us with valuable suggestions for improvement and solutions.
If you need to learn new skills and you want to be able to put them into practice quickly, then Firebrand is the right training company for you.
Our unique accelerated training method means that we are your fastest way to learn. By delivering training for up to 12 hours per day, seven days per week, with exam centres on-site, we ensure that you are trained and certified quicker than anywhere else, having spent less time out of the office away from the day job.
Train your team
Since 2001 we’ve trained 135,000+ employees from thousands of large and small organisations, saving them more than one million hours in training time.