Oracle - Course Details

OraD11gCME(OCM)N Oracle Database 11g Certified Master Exam (OCM) NEW

Oracle Course Description:
The Oracle Database 11g Certified Master Exam (OCM) credential is the industry's most advanced Database Administrator certification. This exam is based on Oracle Database 11g Release 2 (32-bit) and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system is Oracle Enterprise Linux Release 5.4 (32-bit).
Oracle Course Duration:
Oracle Course Target Audience:
Database Administrators,Support Engineer,Technical Consultant
Oracle Course Prerequisite:
Complete 2 of the Advanced or Specialty courses to meet the Hands On Course Requirements,Advanced knowledge and use of Oracle Enterprise Server techn,Every candidate must have their 9-character Oracle Testing ID to initiate the OCM exam,Familiarity navigating through online Oracle documentation,Candidates should have a minimum of 3 – 4 years of Oracle database administrator experience,Proficient with using Mozilla browser software,Complete PRIOR CERTIFICATION -Oracle Database 11g Administrator Certified Professional (OCP),Proficient with SQL
Course Content:
  • Server Configuration

    • Create the database, Determine and set sizing parameters for database structures, Create and manage temporary, permanent, and undo tablespaces
    • Stripe data files across multiple physical devices and locations, Configure the database environment to support optimal data access performance, Create and manage database configuration files
    • Create and manage bigfile tablespaces, Create and Manage a tablespace that uses NFS mounted file system file
    • Create and manage multiple network configuration files, Create and configure a listener, Configure the database instance to support shared server connections
    • Set up network tracing, Manage Oracle network processes
    • Configure the network environment to allow connections to multiple databases
    • Use configurationless connections
    • Use Grid Infrastructure to manage oracle databases and other resources

  • Enterprise Manager Grid Control

    • Install and Patch Enterprise Manager Grid Control software, Configure the Enterprise Manager repository, Create Enterprise Manager Grid Control users
    • Use Enterprise Manager to modify a database configuration, Configure Enterprise Manager to modify a database availability
    • Create and manage jobs, Create and monitor alerts, Create notifications, Implement Grid Control and Database Control
    • Choose the appropriate tablespace type for the intended use
    • Create Scheduler jobs, Create schedules, Assign jobs to windows, Create programs, Create job classes
    • Install the Enterprise Manager Grid Control infrastructure
    • Deploy Enterprise Manager Grid Control agents
    • Configure Grid Control for business requirements

  • Managing Database Availability

    • Mantain recovery catalogs, Configure Recovery Manager
    • Use Recovery Manager to perform database backups
    • Use Recover Manager to perform complete database restore and recovery operations
    • Configure RMAN
    • Create different types of RMAN backups to cater for different performance and retention requirements
    • Set Flashback Database parameters
    • Configure a Fast Recovery Area
    • Perform various recovery operations using Flashback technology

  • Data Management

    • Manage Materialized Views to improve rewrite and refresh performance
    • Configure and manage distributed materialized views
    • Create and Manage encrypted tablespaces, Manage Transport of tablespaces across platforms
    • Configure a schema to support a star transformation query, Administer external tables
    • Implement Data Pump export and import jobs for data transfer, Implement Data Pump to and from remote databases
    • Configure and use parallel execution for queries
    • Use SQL*Loader
    • Administer, manage and tune parallel execution

  • Data Warehouse Management

    • Administer partitioned tables and indexes using appropriate methods and keys
    • Perform partition maintenance operations
    • Maintain indexes on a partitioned table
    • Implement securefile LOB
    • Create and manage LOB segments
    • Implement fine-grained access control
    • Create and manage contexts
    • Administer flashback data archive and schema evolution

  • Performance Management

    • Administer Resource Manager, Use Result Cache, Use multi column statistics
    • Gather statistics on a specific table without invalidating cursors
    • Use partitioned indexes
    • Administer and tune schema object to support various access methods
    • Interpret execution plan, Use SQL tuning tools and features
    • Use SQL Tuning Advisor, Use SQL Access Advisor
    • Use SQL Performance Analyzer, Configure baseline templates
    • Use SQL Plan Management feature, Implement instance caging

  • Grid Infrastructure and ASM

    • Install Oracle Grid Infrastructure
    • Create ASM Disk Groups
    • Create and manage as ASM instance
    • Implement ASM failure groups
    • Creating ACFS File System
    • Start,Stop, Configure and Administer Oracle Grid Infrastructure

  • Real Application Clusters

    • Install the Oracle Database 11gR2 software
    • Configure ASM for the shared disks and create a clustered database
    • Configure archiving
    • Configure Services using both Manual and Policy Managed Methods

  • Data Guard

    • Create Physical Standby Database with real-time apply
    • Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
    • Configure the Observer
    • Switchover and switch back
    • Configure connect time failover
    • Convert the standby to a snapshot standby
    • Configure archivelog deletion policy for the dataguard configuration