> > > D94327

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

Course Description Schedule Course Outline
 

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
Classroom Training
Modality: G

Duration 5 days

Price (excl. tax)
  • Germany: 3,350.- €
  • Switzerland: Fr. 4,140.-
Dates and Booking
Online Training
Modality: U

Duration 5 days

Price (excl. tax)
  • Germany: 3,155.- €
Dates and Booking
 
Click on town name to book Schedule
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
Germany
17/12/2018 - 21/12/2018 Online Training Time zone: Europe/Berlin Course language: English
11/02/2019 - 15/02/2019 Online Training Time zone: Europe/Berlin Course language: English
15/04/2019 - 19/04/2019 Online Training Time zone: Europe/Berlin Course language: English
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!