蘇州OCM-OCM
蘇州三信網(wǎng)際教育咨詢有限公司,創(chuàng)立于2006年,是蘇州市規(guī)模最大、最權(quán)威的專業(yè)IT教育機構(gòu)。0512-66555771
授課機構(gòu) | 蘇州三網(wǎng)IT教育 |
上課地點 | 干將東路666號和基廣場433室(輕軌1號線臨頓路站)|詳細地圖 |
成交/評價 | 5.0分 |
聯(lián)系電話 | 0512-66555771 |
|
課程詳情
蘇州OCM,蘇州三網(wǎng)配有完善的網(wǎng)絡(luò)、系統(tǒng)、數(shù)據(jù)庫、虛擬化、云計算等高端實驗室,是眾多IT巨頭
Oracle公司現(xiàn)在可以提供4種不同的認(rèn)證,這些都是專為從事Oracle領(lǐng)域工作的人員包括DBA、開發(fā)人員以及管理人員所設(shè)計的。
Oracle專業(yè)DBA認(rèn)證:
這是為Oracle數(shù)據(jù)庫管理設(shè)計的一門基本認(rèn)證(4門)
Oracle網(wǎng)絡(luò)應(yīng)用開發(fā)人員認(rèn)證:
這是關(guān)于SQL、PL/SQL和網(wǎng)絡(luò)開發(fā)的一門認(rèn)證(4門)
Oracle Java開發(fā)人員認(rèn)證:
這是與Sun公司一起為Oracle設(shè)計的Java開發(fā)人員認(rèn)證,共有6門以及Sun和Oracle的認(rèn)證
Internet數(shù)據(jù)庫操作人員認(rèn)證:
iDBO是為數(shù)據(jù)庫和internet應(yīng)用管理中Oracle管理人員所具知識而專門設(shè)計的單獨
OCM內(nèi)容
Oracle級認(rèn)證OCM認(rèn)證??這項新的Oracle認(rèn)證要求參試人員必須參加Oracle大學(xué)的Oracle培訓(xùn),它是1990s時期前Oracle認(rèn)證的一個分支,OCM要求參試人員必須完成下面的幾項任務(wù):
獲得OCP認(rèn)證
參加Oracle大學(xué)的兩門課程
通過
通過Oracle試驗室的實踐
級Oracle技能,通過后將成為企業(yè)內(nèi)的。OCM不但有能力處理關(guān)鍵業(yè)務(wù)數(shù)據(jù)庫系統(tǒng)和應(yīng)用,還能幫助客戶利用Oracle技術(shù)獲得。要想獲得OCM,必須先通過OCP,再學(xué)習(xí)Oracle大學(xué)開設(shè)的兩門技術(shù)課程,并通過預(yù)考,然后在Oracle實驗環(huán)境內(nèi)地通過實習(xí)。實習(xí)的目的是培養(yǎng)動手能力,學(xué)員必須實際完成職業(yè)需要的真正任務(wù)。
OCM內(nèi)容大綱
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
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
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
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
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
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
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
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
咨詢電話:0512-/span> 聯(lián)系QQ :/span>
更多請點擊進入:http://suzhou.pxto.com.cn/JiGou/bcedeb664.html
學(xué)校地址:江蘇蘇州市干將東路666號和基廣場433室(輕軌一號線臨頓路)
蘇州OCM|蘇州OCM學(xué)校哪家好|蘇州OCM多少錢