Oracle11G认证大师(OCM)培训
培训班型: 企业内训、公开课
课程长度: 20天/120小时
培训日期: 待定
培训价格: 5000元/人
认证考试:
培训地点: 博学国际教育培训中心
环境要求: 投影仪、白板、大白纸
培训形式: 实例讲授,现场演、练、及时沟通
培训资料: 培训教材
课程内容
课程介绍:
Oracle Enterprise Manager 11g Grid Control
Oracle Enterprise Manager 11g Grid Control delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments. Robust service level management functionality within Oracle Grid Control dramatically improves service levels through rich transaction and end-user performance monitoring and deep diagnostics for multi-tier Internet applications. Oracle Grid Control also offers a comprehensive extensibility framework for management of custom applications and integration with other management tools. These capabilities allow companies to deliver superior performance for their systems and applications, while continually reducing management complexity and costs.
Oracle Database 11g: Real Application Clusters
This course offers students an introduction to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC).Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration
Oracle Database 11g: Data Guard Administration
Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips. Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills
Oracle Database 11g:性能优化
通过学习一些能够*限度地提高数据库效用的性能优化方法,发挥 11g 数据库的*功效。学员将学习如何通过 Oracle Database 11g 自动优化功能受益,还将通过使用 statspack 工具练习一些人工优化方法。明确地定义了各种方法后,学员可以使用这些方法对 Oracle 数据库进行优化。本课程将介绍 Oracle 数据库的各种可调组件。在整个课程中,将通过一系列的课堂练习,让学员亲手体验 Oracle 数据库的优化操作。
Oracle Database 11g: SQL Tuning Workshop
This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 11g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 11g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax。
Oracle Database 11g:实施和管理数据仓库
本课程是为数据库管理员、系统管理员以及设计、维护和使用数据仓库的数据库应用程序开发员设计的。参加本课程之前,您应该熟悉关系数据库的概念、数据仓库基本原理、包括应用程序和服务器优化在内的 Oracle 服务器概念,以及运行 Oracle Database Server 的操作系统环境。
Oracle Database 11g: Backup and Recovery
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error.This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.