Corresponding certificate
Oracle Certified Expert-OCP (Oracle certified Professional)
Certification Prerequisites
For OCP certification, OCA, OCP certification training and exams are required through the Oracle Licensing Training Test Center. OCA is a primer for Oracle certification system, proving that you have mastered the basic knowledge of the database, you can maintain Oracle daily, create users, assign permissions, manage data files, manage control files, manage log files, and commonly used backup and recovery methods. OCP is an intermediate certification of Oracle Certification system, proving that you have mastered the database recovery technology and mastered the basic tuning method.
Suitable for people
Those who wish to work with Oracle database in the future;
Anyone who has used any kind of database;
after obtaining the OCP certification, will have the opportunity to apply for higher position, obtain OCM certificate;
to enter foreign companies, banks, software companies, state-owned enterprises engaged in IT information technology job seekers.
Employment Direction
database Administrator (DBA), ERP operations engineer, server storage engineer, Oracle technical consultant, database development engineer, etc.
Course Introduction
known as Oracle Certified Database expert, the OCP is Oracle Database DBA Certification course, the OCP is the key to all Oracle product lines, Oracle also has more high-end products such as ERP, middleware, etc. You can learn from the OCP and get acquainted. A OCP certified engineer can not only be a DBA, but also learn to become the most highly paid IT specialist for ERP implementation, middleware management, BI (business Intelligence), and more.
Course Outline
Oracle Database 11g:sql Foundation I
retrieving data using the SQL SELECT statement
restricting and sorting data
customizing output with a single-line function
using conversion functions and conditional expressions
report summary data using group functions
to display data from multiple tables
use subqueries to parse queries
using the SET operator
working with Data
Creating and Managing tables using DDL statements
creating additional schema Objects
Manage Scenario Objects
Searching for data using advanced subqueries
Oracle Database 11g: Management course Exercise I
Oracle Database Architecture
Installing Oracle Software
Create an Oracle database
managing Oracle DB Instances
managing ASM Instances
Configuring the Oracle network Environment
managing the database storage structure
Managing user Security
managing the concurrency of data
Manage undo Data
Implementing Oracle Database Audits
Database Maintenance
Performance Management
Concepts of backup and recovery
perform a database backup
Perform database recovery
Moving Data
Oracle Database 11g: Management course Exercise II
core concepts and tools in Oracle database
Configure Recovery
recovering catalogs using Rman
Configure backup Settings
backups created with Rman
Restore and restore tasks
using Rman to perform recovery
Monitor and adjust Rman
Diagnostic Database
using flashback technology I
using Flashback Technology II
Memory Management
Database Performance Management
managing the performance of SQL tuning
Manage Resources
Scheduling Automation Tasks
Block Management space
Segment Management Space
Database Management Space
Multiplexing Database
Class Introduction
72 hours, 1.5 free of hearing in the application
Exam Code
IZ-047
IZ-052
IZ-053
Test Location
Teng ke Pearson VUE International Electronic Examination Center;
details can be consulted 885 2225 or log in to Teng Ke's website http://sh.togogo.net/
Test Time
IZ-047: Time 120 minutes, 70 choice questions
IZ-052: Time 90 minutes, 70 choice questions
IZ-053: Time 105 minutes, 78 choice questions
Test Score
IZ-047: Qualified results 66%
IZ-052: Qualified results 66%
IZ-053: Qualified results 66%
Teng ke Training advantages
National First: Oracle's first Red Hat Authorized Training test Center
The country's largest: Oracle OCP, Oracle OCM training base
largest in the country: over 1800 Oracle trainees
highest in the country: Oracle exam pass rate up to 91.7%
National only: With South China University of Science and Technology OCM Master's degree in engineering
Oracle OCP Oracle Certified Professional IT education set