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
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
- Database Administrators
- Data Center Manager
- Database Designers
- Technical Consultant
- Data Warehouse Developer
- Technical Administrator
- Systems Architects
- Data Warehouse Administrator
- 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
This course is not associated with any Certification.