You are here:Courses|Oracle|MySQL|Oracle Certified Professional, MySQL 5 Database Administrator

Oracle Certified Professional, MySQL 5 Database Administrator

This certification proves your capabilities in effectively managing various server-based issues.

The course makes students capable to:

  • Entirely set up a new server
  • Ensure smooth server operations
  • Use storage engines for prescribed tasks
  • Analyze other issues

MySQL DBAs are primarily responsible for the setup, management and optimization of MySQL servers in corporate structures. They provide assistance to teams that consist of MySQL programmers and users. The certification was previously called SCMDBA, i.e. Sun Certified MySQL Database Administrator. Students need to clear Part 1 and Part 2 exams in order to obtain this credential.

The training imparts various skills, such as securing user privileges, defining resource limitations, setting up access controls, and describing recovery fundamentals. You also learn about the creation and use of stored procedures, views and triggers. Oracle Certified Professional, MySQL 5 Database Administrator certification is meant for both Developers and Database Administrators.

The several course objectives include:

  • Understanding MySQL Architecture
  • Installing and upgrading MySQL
  • Using INFORMATION_SCHEMA database for accessing metadata
  • Performing start and end operations of MySQL
  • Evaluating character sets and data types for performance-related concerns
  • Understanding the effective way of MySQL installation
  • Using triggers for management tasks
  • Understanding views
  • Performing backup and recovery activities
  • Understanding data locking concepts in MySQL
  • Describing tuning techniques related to introductory performance

 

Course # Course Content Exam# Exam Regular Track
(days)
Fast Track
(days)
Super Fast Track
(days)
Oracle Certified Professional, MySQL 5 Database Administrator MySQL for Database Administrators 1Z0-883 Oracle Certified Professional, MySQL 5.6 Database Administrator 7 5 3
Balance Days  for day of arrival and practice 3 2 2
Total duration 10 7 5

Prerequisites:

  • Some experience with relational databases and SQL
  • MySQL for Beginners

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]