課程簡介

Oracle OCP 11g 認證是業界廣泛認可的技術認證之壹,受到廣大專業服務與技術支援人員高度關註。其在產品規劃、技術支援與解決方案,以及在安裝服務、規劃說明方面,已經通過嚴格的訓練及專業考核。同時此專業認證也肯定了同學具備足夠的專業技能,為企業用戶提供數據庫管理服務及完整解決方案。求職者具備數據庫管理專業技術與實務應用,才能在未來事業上保持高度的競爭優勢,取得 Oracle OCP 11g 認證無疑是為您的履歷表及未來工作增值首選!

現在本中心聯同最專業的合作夥伴 Automated Systems Holdings Limited (The ASL Group) 合辦 Oracle 11g DBA Certified Professional (OCP) Workshop  甲骨文數據庫管理高級專家證書課程,同學請握緊機會考取國際專業認可資格,為您將來的前途鋪路。

我們最新推出的 Oracle OCP 11g 課程由擁有多年數據庫管理經驗及 Oracle 認可 之導師任教,能幫助您學識安裝、管理及操作 Oracle Database 11g 系統外,更幫助您考取 OCP 專業證書。課程中已包括 Oracle OCP 11g  筆記課本,Orcale 官方電子書課程教材 及 最新的模擬試題,讓同學準備充足應付考試。 

  
適合人仕:

數據庫管理人員、系統管理人員
網頁開發人員編寫人員
資訊科技部門主管 / 經理
對數據庫管理及編寫網頁程式有興趣的人士
修讀條件:

對Windows 操作有基本認識
對互聯網及數據庫有基本概念
對網絡系統及 LAN 具有基本概念
課程包括:
 
導師精心編製 Oracle OCP 11g 課程筆記
Orcale 官方電子書課程教材 (原價為$18,125)
一人一機實習,針對各科考試要點溫習
再配合不同層次的 Lab Test 練習
由擁有多年數據庫管理經驗及 Oracle 認可 之導師任教
課程電腦設備:
 
我們採用全新 DELL 原廠電腦,配以 Intel Core 2 或 AMD Athlon 64 X2 高速處理器 、
2GB DDR2 記憶體、500GB SATA II Hard Disk 及 17" LCD Display,加上每部電腦均連接上 100/1000 Mbps Fast Ethernet 高速網絡,在學習過程中保證 "暢通無阻"。


 

授課語言:

以廣東話授課為主,亦會以英語輔助

 

課程全長
 
(Oracle Database 11g: Introduction to SQL + Oracle Database 11g: DB Admin I
   證書課程)
:

     10 堂 / 30 小時 (每堂 3 小時)

課程全長
 
(OCA 11g upgrade Oracle Database 11g: DB Admin II  證書課程):

  10 堂 / 30 小時 (每堂 3 小時)

開課日期:(OCP 11g full course  綜合課程)
 
   
OCP0929     09 月 29 日 (逢星期一、三, 7 - 10 p.m)

開課日期:(OCA 11g upgrade Oracle Database 11g: DB Admin II  證書課程)
 

OCP1110     11 月 10 日 (逢星期一、三, 7 - 10 p.m)  
 

課程費用:  原價 $ 18,125

*$ 11,800 (OCP 11g full course  綜合課程) 

*$ 9,980 (OCA 11g upgrade Oracle Database 11g: DB Admin II  證書課程)

9 月 15 日前報留位及報名

匯豐信用卡可享 12 個月免息分期
   OCP 11g full course  綜合課程 每月只須 $ 984  
   OCA 11g upgrade Oracle Database 11g: DB Admin II  證書課程 每月只須 $ 832
舊生或舊生介紹可享 95 折 優惠 (請預早致電留位時登記作實)

*舊生或舊生介紹優惠價 (請預早致電留位時登記作實)

 

完成本課程後可參加的相關考試:

(1Z0-051) Oracle Database 11g SQL Fundamentals 1
試題數量: 70 題
考試時間: 120 分鐘
合格分數: 60 %
模擬試題參考


(1Z0-052) Oracle Database 11g Administration 1
試題數量: 70 題
考試時間: 90 分鐘
合格分數: 66 %
模擬試題參考

 

(1Z0-053) Oracle Database 11g Administrator Certified Professional
試題數量: 78 題
考試時間: 120 分鐘
合格分數: 66 %
模擬試題參考


 

成功通過考試後獲得的國際認可證書及資格:

 


Oracle Database 11g Administrator Certified Professional
    課程內容:
Major on Backup / restore (60% topic), scheduling task, and ASM

Database Architecture and ASM
Describe Automatic Storage Management (ASM) 
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

Configuring for Recoverability

Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

Using the RMAN Recovery Catalog

Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog

Configuring Backup Specifications

Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Using RMAN to Create Backups

Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

Performing User-Managed Backup and Recovery

Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

Using RMAN to Perform Recovery

Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

Using RMAN to Duplicate a Database

Creating a duplicate database
Using a duplicate database

Performing Tablespace Point-in-Time Recovery

Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN

Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

Using Flashback Technology

Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction

Additional Flashback Operations

Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive

Diagnosing the Database

Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

Managing Memory

Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance

Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay

Space Management

Manage resumable space allocation 
Describe the concepts of transportable tablespaces and databases 
Reclaim wasted space from tables and indexes by using the segment shrink
    functionality

Managing Resources

Understand the database resource manager
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs 
Use job chains to perform a series of related tasks

Administering the Scheduler 

Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs

Globalizationr 

Customize language-dependent behavior for the database and individual sessions 
Working with database and NLS character sets