OCP with Oracle University

COURSE OVERVIEW

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

    Hold a database certification enabling competitive business operations and analytics, ensuring your business has a competitive advantage.

Your quick course guide

Certifications included: Oracle Database SQL ExpertOracle Database 11g release 2: Administration Workshop IOracle Database 11g: Administration Workshop I + Oracle Database 12c: Managing Multitenant Architecture TOD

Study time: Refer to a learning consultant

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

Included in your modules

1Z0-047 Oracle Database SQL Expert

  • 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

1Z0-052 Oracle Database 11g release 2: Administration Workshop I

  • 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

1Z0-053 Oracle Database 11g: Administration Workshop I

  • 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

Oracle Database 12c: Managing Multitenant Architecture TOD

  • 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

Average salary

2015 JAN
  JUL
2016 JAN
  JUL
2017 JAN
  JUL
Read more

Why join us?

  • Award winning customer support
  • We know the job market inside out
  • Trusted by the giants
  • Value for money
  • CV detox - exclusive to our students
  • We're with you from start to finish
  • Expert career advice
  • Progress reports
  • Exam booking support
  • All UK students receive an NUS student discount card
  • Your success is our success

CV detox

It's not just about your CV...