Oracle 11g Certification Oracle Certified Professional(OCP) Oracle is widely regarded as the industry’s most advanced database management system. The Oracle 11g OCP is an advanced training program that covers topics such as database interfaces and security in the initial stages, and advanced topics such as database management in the next level. The OCP certification is an absolute must if you want to achieve any sort of success as a Database Administrator (DBA) or developer. The weight it adds to your resume and starting salary is unquestionable. With the experience that our faculty has on offer for our students, you can be rest assured of gaining valuable inputs throughout the course that you will be hard pressed to find anywhere else. We offer you unparalleled expertise that will help and guide you become an expert OCP. Oracle 11g OCP Exam #1Z0-007 Introduction to Oracle SQL £390.00 Oracle 11g OCP Exam #1Z0-052 Oracle Database 11g: Administration I £900.00 Oracle 11g OCP Exam #1Z0-053 Oracle Database 11g: Administration II £900.00 Offer Full OCP Certification Courses for £1590.00		Why enrol with us? Training with official Oracle WDP partner Hands-on training from Oracle Certified Instructor Small interactive A/C classrooms Oracle training manual developed and produced by Oracle Fullfil mandatory Oracle training requirement Discount on Oracle exams 50% Off on self-test software Free Oracle Magazine Free students membership with Oracle All this for just £1590
Oracle 10g OCP Certification Exam and Courses Highlight Oracle OCP Exam #1Z0-007 Introduction to Oracle SQL Oracle OCP Exam #1Z0-052 Oracle Database 11g: Administration I Oracle OCP Exam #1Z0-053 Oracle Database 11g: Administration II Oracle OCP Hands On Requirement Submit the Hands On Course Requirement Form from Authorized Training Center(BCOC)

OCP Exam# 1Z0-007: Introduction to Oracle SQL

SQL Select Statements
SQL SELECT statements
Execute a basic SELECT statement
Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
Limit the rows retrieved by a query
Sort the rows retrieved by a query

Single-Row Functions
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Use conversion functions

Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using equality and nonequality joins
View data that generally does not meet a join condition by using outer joins
Join a table to itself using a self-join

Aggregating Data using Group Functions
Identify the available group functions
Use group functions
Group data using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Subqueries
Describe the types of problems that subqueries can solve
Define subqueries
List the types of subqueries
Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus
Produce queries that require a substitution variable
Produce more readable output
Create and execute script files

Manipulating Data
Describe each DML statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Merge rows in a table
Control transactions

Creating and Managing Tables
Describe the main database objects
Create tables
Describe the datatypes that can be used when specifying column definition
Alter table definitions
Drop, rename and truncate tables

Including Constraints
Describe constraints
Create and maintain constraints

Creating Views
Describe a view
Create, alter the definition, and drop a view
Retrieve data through a view
Insert, update and delete data through a view
Create and use an inline view
Perform Top 'N' Analysis

Creating Other Database Objects
Create, maintain and use sequences
Create and maintain indexes
Create private and public synonyms

Controlling User Access
Create users
Create Roles to ease setup and maintenance of the security model
Use the GRANT and REVOKE statements to grant and revoke object privileges

OCP Exam #1Z0-052
Oracle Database 11g: Administration I

Oracle Database Architecture
Memory Structures
Process Structures
Storage Structures

Database Environment
Oracle Database Administration
Oracle Database Planning and installation
Oracle Universal Installer (OUI), Oracle Database Installation

Oracle Database
Create Oracle Database
Database Configuration Assistant (DBCA)

Oracle Instance
Manage Oracle Instance
Initialization parameters
Stages of database startup and shutdown
Alert log and trace files
Data dictionary and dynamic performance views

Oracle Network Environment
Configure and Manage the Oracle Network
Oracle Shared Server architecture

Database Storage Structures
Manage Database Structures
Tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces

Administering User Security in Oracle Database
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Managing Schema Objects
Create and Modify tables
Manage Constraints
Create indexes
Create and use temporary tables

Data and Concurrency
Manage data using DML
Identify and administer PL/SQL objects
Monitor and resolve locking conflicts

Undo Data
Introduction to Undo data
Transactions and undo data
Managing undo

Oracle Database Security
Manage Oracle Database security
Principle of Least Privilege
Standard Database Auditing

Oracle Database Maintenance
optimizer statistics
Automatic Workload Repository (AWR)
Use advisory framework
Alerts and Thresholds

Performance Management
Automatic Memory Management
Memory Advisors
Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements
Enterprise Manager Support Workbench
Managing Patches

Oracle Database Backup and Recovery
Configure Oracle Database Backup and Recovery
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode

Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups,
view backup reports and monitor the flash recovery area

Performing Database Recovery
Oracle Data Recovery Advisor
Oracle Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Moving Data
use methods to move data (Directory objects, SQL*Loader, External Tables)
Architecture of Oracle Data Pump
Data Pump Export and Import to move data between Oracle databases

OCP Exam #1Z0-053
Oracle Database 11g: Administration II

Using Globalization Support Objectives
Customize language-dependent behavior for the database and individual sessions
Specify different linguistic sorts for queries
Oracle Database Architecture and ASM
Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create virtual private catalog

Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Using RMAN to Create Backups
Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

User-Managed Oracle Database Backup and Recovery
Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

RMAN to Duplicate a Database
Creating a duplicate database
Using a duplicate database

Performing Tablespace Point-in-Time Recovery
Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN
Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

Flashback Technology
Restore dropped tables from the recycle bin
Perform Flashback Query
Flashback Transaction

Additional Flashback Operations
Flashback Table operations
Configure, Monitor Flashback Database
Perform Flashback Database operations
Set up and use a Flashback Data Archive

Diagnosing the Database
Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

Managing Memory
Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance
SQL Tuning Advisor
SQL Access Advisor to tune a workload
Understand Database Replay

Space Management
Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources
database resource manager
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks

Administering the Scheduler
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs

Globalization
Customize language-dependent behavior for the database and individual sessions
Working with database and NLS character sets