Oracle OCP Oracle Certified Professional IT education set

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