You are here:Courses|Oracle|Database Development|Oracle 10g OCA Developer

Oracle 10g OCA Developer

Oracle 10g OCA Developer Training aims to introduce participants to PL/SQL and help them understand the advantages of using this programming language. Students are trained to create PL/SQL application codes which can be shared easily by multiple reports, forms and data management applications.

Course Objectives :

  • Creating stored procedures and functions as well as anonymous PL/SQL blocks
  • Controlling code flow using conditional loops and control structures
  • Using PL/SQL packages in order to group and contain related constructs
  • Creating triggers to meet business challenges
  • Using Oracle PL/SQL packages for generation of file output and screen output
  • Declaring PL/SQL Variables
  • Creating subprograms for better flexibility
  • Customizing features of PL/SQL applications without removing source code

This Oracle 10g OCA Developer Course is highly recommended for application developers, technical consultants, forms developers, portal developers, system analysts as well as for database administrators who wish to optimize database workloads by consolidating on to database clouds and delivered high performance while lowering IT costs. So get set to make your IT more productive and efficient with this advanced course on Oracle database.

 

Course Contents Exam# Exam Regular Track
(days)
Fast Track
(days)
Oracle 10g: Introduction to SQL 1Z0-047 SQL Certified Expert 5 3
Oracle 10g: Program with PL/SQL 1Z0-147* Program with PL/SQL 5 3
Balance Days  for day of arrival, exam(s) and practice 3 3
Total duration 13 9

Prerequisites

  • Familiarity with Data Processing Concepts and Technical Ability to use a graphical user interface (GUI)

 

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]