Certification Exam Path for OCP (Exams in Oracle Exam Center with Separate Exam Fees)

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

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

• 120-053 Oracle Database 11g: Administration Workshop I Release 2

Training Course Outline 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

1Z0-053 Oracle Database 11g: Administration Workshop II Release 2

• Database Architecture and Recovery Operations

• The RMAN Catalog and Creating Backups

• Performing Restore and Recovery Tasks

• Using, Monitoring and Tuning RMAN

• Database Diagnostics and Flashback Technologies

• Managing Database Memory and Performance

• Managing Database Resources and the Scheduler

• Managing Database Space and Duplication