Software Training

Oracle Certified Professional (OCP) in Database
OCP-DBA 3 Months


Objective :Oracle Developer is a 4GL GUI application Builder. With Developer, you can create forms, reports, and graphics. Oracle Forms and Oracle Reports are two components of Oracle Developer. Earlier versions created client-server applications, but the more recent versions create web applications that run under the Oracle Application Server (OAS). OAS is a web-based application server sold by Oracle. OAS is licensed separately and is very expensive (as are its closed source competitors).


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

  • 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 the Set Operators
  • Using Subqueries to Solve Queries
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

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

  • 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

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

  • 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 Table space 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

Alliance Partner