杭州OCM認證培訓、杭州西湖Oracle 10g OCM認證培訓
Oracle*推出的全球認證計劃 OCM(Oracle Certified Manager)，是由Oracle公司頒布并實施的一項權威的專業技術標準，行業分析師和IT技術專家認為Oracle認證是IT市場最有價值的全球認可的資格認證之一。從認證專員、認證專家到認證大師，每個Oracle 級別都標志著一種業界認可的經驗和專業標準。
Oracle 認證專家(OCM)
資深專家級Oracle 技能考試，通過后將成為企業內的資深專家。OCM 不但有能力處理關鍵業務數據庫系統和應用，還能幫助客戶利用Oracle 技術獲得成功。要想獲得OCM 證書，必須先通過OCP考試，再學習兩門高級技術課程，并通過預考，然后在Oracle 實驗室環境內成功地通過實習考試。實習考試的目的是培養動手能力，學員必須實際完成職業需要的真正任務。
10g OCM認證培訓課程及時間：
* Oracle Enterprise Manager 10g Grid Control （5天）
* Oracle Database 10g: Real Application Clusters （5天）
* Oracle Database 10g: Data Guard Administration （3天）
* Oracle Database 10g: Performance Tuning （4天）
* Oracle Database 10g: Implement and Administer Data Warehouse （4天）
* Oracle Database 10g: Backup and Recovery （3天）
* Oracle Database 10g: OCM Exam Preparation (2天)
培訓前提：具有OCP證書或同層次技術能力。
課程長度：26天/156小時
開班類型 日期 時間
脫產班 周一至周五 上午 09：00—12：00
下午 13：30—16：30
培訓地點: 杭州市文三路252號偉星大廈19樓博學國際教育培訓中心
ORACLE 認證大師 (OCM) 課程介紹：
Oracle Enterprise Manager 10g Grid Control (5天)
Oracle Enterprise Manager 10g 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.
The participants gain knowledge on the installation and configuration of the Grid Control framework. The out-of-box capability to manage Oracle targets as well as the ability to extend Grid Control to manage non-Oracle targets is presented. Hands-on practices help students learn how use the robust features of Grid Control to manage, monitor, and administer their data center.
培訓內容： * Introduction
* Grid Control Architecture
* Deploying Grid Control
* Deploying the Oracle Management Agent
* Securing Grid Control
* Monitoring Grid Control
* Configuring Grid Control
* Common Managed Targets - Host
* Common Managed Targets – Oracle Database
* Common Managed Targets - Oracle Application Servers * Monitoring your Data Center
* Groups
* Systems and Services
* Job System
* Configuration Management
* Provisioning
* Information Publisher
* Monitoring Oracle Collaboration Suite
* Management Plug-ins
* Upgrade to Grid Control 10.2
Oracle Database 10g: Real Application Clusters (5天)
This course offers students an introduction to the general features and capabilities of Oracle Database 10g 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
課程目標:
* Identify Real Application Clusters components
* Install, create, administer, and monitor a Real Application Clusters database
* Use configuration and management tools for Real Application Clusters databases
* Migrate your database storage to Automatic Storage Management
* Setup services for workloads management, and applications high availability
* Develop a backup and recovery strategy for Real Application Clusters databases
* Review high availability best practices
課程內容： * Introduction
* Architecture and Concepts
* RAC Installation and Configuration Part I
* RAC Installation and Configuration Part II
* RAC Database Instances Administration
* Administering Storage in RAC Part I * Administering Storage in RAC Part II
* Services
* High Availability of Connections
* Managing Backup and Recovery in RAC
* RAC Performance Tuning
* Design for High Availability
Oracle Database 10g: Data Guard Administration (3天)
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
課程目標:
* Use Data Guard to achieve a highly available Oracle Database
* Describe the Data Guard architecture
* Modify the Data Guard services
* Use the Data Guard broker
* Implement physical and logical standby databases
* Perform failover and switchover operations
* Enable fast-start failover
培訓內容：
* Oracle Data Guard: Overview
* Understanding the Oracle Data Guard Architecture
* Using Oracle Data Guard Broker and Enterprise Manager
* Creating a Configuration and Physical Standby Database by Using Enterprise Manager
* Creating a Physical Standby Database by Using SQL
* Configuring Data Protection Modes and Log Transport Services
* Creating a Logical Standby Database by Using Enterprise Manager
* Creating a Logical Standby Database by Using SQL
* Performing Switchover and Failover
* Enabling Fast-Start Failover
* Using Data Guard in a Real Application Clusters Configuration
* Other Considerations for Oracle Data Guard
* Workshop
Oracle Database 10g：性能優化（4天）
通過學習一些能夠*限度地提高數據庫效用的性能優化方法，發揮 10g 數據庫的*功效。學員將學習如何通過 Oracle Database 10g 自動優化功能受益，還將通過使用 statspack 工具練習一些人工優化方法。明確地定義了各種方法后，學員可以使用這些方法對 Oracle 數據庫進行優化。本課程將介紹 Oracle 數據庫的各種可調組件。在整個課程中，將通過一系列的課堂練習，讓學員親手體驗 Oracle 數據庫的優化操作。
課程目標:
* 使用適用于可用工具的 Oracle 數據庫優化方法
* 利用數據庫 Advisor 主動地對 Oracle 數據庫進行優化
* 使用基于自動工作量信息庫的工具對數據庫進行優化
* 使用 Statspack 報表對數據庫進行優化
* 診斷并優化常見的數據庫性能問題
* 使用 Enterprise Manager 中與性能有關的頁監控 Oracle 數據庫。
培訓內容：
* 性能優化概覽
* 統計數據和等待事件
* 指標、預警和基準
* 使用 Statspack
* 使用 AWR
* 被動式優化
* 優化共享池 * 優化緩沖區高速緩存
* 自動共享內存
* 檢查點和重做優化
* 優化 I/O
* 優化 PGA 和臨時空間
* 優化塊空間的使用量
* 初始配置
Oracle Database 10g：實施和管理數據倉庫（4天）
本課程是為數據庫管理員、系統管理員以及設計、維護和使用數據倉庫的數據庫應用程序開發員設計的。參加本課程之前，您應該熟悉關系數據庫的概念、數據倉庫基本原理、包括應用程序和服務器優化在內的 Oracle 服務器概念，以及運行 Oracle Database Server 的操作系統環境。
課程目標:
* 了解和描述 Oracle 10g Data Warehouse 的內在功能
* 演示如何實施并行操作
* 演示數據提取、轉換和加載流程
* 描述和演示如何有效使用數據倉庫中的物化圖 * 描述星形方案、雪花方案和 3NF 方案
* 為數據倉庫表實施有效的分區方案
* 制定有效的備份和恢復策略
* 描述數據倉庫面臨的安全性挑戰
培訓內容：
* 數據倉庫設計
* 數據倉儲方案
* 分區基本概念
* 提取、傳輸和加載（提取和傳輸）
* ETL 加載
* ETL 轉換
* 并行概念 * 數據倉庫中的并行操作
* 物化圖
* 維
* 物化圖刷新
* 查詢重寫功能
* SQL Access Advisor
* 數據倉庫系統管理
Oracle Database 10g: Backup and Recovery（4天）
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.
課程目標:
* Plan effective backup and recovery procedures
* Use Recovery Manager to create backups and perform recovery operations
* Use Oracle Flashback technologies to recover from human error
* Install Oracle Secure Backup
* Perform an Oracle-suggested backup to tape
* Use Oracle Secure Backup to perform a file system backup
* Use Oracle Secure Backup to perform a file system restoration
* Perform an encrypted database backup and restore
* Manage the Oracle Secure Backup environment
* Monitor and tune Recovery Manager
* Perform tablespace point-in-time recovery
* Create a duplicate database
* Create and manage a recovery catalog database
培訓內容：
* Introduction
* Configuring for Recoverability
* Using RMAN to Create Backups
* Using RMAN to Perform Recovery
* Using Oracle Flashback Technologies
* Using RMAN to Create a Duplicate Database
* Performing Tablespace Point-in-Time Recovery
* Using the RMAN Recovery Catalog * Monitoring and Tuning RMAN
* Oracle Secure Backup Overview
* Install Oracle Secure Backup
* Use RMAN and Oracle Secure Backup
* Back Up File System Files With Oracle Secure Backup
* Restore File System Backups with Oracle Secure Backup
* Manage Oracle Secure Backup Security
* Manage the Administrative Domain
Oracle Database 10g Administrator Certified Master Exam（2天）
Exam Number: 10g OCM
Associated Certifications:
Oracle 10g DBA OCM
Exam Price:
18000
Duration:
2 days
考試內容:
（1）Server Configuration
* Create the database
* Determine and set sizing parameters for database structures
* Create and manage temporary, permanent, and undo tablespaces
* Stripe data files across multiple physical devices and locations
* Configure the database environment to support optimal data access performance
* Create and manage database configuration files
* Create and manage bigfile tablespaces * Create and manage multiple network configuration files
* Create and configure a listener
* Configure the database instance to support shared server connections
* Set up network tracing
* Manage Oracle network processes (the Listener Control utility)
* Configure the network environment to allow connections to multiple databases
* Use configurationless connections
（2） Enterprise Manager Grid Control
Install the Enterprise Manager Grid Control software
* Configure the Enterprise Manager repository
* Create Enterprise Manager Grid Control users
* Use Enterprise Manager to modify a database configuration
* Configure Enterprise Manager to modify a database availability
* Create and manage jobs
* Create and monitor alerts
* Create notifications
* Implement Grid Control and Database Control
* Choose the appropriate tablespace type for the intended use
* Create Scheduler jobs
* Create schedules
* Assign jobs to windows
* Create programs
* Create job classes
* Install the Enterprise Manager Grid Control infrastructure
* Deploy Enterprise Manager Grid Control agents
* Configure Grid Control for business requirements
(3)Managing Database Availability
* Create a recovery catalog database
* Configure Recovery Manager
* Use Recovery Manager to perform database backups
* Use Recover Manager to perform complete database restore and recovery operations * Set Flashback Database parameters
* Monitor Flashback Database logs and statistics
* Perform a Flashback Database operation
* Configure a flash recovery area
(4)Data Management
* Implement fine-grained auditing
* Create a secure application role
* Grant specific privileges for a Flashback Query
* Set parameters for retaining undo
* Implement fine-grained access control
* Create and manage contexts
* Use SQL*Loader
* Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files)
* Choose the appropriate partition method (range, hash, list, and composite)
* Choose the appropriate partition key
* Choose appropriate indexing methods (local, global, prefixed, and nonprefixed)
* Perform partition maintenance operations
* Maintain indexes on a partitioned table
* Create and manage LOB segments
* Apply parallelism appropriately
* Tune memory for parallel operations
* Set parallel parameters
(5)Data Warehouse Management
* Create external tables (Data Loader and Data Pump drivers)
* Implement Data Pump export and import jobs for data transfer
* Implement Data Pump to and from remote databases * Implement Replication/Streams
* Configure and manage master replication
* Configure and manage distributed materialized views
* Configure and manage Streams for replication
(6) Performance Management * Install Statspack
* Adjust the default interval for statistics collection
* Customize the events that are monitored
* Use ADDM to analyze statistics and to identify performance bottlenecks and fix them
* Implement automatic shared memory management
* Tune memory using manual memory management
* Monitor and tune SGA areas that are not automatically tuned
* Implement automatic SQL execution memory management
* Tune the PGA using work area size parameters * Use the PGA Advisor
* Create a Database Resource Manager plan with directives (active session count, max execution time)
* Create consumer groups
* Configure consumer group mappings
* Manage Services
* Create and manage objects to accommodate different data access methods (schema tuning)
* Use the SQL Tuning Advisor
* Use the SQL Access Advisor
* Gather Optimizer statistics
* Interpret execution plan
* Use SQL tuning tools and features
(7) Real Application Clusters * Install Oracle Clusterware
* Install the Oracle Database 10g software
* Implement ASM failure groups
* Create and manage as ASM instance
* Create and manage ASM disk groups * Configure ASM for the shared disks, and create a clustered database
* Configure archiving
* Configure Services with a preferred instance and an available instance
(8) Data Guard * Use Data Guard Manager and DGMGRL
* Create and utilize a physical standby database
* Create and utilize a logical standby database
* Set up log transport services for various levels or protection
* Configure the network environment to allow communication between the standby database and the primary database
* Open the physical standby database in a "ready-only" state
* Perform a switchover operation and a failover operation
* Implement Data Guard
為什么選擇在博學國際教育培訓中心參加Oracle培訓
1、培訓師資：博學教育中心Oracle講師隊伍由2名OCT，15名OCP組成。全部為Oracle數據庫管理專家，有多年數據庫維護經驗全部有多年的授課經歷，理論聯系實際。
2、培訓環境：
每人專用一臺電腦，聯網環境；實驗環境24小時開放，由Sun和IBM小型機、Cisco路由器交換機、Oracle數據庫、Solaris操作系統、IBM AIX操作系統、Red Hat Linux操作系統組成的高端IT實驗室；實行公司化管理，空調機 房，真切體驗 IT 公司氛圍。
4、培訓價格：
博學教育中心實行滾動開課，提供優質培訓的同時，降低了培訓費用
5、交通便利：
杭州市文三路252號偉星大廈19樓A座（地處文教區，電子信息一條街，*信息產業園）（點擊查看詳細交通線路）
6、教學模式：
博學教育中心采用全新教學模式，理論授課與實驗操作相結合，實現滾動開課，學員1年內無條件免費重聽、免費實驗。
7、認證考試：
博學國際教育培訓中心為Prometric、VUE授權國際認證考試中心，由于設備，師資，教學模式的全面優勢，確保了 教學質量，加上考試內容資料和輔導，學員全部通過Oracle OCA，OCP考試。
8、Oracle培訓客戶：
TOSHIBA（杭州）、UTstarcom（*）、浙江電信、浙江移動、浙江聯通、寧波移動、杭州網通、山西電信、江 蘇電信、武漢電信、浙江省報刊發行局、東方通信、中程科技、恒生電子、浙大快威、浙大網新、用友軟件、重 慶電信、國航浙江、信雅達、杭州朗新、南方航空、朝華科技等等。
