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

 

Course Overview

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

Who should attend

  • Database Administrators
  • Data Center Manager
  • Database Designers
  • Technical Consultant
  • Data Warehouse Developer
  • Technical Administrator
  • Systems Architects
  • Data Warehouse Administrator

Course 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

Course Content

  • Basics of Multitenant Container Database and Pluggable Databases
  • Managing Tablespaces and Users in CDB and PDBs
  • Basics of Parallel Execution
  • In-Memory Parallel Execution & Multi-Threaded architecture
  • Moving Data
  • Working with Indexes
  • Partitioning Concepts
  • Dataware House Tuning and Partitioning Workloads
  • Using Flashback Technologies
  • Influencing the Optimizer
  • SQL Performance Management and SQL Data Compression
  • In-Memory Column Store
  • Introduction to Oracle Data Guard
  • Using Oracle Active Data Guard
  • Creating a Logical Standby Database
  • Enabling Fast-Start Failover
  • Introduction to Clusterware
  • ASM Overview
  • Flex Clusters
  • Flex ASM
  • RAC Databases Overview and Architecture
  • Upgrading and Patching Oracle RAC

Prices & Delivery methods

Online Training

Duration
5 days

Price
  • on request
Classroom Training

Duration
5 days

Price
  • on request

Currently there are no training dates scheduled for this course.