Our training for Oracle Certified Associate certification shows prospective employers that you have mastered introductory Oracle skills and can perform foundation level tasks. A valid OCA certification is required for those looking to move on to the Oracle Certified Professional (OCP) level and  Oracle Certified Master (OCM) level certifications.

The OCA is a pre-requisite for more advanced Oracle certifications, such as the OCP.

Additionally, to achieve the Oracle's OCP certification you must also complete a training course from Oracle University

Our Training Includes
  24 x 7 Unlimited Online Access
 Full Multi Media Lessons
 Simulated Exercises to test ones understanding.
 Review Questions to test ones retention
 Printable Transcripts of Lessons

Certification Exam Path

• 1Z0-047 Oracle Database SQL Expert 
  or
• 1Z0-051 Oracle Database 11g: SQL Fundamentals I
• 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2

Training  Course Outline
1Z0-047 Oracle Database SQL Expert 

• Using SQL to Query Your Database
• Conversion Functions, Group Functions, and Joins
• Subqueries, Set Operators, and Data Manipulation
• Using DDL, Views, Sequences, Indexes, and Synonyms
• Controlling User Access and Managing Schema Objects
• Data Dictionary Views and Large Data Sets
• Managing Data in Different Time Zones
• Using Subqueries and Regular Expressions

1Z0-051 Oracle Database 11g: SQL Fundamentals I 

• Using SQL to Query Your Database
• Conversion Functions, Group Functions, and Joins
• Subqueries, Set Operators, and Data Manipulation
• Using DDL, Views, Sequences, Indexes, and Synonyms

1Z0-052 Oracle Database 11g: Administration Workshop I Release 2

• Database Architecture and Installation
• Database Creation and Instance Management
• The ASM Instance and Network Connectivity
• Storage Structures and User Security
• Managing Concurrency, Undo, and Auditing
• Managing Database Maintenance and Performance
• Backup and Recovery
• Moving Data and Oracle Support