OCP with Oracle University

If you're looking for proficiency in Oracle database architecture, installation, administration and troubleshooting with an extra emphasis on multitenant architecture then the OCP with Oracle University is for you

COURSE OVERVIEW

Deliver real time enterprise by becoming an Oracle Database expert.

OverviewWhat you'll learnWhat's included

Your quick course guide

Certifications: Oracle Database SQL Expert, Oracle Database 11g release 2: Administration Workshop I, Oracle Database 11g: Administration Workshop I + Oracle Database 12c: Managing Multitenant Architecture TOD

Study time: Contact our career consultants to find out more

Vendor: Oracle

Provider: Skillsoft + Oracle University

Student support: StudentCare™ and expert mentors

Prerequisites: To get your OCP you need to complete this pathway, including the Oracle University Training On Demand

Assessment: Exam based – 1Z0-047, 1Z0-052, 1Z0-053 + Oracle Database 12c: Managing Multitenant Architecture TOD

Resources: Internet access and email

Ideal for: Our students who have completed our OCP Database pathway and want to achieve their OCP certificate + database administrator, database designer, support engineer, technical administrator or data warehouse administrator

Get in touch

Included in your modules

Using SQL to query your database

Conversion functions, group functions and joins

Sub queries, set operators and data manipulation

Using Ddl, views, sequences, indexes and synonyms

Controlling user access and managing schema objects

Managing data in different time zones

Using sub queries and regular expressions

Database architecture and installation

Database creation and instance management

Asm instance and network connectivity

Storage structures and user security

Managing concurrency, undo and auditing

Managing database maintenance and performance

Backup and recovery

Moving data

Oracle support

Database architecture and ASM

Configuring for recovery

Configuring for backups

Using Rman for recovery

Supporting Rman and using flashback technology

Diagnosing the database and managing memory

Database performance and space management

Managing resources and task automation

Globalisation

Manage the multitenant container database and pluggable databases performance

Configure resource manager to share resources within a multitenant container database between containers and within a pluggable database

Implement unified auditing in a multitenant container database and its pluggable databases

Use Oracle Data Pump, SQL*Loader in pluggable databases

Monitor the multitenant container database and pluggable databases

Describe the multitenant architecture

Create a multitenant container database

Create a pluggable database using different methods

Plug a non CDB into a multitenant container database

Manage multitenant container databases and pluggable databases

Administer multitenant container database and pluggable database storage structures

Create and administer common and local user accounts

Manage common and local privileges and roles

Configure multitenant container databases and pluggable databases backup and recovery operations

Get in touch

Get certified the Learning People way

Professional development that works around you

World's #1 eLearning portal

Global community of peers

Expert mentors by email

Six consecutive days of Practice Labs

Interactive exercises

Training mapped to Oracle exam curriculum

Award winning training used globally by leading corporate clients

Get in touch

Salary Indicator

Salary Projection

Average salary after completing

Average Salary

Junior Database Engineer

£22k

Average Salary

You can earn

£73k

Average Salary

Database Programmer

£125k

High

Source: Adzuna

£73k

You can earn an average of £73,400.00 a year

Become a student

There are an estimated 100,000 plus jobs waiting to be filled in the tech sector, and almost half a million more to come in the next few years

Become an in demand professional

Get in touch

Enhance your skillset

Learn to plug and unplug databases in multitenant container databases, whilst also learning to ceate common and local users in order to meet data security business requirements