September 6, 2016

Oracle Certified Professional (OCP)

Oracle Certified Professional (OCP)

The Oracle Certified Professional (OCP) certification course prepares IT experts for high-level jobs as database administrators, system architects and project managers.The Oracle Certified Professional(OCP) Certification course builds on the skills developed during Oracle Certified Associate(OCA)  training course.This course takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Oracle Certified Professional(OCP) certification requires validation of hands-on training and real-world experience, employers can trust that certified candidates meet the minimum standards for challenging database jobs.


Participants have to have undergone the Oracle Certified Associate(OCA) Training Course.

Course Content

The topics that are covered in this program include:

  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Setting
  • Creating Backups with RMAN
  • Restore and Recovery Tasks
  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN
  • Diagnosing the Database
  • Using Flashback Technology I
  • Using Flashback technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Managing Space
  • Managing Space for the Database
  • Duplicating a Database

For Whom

  • Administrative Officers/Managers
  • Accountants
  • Marketing/Sales Offices
  • Students, Job Seekers or any one that is required to work with Database.

Training Course Methodology & Benefits

Multiple training delivery methods are employed including Lectures, Demonstrations, Practical, Self Practice and workshop using real life case study with particular reference to Nigerian situations. The training is at least 90% practical(Hands on).

Benefits & Entitlements


At the end of the programme, a participant will be issued Certificate of attendance. In addition to this, the participant will acquire the skills and knowledge to:

  • Backup & Recover an oracle database.
  • Manage memory effectively, as well as how to perform some performance evaluation and tuning tasks
  • Be able to sit for and pass Oracle Certified Professional exams.

Commencement Date

Date: 15th January, 2018



Duration: 36 hours over six (6) weeks. Three (3) hours on every (Tuesdays & Thursdays)

Time: 10 am – 1 pm 


Duration: 36 hours over Two (2) months. Five (5) Hours, Saturdays Only.

Time: 10 am – 3 pm (Weekends)

Payment Methods

Interested individuals can pay using the following methods:

  • Pay at the centre of your choice
  • Pay to the bank using the following bank details

Account Number: 2011745387

Account Name: HiiT Plc

Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)

Installmental Payments (First Payment= 60% of Course Fee)