OCA /OCP Oracle Database 11g (Exams 1Z0-051, 1Z0-052, and 1Z0-053)

Course Description:

This course is concerned with the Oracle Database Administration certification track, specifically for release 11g of the database. This course deals with administering databases using the Oracle database server 11g. To earn the certification, the course covers the following exams:

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

· 1Z0-052 : Oracle Database 11g Administration I

· 1Z0-053 : Oracle Database 11g Administration II

Who should attend this course?

· Anyone who wants to earn the Oracle database administration certification.

· Anyone who has SQL basics and want to be an Oracle database administrator.


Basic computer understanding.

Course Outline:

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

1Z0-052 : Oracle Database 11g Administration I

1Z0-053 : Oracle Database 11g Administration II

· Retrieving Data Using the SQL SELECT Statement

· Restricting and Sorting Data

· Using Single-Row Functions to Customize Output

· Using Conversion Functions and Conditional Expressions

· Reporting Aggregated Data Using the Group Functions

· Displaying Data from Multiple Tables

· Using Subqueries to Solve Queries

· Using the Set Operators

· Manipulating Data

· Using DDL Statements to Create and Manage Tables

· Creating Other Schema Objects

· Exploring the Oracle Database Architecture

· Preparing the Database Environment

· Creating an Oracle Database

· Managing the Oracle Instance

· Configuring the Oracle Network Environment

· Managing Database Storage Structures

· Administering User Security

· Managing Data and Concurrency

· Managing Undo Data

· Implementing Oracle Database Security

· Database Maintenance

· Performance Management

· Intelligent Infrastructure Enhancements

· Backup and Recovery Concepts

· Performing Database Backups

· Performing Database Recovery

· Moving Data

· Database Architecture and ASM

· Configuring for Recoverability

· Using the RMAN Recovery Catalog

· Configuring Backup Specifications

· Using RMAN to Create Backups

· Performing User-Managed Backup and Recovery

· Using RMAN to Perform Recovery

· Using RMAN to Duplicate a Database

· Performing Tablespace Point-in-Time Recovery

· Monitoring and Tuning RMAN

· Using Flashback Technology

· Additional Flashback Operations

· Diagnosing the Database

· Managing Memory

· Managing Database Performance

· Space Management

· Managing Resources

· Automating Tasks with the Scheduler

· Administering the Scheduler

Share this page!