trainocate-oracle-training-b
Home > Vendors > oracle > d94327

D94327 - Oracle Database 12c: OCM Exam Preparation Workshop

Overview

Duration: 5.0 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

Audience

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

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

Prerequisites

None

Certification

This course is not associated with any Certification.

Schedule




Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy