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

Oracle Certified Professional, MySQL 5 Developer

This certification is meant for professionals who aim to develop applications by using MySQL as the back-end storage system. Students attending the training are able to create and use tables and databases. They become proficient in data storage in MySQL database. This involves tasks like insertion, retrieval, modification and deletion.

Participants become capable of performing following activities:

  • Maintaining data in organizational databases
  • Performing data analysis
  • Importing, as well as exporting data

In order to achieve the Oracle Certified Professional, MySQL 5 Developer certification, students are required to clear both Part 1 and Part II exams. While it is advised that you clear Part 1 first and Part 2 later, the distinction in parts does not mean a difference in advancement level. Both the parts cover different expertise areas, and hence you can appear in the exams as per your choice.

This course was previously called SCMDEV, i.e. Sun Certified MySQL Developer. As the training is primarily about writing applications, the topics covered include functions, data types, queries, triggers, transactions, and stored procedures. The course curriculum also consists of practical sessions that tell you how to deal with complex queries.

The course is majorly attended by database designers, developers , and database administrators.

It offers the following skills:

  • Using MySQL tools for connecting to databases
  • Examining database structure, as well as contents
  • Generating diagrams of database structure
  • Executing complex queries
  • Manipulating data that can be in numeric, text or spatial form
  • Performing complex sub-queries

 

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

Essential Prerequisites:

  • Experience with having created tables and queries within relational Databases, and comfort with basic SQL statements and another programming language.
  • MySQL for Beginners

Recommended Prerequisites:

  • Some exposure to programming with databases.
  • Experience with Java or PHP would be useful.

 

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]