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.
