Oracle

Oracle Database 11g Certified Professional

ORACLE DATABASE 11G SQL FUNDAMENTAL                                              ( 40 hrs)

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

ORACLE DATABASE 11G WORKSHOP I                                                      ( 40 hrs)

Introduction
Exploring the Oracle Database Architecture
Installing your Oracle Software
Creating an Oracle Database Using DBCA
Managing the Database Instance
Managing the ASM Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Moving Data
Working with Support

ORACLE DATABASE 11G WORKSHOP II                                                            ( 40 hrs)

Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Creating Backups with RMAN
Restore and Recovery Tasks
Using RMAN to Perform Recovery
Monitoring and Tuning RMAN
Diagnosing the Database
Using Flashback Technology I and II
Performing Flashback Database
Managing Memory
Managing Database Performace
Managing Performace by SQL Tuning
Managing Resources
Automating Tasks with the Scheduler
Managing Space
Managing Space for the Database
Duplicating a Database