Oracle 顶级数据库大师认证－OCM
——课程大纲
Oracle认证体系结构图：
|
10g认证相关信息
|
|
认证种类
|
需要参加培训的相关课程
|
考试代码
|
全部费用
|
|
OCA
|
Oracle Database 10g: Administration Workshop I
|
Oracle Database 10g: Administration Workshop I
|
042
|
美元报价
|
|
Oracle Database: SQL Certified Expert
|
Oracle Database 10g: SQL Fundamentals
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Advanced PL/SQL
Oracle Database 10g: SQL Tuning Workshop
|
047
|
|
OCP
|
Oracle Database 10g: SQL Fundamentals
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop II
|
047
042
043
|
美元报价
|
|
OCM
|
OCP related courses and plus,
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Security
Enterprise DBA Part 1B: Backup and Recovery
Oracle Database 10g: Data Guard Administration
Oracle Database 10g: RAC for Administrators
Oracle Database 10g: Implement Streams
|
Oracle Database 10g Administrator Certified Master Exam
|
美元报价
|
|
11g认证相关信息
|
|
认证种类
|
相关学习课程
|
考试代码
|
|
OCP
|
Oracle Database 11g: Introduction to SQL
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II
|
047
052
053
|
|
|
|
|
|
|
|
|
ORACLE10g OCM大纲 （160学时全脱产授课共4周 周末授课共24次课程+2天考前辅导）
1. Database Server Configuration
1). Create the database
2). Determine and set sizing parameters for database structures
3). Create and manage temporary, permanent, and undo tablespaces
4). Stripe data files across multiple physical devices and locations
5). Configure the database environment to support optimal data access performance
6). Create and manage database configuration files
7). Create and manage bigfile tablespaces
8). Create and manage multiple network configuration files
9). Create and configure a listener
10).Configure the database instance to support shared server connections
11).Set up network tracing
12).Manage Oracle network processes (the Listener Control utility)
13).Configure the network environment to allow connections to multiple databases
14).Use configurationless connections
2. Oracle Enterprise Manager Grid Control
1).Install the Enterprise Manager Grid Control software
2).Configure the Enterprise Manager repository
3).Create Enterprise Manager Grid Control users
4).Use Enterprise Manager to modify a database configuration
5).Configure Enterprise Manager to modify a database availability
6).Create and manage jobs
7).Create and monitor alerts
8).Create notifications
9).Implement Grid Control and Database Control
10).Choose the appropriate tablespace type for the intended use
11).Create Scheduler jobs
12).Create schedules
13).Assign jobs to windows
14).Create programs
15).Create job classes
16).Install the Enterprise Manager Grid Control infrastructure
17).Deploy Enterprise Manager Grid Control agents
18).Configure Grid Control for business requirements
3.Managing Database Availability
1).Create a recovery catalog database
2).Configure Recovery Manager
3).Use Recovery Manager to perform database backups
4).Use Recover Manager to perform complete database restore and recovery operations
5).Set Flashback Database parameters
6).Monitor Flashback Database logs and statistics
7).Perform a Flashback Database operation
8).Configure a flash recovery area
4.Data Management
1).Implement fine-grained auditing
2).Create a secure application role
3).Grant specific privileges for a Flashback Query
4).Set parameters for retaining undo
5).Implement fine-grained access control
6).Create and manage contexts
7).Use SQL*Loader
8).Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files)
9).Choose the appropriate partition method (range, hash, list, and composite)
10).Choose the appropriate partition key
11).Choose appropriate indexing methods (local, global, prefixed, and nonprefixed)
12).Perform partition maintenance operations
13).Maintain indexes on a partitioned table
14).Create and manage LOB segments
15).Apply parallelism appropriately
16).Tune memory for parallel operations
17).Set parallel parameters
5.Performance Management
1).Install Statspack
2).Adjust the default interval for statistics collection
3).Customize the events that are monitored
4).Use ADDM to analyze statistics and to identify performance bottlenecks and fix them
5).Implement automatic shared memory management
6).Tune memory using manual memory management
7).Monitor and tune SGA areas that are not automatically tuned
8).Implement automatic SQL execution memory management
9).Tune the PGA using work area size parameters
10).Use the PGA Advisor
11).Create a Database Resource Manager plan with directives (active session count, max execution time)
12).Create consumer groups
13).Configure consumer group mappings
14).Manage Services
15).Create and manage objects to accommodate different data access methods (schema tuning)
16).Use the SQL Tuning Advisor
17).Use the SQL Access Advisor
18).Gather Optimizer statistics
19).Interpret execution plan
20).Use SQL tuning tools and features
6.Real Application Clusters
1).Install Oracle Clusterware
2).Install the Oracle Database 10g software
3).Implement ASM failure groups
4).Create and manage ASM instance
5).Create and manage ASM disk groups
6).Configure ASM for the shared disks, and create a clustered database
7).Configure archiving
8).Configure Services with a preferred instance and an available instance
7.Data Guard
1).Use Data Guard Manager and DGMGRL
2).Create and utilize a physical standby database
3).Create and utilize a logical standby database
4).Set up log transport services for various levels or protection
5).Configure the network environment to allow communication between the standby database and the primary database
6).Open the physical standby database in a "ready-only" state
7).Perform a switchover operation and a failover operation
8).Implement Data Guard
