Home » Oracle Training Courses » Oracle Database 11g Administrator 
Certified Professional OCP

Oracle Database 11g Administrator Certified Professional OCP

The Professional SQL Oracle Database Certifications for Database Professionals

Course Contents:

Stage 1: Software Programming Fundamentals

Stage 2: Programming Best Practices

Stage 3: Software Development Principles

Stage 4: Systems and Database Design

Stage 5: Managing Information Systems

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

Stage 7: Oracle 1Z0-052 Oracle Database 11g: Administration I

Stage 8: Oracle 1Z0-053 Oracle Database 11g: Administration II

Course Code:

ORA-5

Course Duration:

12 months

Typical Study Hours:

120 - 130 hours

Course Fees:

See our Fee Guide

Course Demo:

Request an online Course Demo

Study Prerequisite:

Computer programming certifications or relevant industry experience.

Additional Information for Stage 1:

• Software Programming Fundamentals:
  • Getting Started
  • Designing Programs

^top

Additional Information for Stage 2:

• Programming Best Practices:
  • Programming Techniques and Strategies
  • General Coding Best Practices
  • Object-oriented Coding Best Practices
  • Maintaining Quality Code

^top

Additional Information for Stage 3:

Software Development Principles:

• Developing a User-Centred Software Design Approach
  • Introducing User-Centered Design
  • Developing an Application Using User-Centered Design
  • The Iterative Process in User-Centered Design
  • Practical Examples of User-Centered Design

^top

Additional Information for Stage 4:

Systems and Database Design:

• Database Design
  • An Overview of Database Design
  • The Database Design Methodology
• Database Fundamentals
• An Introduction to Database Systems
• Relational Databases
• Database Data Management
• Systems Analysis Fundamentals
• Data Flow Diagrams
• Entity Relationship Diagrams
• Data Dictionaries
• Completing the Logical Model
• Relational Principles
• Database Fundamentals
• Fundamentals of Database Design
• Normalisation and Physical Database Design
• Database Management
• Web and Database Integration
• Database Technologies
  • Object-Relational DBMSs
    • Characteristics
    • Mechanisms and Implementation
  • Data Warehousing
    • Fundamentals
    • Building, Using, and Managing
  • SQL Programming
    • Database Queries
    • Data Handling Techniques

^top

Additional Information for Stage 5:

Managing Information Systems:

• The Software Development Process
  • Principles
  • Management Practices
• Open Systems Standards I
• Open Systems Standards II
• Client/Server Fundamentals
• Client/Server Technology
• Client/Server Implementation
• Internet, Intranet, and Extranet Technologies
• Software Engineering
  • Personal Software Process I
  • Personal Software Process II
• Client/Server Technologies
• The Client/Server Model

^top

Additional Information for Stage 6:

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

• Oracle Database 11g: Using SQL to Query Your Database
  • Identify the functions, capabilities, and terminology associated with Oracle Database 11gs components and relational databases in general.
• Recognise the steps for using Oracle SQL Developer to create a new database connection and browse tables.
• Recognise the steps for using the SQL SELECT statement to retrieve different sets of data from a database.
• Recognise the steps for limiting and ordering the rows returned by a SQL query.
• Recognise ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.
• Recognise the steps for using SQL functions to modify, format, and otherwise manipulate returned data.
• Identify and write SQL queries to display, sort, and format output in a given scenario.
• Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.
  • Recognise the steps for using the CASE expression and the DECODE function to implement conditional processing.
  • Identify and write queries that convert data types and implement conditional processing, in a given scenario.
  • Recognise the benefits of using group functions to return values for groups of rows.
  • Identify the steps for creating, restricting, and nesting group functions.
  • Identify the steps for using joins to return data from more than one table.
  • Write queries that calculate values for groups of data and return values from multiple tables in a given scenario.
• Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
  • Recognise the steps for creating, defining, and naming a table, and for specifying data types for its columns.
  • Recognise the steps for using constraints to prevent invalid data entry into tables.
  • Recognise the steps for altering or dropping a table.
  • Identify the steps for creating and manipulating views to view or hide a tables data.
  • Recognise the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.
  • Create a new table and create and use a sequence, index, and synonym.
• Oracle Database 11g: Using Subqueries and Regular Expressions
  • Identify the steps for writing multiple-column and scalar subqueries.
  • Recognise the steps for solving problems by using correlated subqueries and the WITH clause.
  • Write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
  • Recognise the benefits of implementing complex match logic in the database, using regular expressions.
  • Identify the steps for using regular expressions functions and for accessing subexpressions.
  • Use regular expression functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.

