杭州Oracle 10g OCM認(rèn)證培訓(xùn)

杭州OCM認(rèn)證培訓(xùn)、杭州西湖Oracle 10g OCM認(rèn)證培訓(xùn) Oracle*推出的全球認(rèn)證計(jì)劃 OCM(Oracle Certified Manager)，是由Oracle公司頒布并實(shí)施的一項(xiàng)權(quán)威的專業(yè)技術(shù)標(biāo)準(zhǔn)，行業(yè)分析師和IT技術(shù)專家認(rèn)為Oracle認(rèn)證是IT市場(chǎng)最有價(jià)值的全球認(rèn)可的資格認(rèn)證之一。從認(rèn)證專員、認(rèn)證專家到認(rèn)證大師，每個(gè)Oracle 級(jí)別都標(biāo)志著一種業(yè)界認(rèn)可的經(jīng)驗(yàn)和專業(yè)標(biāo)準(zhǔn)。 Oracle 認(rèn)證專家(OCM) 資深專家級(jí)Oracle 技能考試，通過(guò)后將成為企業(yè)內(nèi)的資深專家。OCM 不但有能力處理關(guān)鍵業(yè)務(wù)數(shù)據(jù)庫(kù)系統(tǒng)和應(yīng)用，還能幫助客戶利用Oracle 技術(shù)獲得成功。要想獲得OCM 證書(shū)，必須先通過(guò)OCP考試，再學(xué)習(xí)兩門高級(jí)技術(shù)課程，并通過(guò)預(yù)考，然后在Oracle 實(shí)驗(yàn)室環(huán)境內(nèi)成功地通過(guò)實(shí)習(xí)考試。實(shí)習(xí)考試的目的是培養(yǎng)動(dòng)手能力，學(xué)員必須實(shí)際完成職業(yè)需要的真正任務(wù)。 10g OCM認(rèn)證培訓(xùn)課程及時(shí)間： * 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天) 培訓(xùn)前提：具有OCP證書(shū)或同層次技術(shù)能力。 課程長(zhǎng)度：26天/156小時(shí) 開(kāi)班類型 日期 時(shí)間 脫產(chǎn)班 周一至周五 上午 09：00—12：00 下午 13：30—16：30 培訓(xùn)地點(diǎn): 杭州市文三路252號(hào)偉星大廈19樓博學(xué)國(guó)際教育培訓(xùn)中心 ORACLE 認(rèn)證大師 (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. 培訓(xùn)內(nèi)容： * 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 課程目標(biāo): * 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 課程內(nèi)容： * 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 課程目標(biāo): * 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 培訓(xùn)內(nèi)容： * 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：性能優(yōu)化（4天） 通過(guò)學(xué)習(xí)一些能夠*限度地提高數(shù)據(jù)庫(kù)效用的性能優(yōu)化方法，發(fā)揮 10g 數(shù)據(jù)庫(kù)的*功效。學(xué)員將學(xué)習(xí)如何通過(guò) Oracle Database 10g 自動(dòng)優(yōu)化功能受益，還將通過(guò)使用 statspack 工具練習(xí)一些人工優(yōu)化方法。明確地定義了各種方法后，學(xué)員可以使用這些方法對(duì) Oracle 數(shù)據(jù)庫(kù)進(jìn)行優(yōu)化。本課程將介紹 Oracle 數(shù)據(jù)庫(kù)的各種可調(diào)組件。在整個(gè)課程中，將通過(guò)一系列的課堂練習(xí)，讓學(xué)員親手體驗(yàn) Oracle 數(shù)據(jù)庫(kù)的優(yōu)化操作。 課程目標(biāo): * 使用適用于可用工具的 Oracle 數(shù)據(jù)庫(kù)優(yōu)化方法 * 利用數(shù)據(jù)庫(kù) Advisor 主動(dòng)地對(duì) Oracle 數(shù)據(jù)庫(kù)進(jìn)行優(yōu)化 * 使用基于自動(dòng)工作量信息庫(kù)的工具對(duì)數(shù)據(jù)庫(kù)進(jìn)行優(yōu)化 * 使用 Statspack 報(bào)表對(duì)數(shù)據(jù)庫(kù)進(jìn)行優(yōu)化 * 診斷并優(yōu)化常見(jiàn)的數(shù)據(jù)庫(kù)性能問(wèn)題 * 使用 Enterprise Manager 中與性能有關(guān)的頁(yè)監(jiān)控 Oracle 數(shù)據(jù)庫(kù)。 培訓(xùn)內(nèi)容： * 性能優(yōu)化概覽 * 統(tǒng)計(jì)數(shù)據(jù)和等待事件 * 指標(biāo)、預(yù)警和基準(zhǔn) * 使用 Statspack * 使用 AWR * 被動(dòng)式優(yōu)化 * 優(yōu)化共享池 * 優(yōu)化緩沖區(qū)高速緩存 * 自動(dòng)共享內(nèi)存 * 檢查點(diǎn)和重做優(yōu)化 * 優(yōu)化 I/O * 優(yōu)化 PGA 和臨時(shí)空間 * 優(yōu)化塊空間的使用量 * 初始配置 Oracle Database 10g：實(shí)施和管理數(shù)據(jù)倉(cāng)庫(kù)（4天） 本課程是為數(shù)據(jù)庫(kù)管理員、系統(tǒng)管理員以及設(shè)計(jì)、維護(hù)和使用數(shù)據(jù)倉(cāng)庫(kù)的數(shù)據(jù)庫(kù)應(yīng)用程序開(kāi)發(fā)員設(shè)計(jì)的。參加本課程之前，您應(yīng)該熟悉關(guān)系數(shù)據(jù)庫(kù)的概念、數(shù)據(jù)倉(cāng)庫(kù)基本原理、包括應(yīng)用程序和服務(wù)器優(yōu)化在內(nèi)的 Oracle 服務(wù)器概念，以及運(yùn)行 Oracle Database Server 的操作系統(tǒng)環(huán)境。 課程目標(biāo): * 了解和描述 Oracle 10g Data Warehouse 的內(nèi)在功能 * 演示如何實(shí)施并行操作 * 演示數(shù)據(jù)提取、轉(zhuǎn)換和加載流程 * 描述和演示如何有效使用數(shù)據(jù)倉(cāng)庫(kù)中的物化圖 * 描述星形方案、雪花方案和 3NF 方案 * 為數(shù)據(jù)倉(cāng)庫(kù)表實(shí)施有效的分區(qū)方案 * 制定有效的備份和恢復(fù)策略 * 描述數(shù)據(jù)倉(cāng)庫(kù)面臨的安全性挑戰(zhàn) 培訓(xùn)內(nèi)容： * 數(shù)據(jù)倉(cāng)庫(kù)設(shè)計(jì) * 數(shù)據(jù)倉(cāng)儲(chǔ)方案 * 分區(qū)基本概念 * 提取、傳輸和加載（提取和傳輸） * ETL 加載 * ETL 轉(zhuǎn)換 * 并行概念 * 數(shù)據(jù)倉(cāng)庫(kù)中的并行操作 * 物化圖 * 維 * 物化圖刷新 * 查詢重寫(xiě)功能 * SQL Access Advisor * 數(shù)據(jù)倉(cāng)庫(kù)系統(tǒng)管理 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. 課程目標(biāo): * 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 培訓(xùn)內(nèi)容： * 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 考試內(nèi)容: （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 為什么選擇在博學(xué)國(guó)際教育培訓(xùn)中心參加Oracle培訓(xùn) 1、培訓(xùn)師資：博學(xué)教育中心Oracle講師隊(duì)伍由2名OCT，15名OCP組成。全部為Oracle數(shù)據(jù)庫(kù)管理專家，有多年數(shù)據(jù)庫(kù)維護(hù)經(jīng)驗(yàn)全部有多年的授課經(jīng)歷，理論聯(lián)系實(shí)際。 2、培訓(xùn)環(huán)境： 每人專用一臺(tái)電腦，聯(lián)網(wǎng)環(huán)境；實(shí)驗(yàn)環(huán)境24小時(shí)開(kāi)放，由Sun和IBM小型機(jī)、Cisco路由器交換機(jī)、Oracle數(shù)據(jù)庫(kù)、Solaris操作系統(tǒng)、IBM AIX操作系統(tǒng)、Red Hat Linux操作系統(tǒng)組成的高端IT實(shí)驗(yàn)室；實(shí)行公司化管理，空調(diào)機(jī) 房，真切體驗(yàn) IT 公司氛圍。 4、培訓(xùn)價(jià)格： 博學(xué)教育中心實(shí)行滾動(dòng)開(kāi)課，提供優(yōu)質(zhì)培訓(xùn)的同時(shí)，降低了培訓(xùn)費(fèi)用 5、交通便利： 杭州市文三路252號(hào)偉星大廈19樓A座（地處文教區(qū)，電子信息一條街，*信息產(chǎn)業(yè)園）（點(diǎn)擊查看詳細(xì)交通線路） 6、教學(xué)模式： 博學(xué)教育中心采用全新教學(xué)模式，理論授課與實(shí)驗(yàn)操作相結(jié)合，實(shí)現(xiàn)滾動(dòng)開(kāi)課，學(xué)員1年內(nèi)無(wú)條件免費(fèi)重聽(tīng)、免費(fèi)實(shí)驗(yàn)。 7、認(rèn)證考試： 博學(xué)國(guó)際教育培訓(xùn)中心為Prometric、VUE授權(quán)國(guó)際認(rèn)證考試中心，由于設(shè)備，師資，教學(xué)模式的全面優(yōu)勢(shì)，確保了 教學(xué)質(zhì)量，加上考試內(nèi)容資料和輔導(dǎo)，學(xué)員全部通過(guò)Oracle OCA，OCP考試。 8、Oracle培訓(xùn)客戶： TOSHIBA（杭州）、UTstarcom（*）、浙江電信、浙江移動(dòng)、浙江聯(lián)通、寧波移動(dòng)、杭州網(wǎng)通、山西電信、江 蘇電信、武漢電信、浙江省報(bào)刊發(fā)行局、東方通信、中程科技、恒生電子、浙大快威、浙大網(wǎng)新、用友軟件、重 慶電信、國(guó)航浙江、信雅達(dá)、杭州朗新、南方航空、朝華科技等等。