September 2, 2016

Oracle Database Courses

Oracle Certified Associate (OCA)

 

Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification:  Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master (OCM).

Oracle Certified Associate (OCA)
This oracle certification course is designed to identify, develop and certify individuals with requisite IT skills and knowledge for Database Management. It provides people of all ages with the means to increase their IT skills, prove their expertise and advance their professional careers.

Pre-requisite

No knowledge of computer and/or IT is required to attend this program.


Course Content

The courses that are covered in this program include:

  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing Database Instances
  • Managing ASM Instances
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support 

For Whom

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

Commencement Date

Date: 8th August, 2016

* Participants can still join 2 weeks after class commencement date.

Time: 10am – 5pm

Duration

*Weekdays

Duration: 54 hours over Six (6) weeks. (Monday, Wednesday & Friday)

Time: 9am – 12noon

Weekends

Time: 10:00am- 2:00pm

Training 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 80% practical.

Benefits

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

  • Install Oracle 11g Software, Create Database, configured database,Control,Secure, managed and monitor Oracle 11g database.
  •  Be suitable for employment in Banks, IT firms and other big organizations that need Database Management.
  • Have individual confidence and security in being a part of today’s IT world.
  •  Be prepared for Oracle Certified Professional course(OCP). 

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)

[NEXForms id="36"]

 

 

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.

Pre-requisite

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

Benefits

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: 8th August, 2016

Duration

Weekdays

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

Time: 10 am – 1 pm 

Weekends

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)

 

 

Oracle Business Intelligence Enterprise Edition (OBIEE)

 

With the evolution of data, businesses and organizations are migrating to Analytics. According to Petter Bae Brandtzæg of SINTEF ICT, 90% of world data was generated within last 3 years. Business owners and organization’s decision-makers are therefore making data-driven decisions and predictions. Business data is now been analyzed to gain insight and make decision at a speed of thought. OBIEE is the answer to is the answer to this Analytics.

Pre-requisite

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


Course Content

The topics that are covered in this program include:

  • Overview and New Features of  OBIEE 12c
  • Creating Analyses
  • Creating Dashboards
  • Visual Analyzer Option
  • Actionable Intelligence
  • Introduction to RPD Modelling
  • Advanced RPD Modelling
  • Architecture and Installation (including upgrades)
  • Security
  • Systems Management

For Whom

  • Application Developers
  • Business Analysts
  • Business Intelligence Developer
  • Data Modelers
  • Data Warehouse Administrators
  •  Data Warehouse Analysts
  • Data Warehouse Developers
  • Reports Developers
  • End Users
  • Functional Implementers
  • Technical Consultants
  • Graduates
  • Job-seekers

Commencement Date

Date: 8th August, 2016

Duration

Weekends

5 Saturdays

Time: 10:00am – 5:00pm

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)