Oracle Database 12c OCA + OCP Certification Course

Training Square London
Course summary
Professional Training
6 Weeks or Fast Track 5 Days
1,850 GBP

Course description

Oracle Database 12c OCA + OCP Certification

From Megabyte to Terabyte, size of the data can grow as more information is stored. Think about a bank as an example who has several millions of customers and processing millions of transaction everyday. Question arises, Is there any database which can store and maintain the millions of information in the real time? Answer is certainly YES, Oracle Database 12c provides the miracle solutions when it comes to storing data in the digital warehouse. Over the decades Oracle Database has become a heart of business and Oracle has been leader in the industry based on the storage, performance, cloud storage, scalability, manageability and integration.

Oracle database 12c provides high capabilities solution to small to larger organizations offering most comprehensive set of capabilities such as Real Application Clusters(RAC), Data Guard, Flashback, Recovery Manager(RMAN), Secure backup and Automatic Storage Management(ASM) which makes it most demanding database platform leader in the industry.

Database is the most critical assets of a business and it needs reliable and robust data platform and has to be secured. If platform is not reliable and robust then businesses may lose millions of pounds as a result of downtime, in this perspective Oracle plays a greater role in the IT industry and it has taken major share in the market which has created resulted in creating jobs opportunities in the database arena.

Learning Oracle 12c Database management and achieving the OCA and OCP certification is a goal to everyone who is pursuing their career in the Oracle DBA track. Training Square is an Oracle authorized Training Center and we deliver a class-room based tutor led hands-on training in a very professional environment by Oracle Certified Trainers. With our Oracle 12c certification training will certainly enable you to achieve your set goals at the completion of the Oracle 12c OCP certification training.

If you are looking for job after the course we can certainly send your CV to prospective employers and the recruitment consultants or even assist you to analyse and update your CV to make it look professional.

Suitability - Who should attend?

This course is suitable for professionals of all skill level - beginner, intermediate and advanced.

Training Course Content

This course covers the following topics:

Oracle OCP Exam #1Z0-071 - Oracle Database 12c SQLIntroduction to Oracle and Structured Query Language (SQL)

  • Restricting and Sorting Data
  • Single-Row Functions to Customize Output
  • Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Managing Schema Objects
  • Manipulating Large Data Sets
  • Oracle OCP Exam #1Z0-062 - Oracle Database 12c Administration(OCA Certification)Exploring the Oracle Database Architecture
  • Oracle Database Management Tools
  • Oracle Database Instance
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Managing Database Storage Structures
  • Create and manage tablespaces
  • Managing Undo Data
  • Managing Data Concurrency
  • Implementing Oracle Database Auditing
  • Backup and Recovery Concepts
  • Backup and Recovery Configuration
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Performing Database Maintenance
  • Managing Performance: SQL Tuning
  • Automating Tasks by Using Oracle Scheduler
  • Creating an Oracle Database Using DBCA
  • Upgrading Oracle Database Software
  • Introduction to DBAAS

Oracle OCP Exam #1Z0-063 - Oracle Database 12c: Advanced Administration(OCP Certification)Oracle Data Protection Solutions

  • Performing Basic Backup and Recovery
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Implementing Backup Strategies
  • Performing Backups
  • Configuring RMAN Backup Options and Creating Backup of Non-Database Files
  • Using RMAN-Encrypted Backups
  • Diagnosing Failures
  • Performing Restore and Recovery Operations
  • Recovering Files Using RMAN
  • Using Oracle Secure Backup
  • Using Flashback Technologies
  • Using Flashback Database
  • Transporting Data
  • Duplicating a Database
  • Monitoring and Tuning of RMAN Operations
  • Managing Pluggable and Container Databases
  • Creating Multitenant Container and Pluggable Databases
  • Managing a CDB and PDBs
  • Managing Storage in a CDB and PDBs
  • Managing Security in a CDB and PDBs
  • Managing Availability
  • Managing Performance
  • Moving Data, Performing Security Operations and Interacting with Other Oracle Products


The cost of this course is £1850 per person. Contact the provider to learn more about costs and payment options.

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Training Square London

Training Square London

The internet indeed has changed the world, and we believe every one of us should be fully equipped to be a part of, and lead, that change. Being prepared and ready is half the battle won, and Training Square makes...

Read more and show all courses with this provider

Contact info

Training Square London

 Show phone number


Average rating 5

Based on 1 reviews.

The course was exactly what i was looking for as I’m aiming to sit the OCA+OCP exams. The trainer was knowledgeable and explained each topic well. I found the staff friendly and helpful, the the learning environment was great.
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here