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