Oracle Database 12c: OCM Exam Preparation Workshop (D94327)

Oracle Database 12c: OCM Exam Preparation Workshop (D94327)


The Oracle Database 12c: OCM Exam Preparation Workshop is designed for those candidates who are preparing to take the Oracle Database 12c: Oracle Certified Master (OCM) Exam. This workshop has extensive hands-on practices to enable students to:

  • Create a Multitenant Container Database and Pluggable Databases
  • Perform Backup,Recovery and Flashback of CDB and PDBs
  • Load and unload data
  • Implement partitioning
  • Configure Dataguard
  • Configure clusterware
  • Install RAC


Upon completing this course, the learner will be able to meet these overall objectives:
  • Describe the multitenant architecture
  • Establish connections to CDB / PDB
  • Implement fine-grained auditing (FGA)
  • Describe operations that can be parallelized
  • Describe ways to move data
  • Describe the architecture, uses, and advantages of partitioning
  • Describe how to optimize a star query using star transformation
  • Use the SQL Access Advisor
  • Explain the goals, benefits, and architecture of the inmemory column store
  • Explain the differences between physical and logical standby databases
  • Use real-time query to access data on a physical standby database
  • Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
  • Explain the principles and purposes of clusters
  • Explain and apply Automatic Storage Management (ASM) initialization parameters
  • Describe the benefits of Oracle RAC
  • Modify initialization parameters in a RAC environment
Module 1: Basics of Multitenant Container Database and Pluggable Databases

Module 2: Managing Tablespaces and Users in CDB and PDBs

Module 3: Basics of Parallel Execution

Module 4: In-Memory Parallel Execution & Multi-Threaded architecture

Module 5: Moving Data

Module 6: Working with Indexes

Module 7: Partitioning Concepts

Module 8: Dataware House Tuning and Partitioning Workloads

Module 9: Using Flashback Technologies

Module 10: Influencing the Optimizer

Module 11: SQL Performance Management and SQL Data Compression

Module 12: In-Memory Column Store

Module 13: Introduction to Oracle Data Guard

Module 14: Using Oracle Active Data Guard

Module 15: Using Oracle Active Data Guard

Module 16: Creating a Logical Standby Database

Module 17: Enabling Fast-Start Failover

Module 18: Introduction to Clusterware

Module 19: ASM Overview

Module 20: Flex Clusters

Module 21: Flex ASM

Module 22: RAC Databases Overview and Architecture

Module 23: Upgrading and Patching Oracle RAC


No prerequisite

Course ID:

Show Schedule for: