Quick enquiry


Select all that apply (optional):

Is this a business enquiry?


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


Deliver real time enterprise by becoming an Oracle Database expert.

OverviewWhat you'll learnWhat's included

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

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Junior Database Engineer
Average Salary
You can earn
Average Salary
Database Programmer
Source: Adzuna


You can earn an average of £73,400.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

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

Great earnings

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

Stand out from the crowd

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

Why learn with us?

We're tech career experts
Exclusive student benefits; Career Services, TOTUM, industry events and lots more
Award winning StudentCare™
25,000+ students worldwide
Partnered with biggest accreditors in the world
Alternative to traditional university education
Start a new career or advance your current one & land your dream job
Join our online Alumni community and connect with like-minded professionals

Our training is trusted by

Accredited by and partnered with

Celebratingten yearsCelebratingten yearsCelebrating
ten years

Learning People (IRE) Ltd, 8-9
Westmoreland St, Dublin 2.

Learning People, The Agora, Ellen Street, Brighton,
BN3 3LN.

Learning People, Tower 2, 11-24, 101 Grafton St, Bondi Junction, Sydney, NSW, 2022.

New Zealand
Learning People, Level 3, 151 Cambridge Terrace, Christchurch Central, 8013.

© The Learning People 2021FAQTerms & ConditionsPrivacy PolicyTerms of website use
The Learning People Ltd is authorised and regulated by the Financial Conduct Authority, register number 689955, and act as a credit broker and not a lender.Finance is provided through the Deko platform by Omni Capital Retail Finance Limited.Omni Capital Retail Finance Limited is authorised and regulated by the Financial Conduct Authority (register number 720279). Learning People company number: 07182042