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
|