^top

Additional Information for Stage 7:

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

• Oracle Database 11g: Database Architecture and Installation
  • Identify the main structural components of Oracle Database 11g.
  • Identify the components of the Oracle Database 11g memory structures.
  • Identify the functions of the Oracle Database 11 server and background processes.
  • Recognise how information is stored and structured within the Oracle Database 11g storage architecture.
  • Identify the necessary tasks and essential tools required to administer an Oracle Database 11g database.
  • Recognise the steps for planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI).
  • install Oracle Database 11g software in a given scenario.
• Oracle Database 11g: Database Creation, Instance Management, and Connectivity
  • Recognise the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.
  • Recognise the scope and capabilities of Oracle Database 11g initialisation parameters and identify the steps for maintaining them.
  • Recognise the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.
  • Recognise the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.
  • Create a database using the DBCA and manage instances using Enterprise Manager.
  • Recognise ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.
  • Identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.
  • Identify the steps for using and configuring Oracle Net Services in a given scenario.
• Oracle Database 11g: Storage Structures and User Security
• Recognise the purposes of table spaces and datafiles.
• Recognise the steps for creating a new tablespace.
• Recognise how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).
• View tablespace information and create a new tablespace.
• Recognise the steps for creating and authenticating database user accounts.
• Recognise the steps for granting and revoking privileges and creating and managing roles.
• Recognise the steps for creating and managing profiles, implementing password security, and assigning quotas.
• Grant privileges to users in a given scenario.
• Oracle Database 11g: Managing the Schema, Data, and Concurrency
  • Recognise the features and functions of schemas and data types, and identify the steps for modifying a table.
  • Recognise the steps for using constraints to maintain data integrity, viewing the contents of a table, and perform actions on the table.
  • Recognise ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables.
  • Create a table with columns and also create constraints and indexes, in a given scenario.
  • Recognise ways for manipulating data with SQL commands and for administering PL/SQL objects.
  • Recognise the steps for triggering events, and for monitoring and resolving locking conflicts.
• Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
• Recognise the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.
• Recognise the requirements and best practices for implementing database security according to international and regional laws.
• Recognise the steps for enabling, specifying, maintaining, and reviewing database auditing.
• Recognise the process for obtaining and applying Critical Patch Updates (CPUs).
• Configure an Oracle Database 11g database to support retention and implement database security in a given scenario.
• Recognise the steps for managing and gathering optimiser statistics.
• Identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilising advisors.
• Identify the steps for viewing and configuring automated tasks and setting alert thresholds.
• Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
  • Identify the steps for monitoring and analysing performance, managing memory, and troubleshooting invalid objects that affect performance.
  • Recognise ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g.
  • Recognise the process used to configure an Oracle Database 11g database for instance recovery.
  • Recognise the features of different backup strategies you can employ in Oracle Database 11g.
  • Recognise the steps for using RMAN to configure, schedule, manage, and view backup operations.
  • Resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario.
• Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
  • Recognise the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of database files.
  • Recognise the features of the various options for moving data in Oracle Database 11g.
  • Recognise the steps for importing, exporting, and moving data between Oracle databases using Oracle Data Pump.
  • Recover the database from a media failure and move data using the Data Pump Wizard in a given scenario.
  • Recognise the steps for using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems.
  • Recognise the steps for searching MetaLink for new critical patches and for logging service requests.
  • Recognise ways for managing and applying patches in Oracle Database 11g.

^top

Additional Information for Stage 8:

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

• Oracle Database 11g: Database Architecture and ASM
  • Identify the characteristics of elements of the Oracle Database 11g architecture.
• Recognise the steps for managing database files using Automatic Storage Management (ASM) and disk groups.
• Identify ways to manage disk groups and their attributes and also configure and manage ASM instances.
• Recognise the steps for managing ASM storage, scalability, and performance using the ALTER command and also the ASMCMD utility.
• Create an ASM instance and disk group and use the ASMCMD to view disk group data.
• Oracle Database 11g: Configuring for Recovery
  • Identify the benefits of Oracle Database 11g's backup and recovery functionality.
  • Recognise the steps for configuring a database for backup.
  • Recognise the steps for configuring the Flash Recovery Area.
  • Recognise the steps for creating an RMAN recovery catalog and using it to store database backups.
  • Identify the steps for resynchronizing a recovery catalog, using RMAN stored scripts, and backing up a recovery catalog.
  • Create and configure a recovery catalog and register a database in the recovery catalog in a given scenario.
