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

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

N/A

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: