trainocate-oracle-training-b
Home > Vendors > Oracle > D94327

D94327 - Oracle Database 12c: OCM Exam Preparation Workshop

Overview

Duration: 5 days
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

Objectives

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

Content

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

Audience

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

Prerequisites

N/A

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: