杭州Oracle 10g OCM認證培訓

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