Database Technologies

Oracle

ORACLE CERTIFIED PROFESSIONAL DATABASE ADMINISTRATION (OCP-DBA 11g)


1Z0-051: ORACLE DATABASE 11g : SQL FUNDAMENTALS (40 HOURS)

  • Retrieving Data Using the SQL SELECT Statement
  • Retrieving & Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group functions
  • Using Subqueries to Solve Queries
  • Using DDL Statement to Create & Manage Tables
  • Creating Other Schema Objects

1Z0-052: ORACLE DATABASE 11g ADMINISTRATION WS I (40 HOURS)

  • Exploring the Oracle Database Architecture
  • Creating & Oracle Database
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data & Concurrence
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Performing Database Backups & Recovery

1Z0-053: ORACLE DATABASE 11g ADMINISTRATION WS II (40 HOURS)

  • Database Architecture & ASM
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Using RMAN to Create Backups, Recovery & Duplicate a Database
  • Performing Tablespace Point-in-Time Recovery Using Flashback Technology
  • Managing Memory & Database Performance
  • Managing Resources
  • Automating Tasks with the Scheduler

Alliance Partner