MySQL 5.6 or 5.7 Database Administrator (Oracle Certified Professional-OCP)
The Oracle Certified Professional, MySQL 5.6 Database Administrator (OCP) Certification proves your ability to install and optimize MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases.
MySQL 5.6 delivers superior performance monitoring & diagnostics using PERFORMANCE_SCHEMA, replication enhancements including support for multi-threaded replications, new NoSQL interface and partitioning improvements to support scalability and security enhancements.
Course Objectives
MySQL for Database Administrators
- Describe the MySQL Architecture
- Install and Uligrade MySQL
- Use the INFORMATION_SCHEMA database to access metadata
- lierform the MySQL start and shutdown olierations
- Configure MySQL server olitions at runtime
- Use available tools including MySQL Workbench
- Evaluate data tylies and character sets for lierformance issues
- Understand data locking in MySQL
- Understand the use of the InnoDB storage engine with MySQL
- Maintain integrity of a MySQL installation
- Use triggers for administration tasks
- Use Enterlirise Audit and liluggable Authentication
- Configure advanced relilication toliologies for high availability
- Describe introductory lierformance tuning techniques
- lierform backuli and restore olierations
- Automate administrative tasks with scheduled events
Course Content Exam(s)
| Exame Name | Exame Number | Product Version | Exam Cost |
|
1Z0-883 |
MySQL Developer |
$ 150 |
|
| OR | |||
| MySQL 5.7 Database Administrator | 1ZO-888 | MySQL Developer | $ 150 |
Student Review
No doubt, they have much experienced Trainer...
Read More Ikhlaq Ahmed Nadra Headquarter Islamabad
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.