• Oracle Database 11g: Configuring for Backups
• Recognise the steps for preparing and optimising a database for a backup.
• Recognise the steps for creating fast incremental backup and duplex backup sets using RMAN.
• Recognise the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.
• Recognise the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.
• Identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.
• Recognise the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.
• Recognise the steps for performing different types of user-managed recoveries.
• Back up a database and recover a lost online redo log file in a given scenario.
• Oracle Database 11g: Using RMAN for Recovery
  • Identify the steps for performing a complete recovery using RMAN.
  • Recognise the steps for using RMAN to perform an incomplete recovery, restore a database to a new host, and perform a disaster recovery.
  • Identify the steps for using RMAN to recover a database in a given scenario.
  • Recognise the steps for creating a duplicate database using RMAN and Enterprise Manager.
  • Recognise the steps for performing a tablespace point-in-time recovery (TSPITR).
  • Clone a database and complete a tablespace point-in-time recovery (TSPITR) in a given scenario.
• Oracle Database 11g: Supporting RMAN and Using Flashback Technology
  • Recognise the steps for monitoring RMAN.
  • Recognise the benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing.
  • Identify the steps for performing RMAN tuning operations.
  • Recognise the steps for enabling flashback features and for using the recycle bin in Oracle Database 11g.
  • Recognise the steps for using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction.
  • Use flashback to reverse a transaction in a given scenario.
  • Recognise the steps for recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database.
  • Identify the steps for using guaranteed restore points, for monitoring Flashback Database, and for tracking and archiving data with Flashback Data Archive.
• Oracle Database 11g: Diagnosing the Database and Managing Memory
  • Identify the steps for viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench.
  • Identify the steps for creating a service request (SR) for an incident and packaging and uploading the associated diagnostic data to Oracle Support, and also for monitoring your database's health.
  • Recognise the steps for handling block corruption and for detecting, analyzing, and repairing failures with the help of Data Recovery Advisor.
  • Identify the functions of different memory structures in Oracle Database 11g.
  • Recognise the steps for enabling and monitoring automatic memory management (AMM) and for enabling, configuring, and disabling automatic shared memory management (ASMM).
  • Identify the steps for controlling automatic memory management in the PGA and for sizing the SGA and PGA, and recognise the guidelines for efficient memory usage.
  • Enable automatic memory management and view automatic memory settings in a given scenario.
• Oracle Database 11g: Database Performance and Space Management
  • Identify the tuning steps required to establish the Oracle Database 11g environment.
  • Identify the steps for monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors.
  • Recognise the steps for using the SQL Tuning Advisor and SQL Access Advisors to analyse SQL statements and improve data retrieval.
  • Recognise the general steps required to capture a production workload and replay it in a test environment, using the Database Replay feature.
  • Identify a high load SQL statement and then tune it using the SQL Tuning Advisor.
  • Recognise the steps for generally managing and monitoring space in Oracle Database 11g.
  • Recognise the steps for shrinking segments and reclaiming available space using the Segment Advisor and resumable statements.
  • Identify the steps for moving large volumes of data between two Oracle Database 11g databases, using transportable tablespaces.
• Oracle Database 11g: Managing Resources and Task Automation
  • Identify the steps for accessing and creating resource plans and consumer groups using the Database Resource Manager.
  • Identify the steps for planning and monitoring resource allocation to consumer groups, using resource plan directives.
  • Use the Database Resource Manager to address system resource utilisation and control in a given scenario.
  • Recognise the steps for using the Scheduler to create, schedule and monitor regular and lightweight jobs.
  • Distinguish between time-based and event-based schedules for executing jobs and job chains using the Scheduler.
  • Recognise the steps for performing advanced Scheduler administration to manage job windows, prioritise jobs, and make the best use of resources.
• Oracle Database 11g: Globalization
  • Identify the steps for selecting the database character set that meets your needs and for specifying language-dependent behavior.
  • Recognise the steps for performing and customising linguistic searches and sorts.
  • Identify the steps for performing multiple character set conversions, and for scanning an unknown file set to determine its language.
  • Modify language, date, and time formats for a session and perform a linguistic sort in a given scenario.

^top

<< back to previous page