COURSE DESCRIPTION
Oracle Database 12c – Oracle Certified Master (OCM) Exam
The Oracle Database 12c Certified Master Exam (OCM) credential is the industry’s most advanced Database Administrator certification. This exam is based on Oracle Database 12c Release 1 (12.1.0.2.0 – 64-bit) and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system is Oracle Linux Server Release 6.5 (64-bit). Oracle Certified Master Credential Requirements Obtaining the Oracle Certified Master credential requires passing an onsite practical exam. You will be tested on your ability to perform database administration tasks in a live database environment. Skill sets are timed and require a high degree of Oracle database knowledge to successfully complete them. Pre-Requisites for Registration We highly recommend that you have a minimum of 3 to 4 years of experience as an Oracle Database Administrator. 5 years or more is more typical of qualified candidates. Before Registering for the 12c OCM Exam: Complete PRIOR CERTIFICATION – Oracle Database 12c Administrator Certified Professional (OCP). Complete 2 of the advanced or specialty courses to meet the hands on course requirements. Gain considerable hands-on expertise fulfilling all of the exam objectives. Get comfortable with the basic Linux command language.
Course Content:
General Database and Network Administration
Create and manage pluggable databases
Administer users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Administer database configuration files
Configure shared server
Manage network file directories
Manage Database Availability
Install the EM Cloud Control agent
Configure recovery catalog
Configure RMAN
Perform a full database backup
Configure and monitor Flashback Database
Data Warehouse Management
Manage database links
Manage a fast refreshable materialized view
Create a plug-in tablespace by using the transportable tablespace feature
Optimize star queries
Configure parallel execution
Apply a Patch
Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
Manage external tables
Data Management
Manage additional buffer cache
Optimize space usage for the LOB data
Manage an encrypted tablespace
Manage schema data
Manage partitioned tables
Set up Fine-Grained Auditing
Configure the database to retrieve all previous versions of the table rows
Performance Management
Configure the Resource Manager
Tune SQL statements
Use real application testing
Manage SQL Plan baselines
Capture performance statistics
Tune an instance – Configure and manage result cache, Control CPU use for Oracle Instances, Configure and manage “In Memory” features
Manage extended statistics
Create and manage partitioned indexes
Data Guard
Administer a Data Guard environment
Create a physical standby database
Configure a standby database for testing
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Manage extended statistics
Manage DDL in a Data Guard environment
Grid Infrastructure
Install Oracle Grid Infrastructure
Create ASM Disk Groups
Create and manage ASM instances
Configure ASM Cloud File System (ACFS)
Administer Oracle Clusterware
Manage Flex Clusters and Flex ASM
Manage Flex Clusters and Flex ASM
Real Application Cluster Database
Install Oracle Database software
Create a Real Application Clusters (RAC) database
Configure Database Services
Administer Oracle RAC databases on one or more cluster nodes
Training Track: Database
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
- Join Internships and Referral Program (click for details)
- Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Oracle Courses
Oracle 12c Master Certified Training
Oracle DBA 12c Fundamentals Course
Oracle SQL Database Expert Course
