Oracle11G認證大師(OCM)培訓(xùn)
培訓(xùn)班型： 企業(yè)內(nèi)訓(xùn)、公開課
課程長度： 20天/120小時
培訓(xùn)日期： 待定
培訓(xùn)價格： 5000元/人
認證考試：
培訓(xùn)地點： 博學(xué)國際教育培訓(xùn)中心
環(huán)境要求： 投影儀、白板、大白紙
培訓(xùn)形式： 實例講授，現(xiàn)場演、練、及時溝通
培訓(xùn)資料： 培訓(xùn)教材
課程內(nèi)容
課程介紹：
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：性能優(yōu)化
通過學(xué)習(xí)一些能夠*限度地提高數(shù)據(jù)庫效用的性能優(yōu)化方法，發(fā)揮 11g 數(shù)據(jù)庫的*功效。學(xué)員將學(xué)習(xí)如何通過 Oracle Database 11g 自動優(yōu)化功能受益，還將通過使用 statspack 工具練習(xí)一些人工優(yōu)化方法。明確地定義了各種方法后，學(xué)員可以使用這些方法對 Oracle 數(shù)據(jù)庫進行優(yōu)化。本課程將介紹 Oracle 數(shù)據(jù)庫的各種可調(diào)組件。在整個課程中，將通過一系列的課堂練習(xí)，讓學(xué)員親手體驗 Oracle 數(shù)據(jù)庫的優(yōu)化操作。
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：實施和管理數(shù)據(jù)倉庫
本課程是為數(shù)據(jù)庫管理員、系統(tǒng)管理員以及設(shè)計、維護和使用數(shù)據(jù)倉庫的數(shù)據(jù)庫應(yīng)用程序開發(fā)員設(shè)計的。參加本課程之前，您應(yīng)該熟悉關(guān)系數(shù)據(jù)庫的概念、數(shù)據(jù)倉庫基本原理、包括應(yīng)用程序和服務(wù)器優(yōu)化在內(nèi)的 Oracle 服務(wù)器概念，以及運行 Oracle Database Server 的操作系統(tǒng)環(huán)境。
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.
