D94327 - Oracle Database 12c: OCM Exam Preparation Workshop

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

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

None

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d83527

D83527 - Java SE 8 Fundamentals

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop
Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy