Oracle database 12C : OCM Exam preparation Workshop Ed 1 Course Overview

The Oracle Database 12c: OCM Exam Preparation Workshop training course is intended for those people who are getting ready to take the Oracle Database 12c: Oracle Certified Master (OCM) Exam. This workshop has broad 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 do this course?

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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Basics of Multitenant Container Database and Pluggable Databases
  • New Multitenant Architecture: Benefits
  • Multitenant Container Database
  • Separating SYSTEM and User Data
  • Provisioning a Pluggable Database
  • Interacting Within Multitenant Container Database
  • Multitenant Container Database Architecture
  • Common and Local Users
  • Common and Local Privileges and Roles
  • Tablespaces in PDBs
  • Creating Permanent Tablespaces in a CDB
  • Creating Local Temporary Tablespaces
  • Tablespace Encryption: Advantages
  • Creating an Encrypted Tablespac
  • Common and Local Schemas/Users
  • Granting and Revoking Privileges
  • Granting Common or Local Privileges/Roles to Roles
  • Parallelizable Operations
  • Previewing Execution Plans
  • Understanding Parallel Execution: Query Coordinator (QC) and Parallel (PX) Servers
  • Parallel Execution Plans: Identifying the Producers and Consumers
  • Parallel Execution Plans: Understanding Granules
  • Example PX Parameters
  • PX Parameters for Auto DOP
  • Parameters for PX Messaging: Shared and Large Pools
  • Direct Reads Versus Buffer Cache Reads
  • Parallel Execution and the Buffer Cache
  • In-Memory Parallel Execution
  • When In-Memory Parallel Execution Works
  • Controlling In-Memory Parallel Execution
  • Enhance In-Memory PX Using Server Pools
  • Enhance In-Memory PX: Automatic Big Table Caching
  • Using PARALLEL_FORCE_LOCAL Parameter
  • Oracle Data Pump: Overview
  • Directory Objects for Data Pump
  • Data Pump Export and Import Clients: Overview
  • External Tables
  • Data Pump Import: Transformations
  • SQL*Loader: Overview
  • Loading Methods
  • Transportable Tablespaces
  • Normal B*-tree Indexes
  • Index Scans
  • Index Range Scan
  • Index Range Scan: Function-Based
  • Index Fast Full Scan
  • B*-tree Indexes and Nulls
  • Index-Organized Tables
  • Bitmap Indexes
  • Partitioned Tables and Indexes
  • Partitioning Strategies: Single-Level Partitioning
  • Oracle Partitioning History
  • Partition Key Extensions
  • Benefits of Partitioning: Table Availability
  • Manageability: Relocate Table Data
  • Benefits of Partitioning: Performance Considerations
  • Verifying Partition Use
  • Characteristics of a Data Warehouse
  • OLTP Systems Versus Data Warehouses
  • Data Warehouse Architectures: Basic Data Warehouse with Staging Area
  • Data Warehousing Objects
  • Optimizing Star Queries: Star Transformation
  • Execution Plan Without Star Transformation
  • Star Transformation Considerations
  • Retrieving Fact Rows from All Dimensions: Phase 1
  • Flashback Technologies Error Detection and Correction
  • Flashback Technology
  • Guaranteeing Undo Retention
  • Flashback Query
  • Flashback Table: Overview
  • Flashback Table: Considerations
  • Flashback Transaction Query
  • Flashing Back a Transaction
  • Functions of the Query Optimizer
  • Cardinality and Cost
  • Changing Optimizer Behavior
  • Optimizer Statistics
  • Optimizer Parameters
  • Enabling Query Optimizer Features
  • Dynamic Plans
  • Cardinality Feedback: Monitoring Query Executions
  • Maintaining SQL Performance
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Setting Statistic Preferences
  • Restoring Statistics
  • Deferred Statistics Publishing: Example
  • Automatic SQL Tuning: Overview
  • Plan Tuning Flow and SQL Profile Creation
  • Goals of In-Memory Column Store
  • Store Versus Column Store: 2D Vision
  • In-Memory Column Unit
  • Dual Format In Memory
  • Deploying IM Column Store
  • Objects Candidates for IM Column Store
  • Defining IM Column Store Priority
  • Default In-Memory Setting
  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Role Transitions: Switchover and Failover
  • Choosing an Interface for Administering a Data Guard Configuration
  • Primary Database Processes
  • Standby Database Processes
  • Physical Standby Database: Redo Apply Architecture
  • Automatic Gap Detection and Resolution
  • Using Real-Time Query
  • Disabling Real-Time Query
  • Checking the Standby’s Open Mode
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Allowed Staleness of Standby Query Data
  • Setting STANDBY_MAX_DATA_DELAY by Using an AFTER LOGON Trigger
  • Forcing Redo Apply Synchronization
  • Creating an AFTER LOGON Trigger for Synchronization
  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • Preparing to Create a Logical Standby Database
  • Unsupported Data Types
  • Checking for Tables with Unsupported Data Types
  • Unsupported PL/SQL-Supplied Packages
  • Adding a Disabled Primary Key RELY Constraint
  • Creating a Logical Standby Database by Using SQL Commands
  • When Does Fast-Start Failover Occur?
  • Installing the Observer Software
  • Fast-Start Failover Prerequisites
  • Configuring Fast-Start Failover
  • Step 1: Specify the Target Standby Database
  • Setting the Lag-Time Limit
  • Configuring the Primary Database to Shut Down Automatically
  • Configuring Automatic Reinstatement of the Primary Database
  • Clusterware Architecture and Cluster Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Fencing
  • Cluster Time Synchronization
  • Oracle Clusterware Networking
  • Grid Naming Service (GNS)
  • Grid Naming Service Configuration Options
  • Single-Client Access Name
  • What Is Oracle ASM?
  • ASM Features and Benefits
  • ASM Instance Designs: Clustered ASM for Clustered Databases
  • ASM Components: Software
  • ASM Components: ASM Instance Primary Processes
  • ASM Components: Configuration Files
  • ASM Disk Group: Failure Groups
  • ASM Files: Extents and Striping
  • Flex Clusters: Overview
  • Flex Cluster Scalability
  • Leaf Node Characteristics
  • Cluster Mode: Overview
  • Configuring the Cluster Mode
  • Configuring Miss Count for Leaf Nodes
  • Configuring a Flex Cluster with OUI: Configuring GNS
  • Configuring a Flex Cluster with OUI: Selecting the Node Type
  • Flex ASM: Overview
  • ASM Instance Changes
  • Configuring Flex ASM on a Standard Cluster
  • Configuring Flex ASM on a Flex Cluster
  • Stopping, Starting, and Relocating Flex ASM Instances
  • Setting the Cardinality for Flex ASM Instances
  • Monitoring Flex ASM Connections
  • Relocating an ASM Client
  • Typical Oracle RAC Architecture
  • Oracle RAC One Node
  • Cluster-Aware Storage Solutions
  • Oracle RAC and Network Connectivity
  • Clusters and Scalability
  • Levels of Scalability
  • Speedup/Scaleup and Workloads
  • Necessity of Global Resources
  • Patch and Patch Set: Overview
  • Configuring the Software Library
  • Reduced Down-Time Patching for Cluster Environments
  • Out-of-Place Database Upgrades
  • OPatch: Overview
  • Before Patching with OPatch
  • OPatch Automation: Examples
  • OPatch Log and Trace Files
Live Online Training (Duration : 40 Hours) Fee On Request
Group Training Incl. Official Courseware
20 - 24 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours

Course Prerequisites
  • Basic Computer Knowledge.

On Completion of this course you will be able to:-

  • 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

Request More Information

Add Name and Email Address of participant (If different from you)