# # # #

Service Center

Oracle 11g DBA OCA Certification Training Courses Online or CD for Administrators

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
To earn a certification from Oracle you must also complete a hands-on class from Oracle. Please check Oracle's website for any changes