Oracle OCP 11g Certification

Level
Total time

Oracle OCP 11g Certification

London College
Logo London College

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Class room based practical training with free books included and unlimited number of practice hours and mock exams even after you have finished your course.

Oracle OCP 11g Certification

It is an undisputed fact that Oracle is one of the leading database management systems on offer out there. Through the Oracle 11g OCP course that we offer, you can be rest assured of success in your career in the fields of database administration and development. This highly advanced training program delves deep into every facet of the system in a way that other courses can't match up to; thus, giving you the advantage to stay ahead of the curve. In addition to the strategic curriculum, our instructors bring to the table the proficiency and commitment that we believe every student deserves. To put it simply, when it comes to OCP courses, this is the place to be!

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, Database Management, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

Class room based practical training with free books included and unlimited number of practice hours and mock exams even after you have finished your course.

Oracle OCP 11g Certification

It is an undisputed fact that Oracle is one of the leading database management systems on offer out there. Through the Oracle 11g OCP course that we offer, you can be rest assured of success in your career in the fields of database administration and development. This highly advanced training program delves deep into every facet of the system in a way that other courses can't match up to; thus, giving you the advantage to stay ahead of the curve. In addition to the strategic curriculum, our instructors bring to the table the proficiency and commitment that we believe every student deserves. To put it simply, when it comes to OCP courses, this is the place to be!

Oracle OCP Certification Course Content

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

Introduction to Oracle 11g Database Architecture
Describe course objectives 
Explore the Oracle 11g database architecture

SQL Select Statements 
SELECT statement
List the capabilities of SQL SELECT statements 
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
Use ampersand substitution to restrict and sort output at runtime

Single-Row Functions to Customize Output 
Functions available in SQL 
Use character, number, conversion functions, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions 
Various types of conversion functions that are available in SQL 
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions 
Apply conditional expressions in a SELECT statement

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
Generate a Cartesian product of all rows from two or more tables

Aggregating Data using Group Functions 
Group functions 
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

Set Operators 
Describe set operators 
Use a set operator to combine multiple queries into a single query 
Control the order of rows returned

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, Delete, Merge rows in a table
Control transactions

Creating and Managing Tables 
Database objects, Create tables 
Datatypes that can be used when specifying column definition 
Alter table definitions 
Drop, rename and truncate tables

Constraints 
Introduction to constraints 
Create and maintain constraints

Creating Views 
Introduction to view 
Create, alter the definition, and drop a view 
Retrieve data through a view 
Insert, update and delete data through a view

Creating Other Schema Objects 
Create simple and complex views, Retrieve data from views 
Create, maintain, and use sequences 
Create and maintain indexes 
Create private and public synonyms

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


Oracle Database Architecture 
Memory Structures 
Process Structures 
Storage Structures

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

Oracle Database
Create, Configure and Manage Oracle Database
Database Configuration Assistant (DBCA)

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

Oracle Network Environment 
Manage, Configure 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, Maintain and manage database user accounts 
Grant and revoke privileges 
Create and manage roles and profiles 
Managing Schema Objects 
Create and Modify tables 
Manage Constraints 
Create indexes 
Create and use temporary tables

Data and Concurrency 
Maintain and 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

Securing Oracle Database and Audit
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

Database 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 Oracle 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 Method
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

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

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 Setup
Customize language-dependent behavior for the database and individual sessions 
Working with database and NLS character sets

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.