重庆oracle认证培训机构

产品分类

热门关键词

联系我们

企业名称:重庆赛烽达科技有限公司

联系人:程老师

手机:13372708242

邮箱:xqzhang@saifengda.com

网址:www.cqora.com

地址:重庆石桥铺高创锦业17-3

Oracle OCM认证大师

您的当前位置: 首 页 >> 培训课程 >> Oracle培训

Oracle OCM认证大师

  • 所属分类:Oracle培训

  • 点击次数:
  • 发布日期:2018/08/15
  • 规格:
  • 类型:
  • 在线询价
  • 详细介绍

         ORACLE Certified Master(OCM)为ORACLE公司的数据库专家认证。OCM是资深专家级的ORACLE认证考试,它重在实践,与华为HCIE、思科CCIE认证很相似,是ORACLE公司推出的最高一级别的认证,获取OCM认证的工程师在技能上更具有说服力。通过后将成为企业内的资深专家,这种认证的人员也是ORACLE相关一些咨询公司以后的最佳人选。

         

          通过这个课程使ORACLE数据库专家掌握了大型ORACLE数据库在Linux/Unix平台上的网格、集群、灾备、调优、数据仓库、安全等高级维护技术,有资格成为大型数据中心行业权威。


OCM培训入学条件


ORACLE数据库管理员OCP,全面掌握ORACLE SQL PLSQL的开发技术。


ORACLE培训ORACLE认证(OCM)考试科目


ORACLE培训ORACLE认证(OCM)考试从2007年开始已经可以在中国大陆考试,考试费用为 2000美金。

定期(一般每隔两个月)在北京或上海安排OCM考试。考试形式为上机操作,在两天内分9场考试。

Oracle OCM证书样本


1533656163120505.jpg


ORACLE培训ORACLE认证(OCM)培训班型


OCM脱产班        官方标准200课时

周末班                官方标准200课时

OCM培训课程内容


一、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 a tablespace that uses NFS mounted file system file
      9  Create and manage multiple network configuration files
      10  Create and configure a listener
      11  Configure the database instance to support shared server connections
      12  Set up network tracing 
      13  Manage Oracle network processes
      14  Configure the network environment to allow connections to multiple databases
      15  Use configurationless connections
      16  Use OPatch to install a patch
      17  Use Grid Infrastructure to manage oracle databases and other resources

      18  Use Enterprise Manager Configuration Assistant(EMCA) utility


二、Enterprise Manager Grid Control
     1  Install and Patch 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 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

 三、Managing Database Availability
     1  Mantain recovery catalogs
     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 Configure RMAN 
     6 Create different types of RMAN backups to cater for different performance and retention requirements
     7 Set Flashback Database parameters
     8 Configure a Fast Recovery Area
     9 Perform various recovery operations using Flashback technology

 四、Data Management
      1  Manage Materialized Views to improve rewrite and refresh performance
      2  Configure and manage distributed materialized views
      3  Create and Manage encrypted tablespaces
      4  Manage Transport of tablespaces across platforms
      5  Configure a schema to support a star transformation query
      6  Administer external tables
      7  Implement Data Pump export and import jobs for data transfer
      8  Implement Data Pump to and from remote databases
      9  Configure and use parallel execution for queries
     10  Use SQL*Loader
     11  Administer, manage and tune parallel execution

五、Data Warehouse Management
       1  Administer partitioned tables and indexes using appropriate methods and keys 
       2  Perform partition maintenance operations 
       3  Maintain indexes on a partitioned table
       4  Implement securefile LOB 
       5  Create and manage LOB segments
       6  Implement fine-grained access control
       7  Create and manage contexts
       8  Administer flashback data archive and schema evolution

六、Performance Management
       1 Administer Resource Manager
       2 Use Result Cache
       3 Use multi column statistics
       4 Gather statistics on a specific table without invalidating cursors Use partitioned indexes
       5 Administer and tune schema object to support various access methods Interpret execution plan
       6 Use SQL tuning tools and features
       7 Use SQL Tuning Advisor
       8 Use SQL Access Advisor
       9 Use SQL Performance Analyzer Configure baseline templates
      10 Use SQL Plan Management feature Implement instance caging

七、Grid Infrastructure and ASM
       1 Install Oracle Grid Infrastructure Create ASM Disk Groups
        2 Create and manage as ASM instance Implement ASM failure groups Creating ACFS File System
        3 Start, stop, configure and administer Oracle Grid Infrastructure

八、Real Application Clusters
       1 Install the Oracle Database 11gR2 software
       2 Configure ASM for the shared disks and create a clustered database Configure archiving
       3 Configure services using both Manual and Policy Managed methods
九、Data Guard
       1 Create Physical Standby Database with real-time apply
       2 Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
       3 Configure the Observer
       4 Switchover and switch back
       5 Configure connect time failover
       6 Convert the standby to a snapshot standby
       7 Configure archivelog deletion policy for the Dataguard configuration 


ORACLE培训ORACLE认证(OCM)课程特色



       1) ORACLE公司资深工程师或ORACLR认证大师OCM全程授课
       2) 免费加送LINUX课程




我们为您提供贴心的服务

       

1、您享受终身免费重修;

       2、尊享考前辅导,考前仿真在线测试;

       3、尊享网络学院终身学习;

       4、尊享认证培训,考试预约,证书申请,一站式贴心服务;

       5、尊享强大技术顾问提供终身技术咨询服务;

       6、尊享3天内无条件退款。


注:随着版本的升级,基础工作性质的变化,该课程提纲可能随时更改如果您对某项课程有任何疑问,请通过网络或致电 17754917523 联系我们的客服人员。



本文网址:http://www.cqora.com/product/555.html

关键词:重庆OracleOCM认证大师

最近浏览:

报名咨询

点击咨询报名

赛烽达QQ群

赛烽达技术群

程老师

xxxxxxxxxx

加微信咨询

张老师微信.jpg

xqzhang@saifengda.com