Get in touch

01273 907 9190800 0141 311

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

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

Related

Course

OCP Database 11g Administrator

Read more
Course

Big data collection

Read more

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
Why learn with us

Our training is trusted by

Accredited by and partnered with

Project management coursesPMIPRINCE2®Six SigmaITIL®IIBAPMI ITAPMGUX and Digital Marketing coursesDigital Marketing Institute
Coding coursesCode InstituteMicrosoftCyber security coursesCompTIA(ISC)2EC-CouncilCiscoISACA
IT coursesIT collectionsAmazon – AWSMicrosoftCiscoCompTIAOracleOracle University(ISC)2EC-CouncilISTQBISACAIT academyCode InstituteJuniper NetworksRed HatSAS InstituteIIB
Connect
Information

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

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

Australia
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 2019FAQTerms & ConditionsPrivacy PolicyTerms of website use
The Learning People Ltd is authorised and regulated by the Financial Conduct Authority.FCA number: 689955Company number: 07182042