English
网站导航
 
 


课程列表
培训课程介绍
红帽redhat
CISCO思科认证
Aruba认证课程
IPV6课程
CWNP无线认证
H3C认证
Oracle认证
企业实战培训
CIW网络认证

 
  : 咨询热线
 考试咨询  培训咨询  培训咨询

公司地址:深圳市罗湖区

你的位置: Oracle认证

OCM大师级黄金认证课程介绍


Oracle认证   添加时间: 2012-4-12 23:56:44   阅读数: 9069
 

OCM大师级黄金认证课程介绍

 

OCM培养对象:

已经具备至少为OCP技术水平的学员,也就是需要学员熟练使用Oracle数据库,并且具备一定的实际经验。同时,希望进一步提升Oracle以及大型系数据库方面等能力的学员。

1、咨询顾问和应用系统审计专家;

2、企业CTO、系统经理、维护专家;

3、各级政府信息化管理部门的官员;

4、企业内部数据库系统维护专家;

5、有志于从事顶级数据库维护的人士;

6、已通过OCAOCP认证的Oracle技术专家;

 

OCM课程特色:

1.      无可争议的全球最高级别数据库认证。

2.      Oracle数据库的全球市场份额高达57%,而且持续增长

3.      Oracle的客户大多是世界500强,中国政府、电信、网游公司等高端企业,这些企业将是OCM的雇主,薪水绝不会低

4.      全实践考试,得到企业雇主的高度认可

5.      全球总共200名左右的10g OCM

6.      Oracle领域已经持续耕耘4年以上,拥有国内培训企业中最高水准的Oracle讲师团队,并且已经培养出一批OCM认证人员

7.      Oracle WDP最佳培训质量奖 最佳培训合作伙伴的获得者。

 

ORACLE10g OCM大纲 

1. Database Server Configuration 

         1). Create the database 

         2). Determine and set sizing parameters for database structures

         3). Create and manage temporary, permanent, and undo tablespaces 

         4). Stripe data files across multiple physical devices and locations 

         5). Configure the database environment to support optimal data access performance 

         6). Create and manage database configuration files 

         7). Create and manage bigfile tablespaces 

         8). Create and manage multiple network configuration files 

         9). Create and configure a listener 

         10).Configure the database instance to support shared server connections 

         11).Set up network tracing 

         12).Manage Oracle network processes (the Listener Control utility) 

         13).Configure the network environment to allow connections to multiple databases 

         14).Use configurationless connections 

 

2. Oracle Enterprise Manager Grid Control 

 1).Install the Enterprise Manager Grid Control software

 2).Configure the Enterprise Manager repository 

 3).Create Enterprise Manager Grid Control users 

 4).Use Enterprise Manager to modify a database configuration

 5).Configure Enterprise Manager to modify a database availability 

 6).Create and manage jobs 

 7).Create and monitor alerts 

 8).Create notifications 

 9).Implement Grid Control and Database Control 

 10).Choose the appropriate tablespace type for the intended use

 11).Create Scheduler jobs 

 12).Create schedules 

 13).Assign jobs to windows 

 14).Create programs 

 15).Create job classes 

 16).Install the Enterprise Manager Grid Control infrastructure

 17).Deploy Enterprise Manager Grid Control agents 

 18).Configure Grid Control for business requirements 

 

3.Managing Database Availability 

 1).Create a recovery catalog database 

 2).Configure Recovery Manager 

 3).Use Recovery Manager to perform database backups 

 4).Use Recover Manager to perform complete database restore and recovery operations 

 5).Set Flashback Database parameters 

 6).Monitor Flashback Database logs and statistics 

 7).Perform a Flashback Database operation 

 8).Configure a flash recovery area 

 

4.Data Management 

 1).Implement fine-grained auditing 

 2).Create a secure application role 

 3).Grant specific privileges for a Flashback Query 

 4).Set parameters for retaining undo 

 5).Implement fine-grained access control 

 6).Create and manage contexts 

 7).Use SQL*Loader

 8).Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files) 

 9).Choose the appropriate partition method (range, hash, list, and composite) 

 10).Choose the appropriate partition key 

 11).Choose appropriate indexing methods (local, global, prefixed, and nonprefixed) 

 12).Perform partition maintenance operations 

 13).Maintain indexes on a partitioned table 

 14).Create and manage LOB segments 

 15).Apply parallelism appropriately 

 16).Tune memory for parallel operations 

 17).Set parallel parameters

 

5.Performance Management 

 1).Install Statspack 

 2).Adjust the default interval for statistics collection 

 3).Customize the events that are monitored 

 4).Use ADDM to analyze statistics and to identify performance bottlenecks and fix them 

 5).Implement automatic shared memory management 

 6).Tune memory using manual memory management 

 7).Monitor and tune SGA areas that are not automatically tuned 

 8).Implement automatic SQL execution memory management 

 9).Tune the PGA using work area size parameters

 10).Use the PGA Advisor 

 11).Create a Database Resource Manager plan with directives (active session count, max execution time) 

 12).Create consumer groups 

 13).Configure consumer group mappings 

 14).Manage Services 

 15).Create and manage objects to accommodate different data access methods (schema tuning)

 16).Use the SQL Tuning Advisor 

 17).Use the SQL Access Advisor 

 18).Gather Optimizer statistics 

 19).Interpret execution plan 

 20).Use SQL tuning tools and features

 

6.Real Application Clusters 

 1).Install Oracle Clusterware

 2).Install the Oracle Database 10g software 

 3).Implement ASM failure groups 

 4).Create and manage ASM instance 

 5).Create and manage ASM disk groups 

 6).Configure ASM for the shared disks, and create a clustered database 

 7).Configure archiving 

 8).Configure Services with a preferred instance and an available instance

 

7.Data Guard 

 1).Use Data Guard Manager and DGMGRL 

 2).Create and utilize a physical standby database 

 3).Create and utilize a logical standby database 

 4).Set up log transport services for various levels or protection

 5).Configure the network environment to allow communication between the standby database and the primary database 

 6).Open the physical standby database in a "ready-only" state 

 7).Perform a switchover operation and a failover operation 

 8).Implement Data Guard

Oracle认证体系结构图:

10g认证相关信息

认证种类

需要参加培训的相关课程

考试代码

全部费用

OCA

Oracle Database 10g: Administration Workshop I

Oracle Database 10g: Administration Workshop I

042

美元报价

Oracle Database: SQL Certified Expert

    Oracle Database 10g: SQL Fundamentals
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Advanced PL/SQL
Oracle Database 10g: SQL Tuning Workshop

047

OCP

Oracle Database 10g: SQL Fundamentals
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop II

047
042
043

美元报价

OCM

OCP related courses and plus,
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Security
Enterprise DBA Part 1B: Backup and Recovery
Oracle Database 10g: Data Guard Administration
Oracle Database 10g: RAC for Administrators
Oracle Database 10g: Implement Streams

Oracle Database 10g Administrator Certified Master Exam

美元报价

11g认证相关信息

认证种类

相关学习课程

考试代码

OCP

Oracle Database 11g: Introduction to SQL
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II

047
052
053

             

 

 

 

 

合作伙伴
             
地址:广东省深圳市罗湖区宝安南路2014号振业大厦A座15A-B(地王大厦旁) Email:kevinzhu#cntimes.biz(将#改为@)
电话:0755-25022500 25025151 传真:0755-25022400  ICP备案:粤ICP备14017173号