Get in touch

contact_icon_white

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

1

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
2

Great earnings

Earn an average salary of £50,000 and enjoy the opportunities meeting demand as an Oracle professional provides
3

Stand out from the crowd

63% of recruiters believe a certified professional is more productive in the workplace

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Database Developer
A$85k
Average Salary
You can earn
A$105k
Average Salary
DBA
A$125k
High
Source: Adzuna

A$105k

You can earn an average of A$105,000.00 a year

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

COURSE OVERVIEW

Deliver real time enterprise by becoming an Oracle Database expert.

Your quick course guide

Study time: Contact our career consultants to find out more

Vendor: Oracle

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

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 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

Why learn with us?

We're tech career experts
50,000+ students worldwide
Alternative to traditional university education
Start a new career or advance your current one & land your dream job
Most in-demand skills for today's job market
Award winning StudentCareTM
Partnered with biggest accreditors in the world
Exclusive student benefits; CV detox, NUS, industry events & loads more

Our training is trusted by

Accredited by and partnered with