OCP Database Training Course (Upgrade to 19c) Training 課程
  Facebook: OCP Database Training Course (Upgrade to 19c) Training 課程
 
OCP Database Training Course (Upgrade to 19c) Training 課程
OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程  
OCP Database Training Course (Upgrade to 19c) Training 課程 OCP Database Training Course (Upgrade to 19c) Training 課程

想定期知道最新課程及優惠嗎?
免費訂閱本中心的課程通訊!

課堂錄影隨時睇 10 大優點之時間自由:無論您是夜班或輪班工作,在日間或晚間亦可隨時來上課!而視像會在您到達時才開始播放,亦可按您需要而隨時暫停,不會因遲到或人有三急而錯過課程任何重點!

升級至 OCP: Database 19c (只教1科 Oracle Database 19c 1Z0-083) 國際認可證書課程
課程簡稱:OCP Database Training Course (Upgrade to 19c)

  • 課程時間
  • 課程簡介
  • 課程特點
  • 認證要求
  • 考試須知
  • 課程內容
  • 成功學員

推介服務:課堂錄影隨時睇 (在家觀看 = 0%,在校觀看 = 100%)
學員使用電話或本網頁報名,待本中心確認已為學員留位後,即可使用 轉數快 繳付學費,過程簡便!
編號 地點 可預約星期及時間 學費低至 85 折  
TW2403MV 旺角 一至五:14:30 - 22:15   六:13:45 - 21:30   日:10:15 - 18:00 (公眾假期休息) 95 折後只需 $6,631 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
TW2403OV 觀塘 一至五:14:15 - 22:00   六及日:12:15 - 20:00   (星期三及公眾假期休息) 9 折後只需 $6,282 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
TW2403PV 北角 一至五:14:15 - 22:00   六及日:12:15 - 20:00   (星期三及公眾假期休息) 9 折後只需 $6,282 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
TW2403SV 沙田 一至五:14:15 - 22:00   六及日:12:15 - 20:00   (星期三及公眾假期休息) 85 折後只需 $5,933 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
TW2403YV 屯門 一至五:14:15 - 22:00   六及日:12:15 - 20:00   (星期一、三及公眾假期休息) 85 折後只需 $5,933 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
* 各政府部門可使用 P Card 付款  
如使用 P Card 繳付考試費,考試費需另加 1.3% 附加費  
在校免費試睇: 首 3 小時,請致電與本中心職員預約。 查看各地點電話
旺角 2332-6544
觀塘 3563-8425
北角 3580-1893
沙田 2151-9360
屯門 3523-1560
在校免費重睇: 學員可於享用時期內於報讀地點不限次數地重看課堂錄影,從而可反覆重溫整個課程!
導師解答: 學員可於觀看某一課堂錄影後提出課堂直接相關的問題,課程導師會樂意為學員以單對單的形式解答!
課時: 30 小時
享用時期: 10 星期 (可於報讀日至 4 星期內觀看整個課程,另加 6 星期備用時期)。進度由您控制,可快可慢。
課堂錄影導師: Larry (任教課程清單)
在校觀看: 詳情及示範片段


推介服務:課堂錄影隨時睇 (在家觀看 = 100%,在校觀看 = 0%)
學員使用電話或本網頁報名,待本中心確認已為學員留位後,即可使用 轉數快 繳付學費,過程簡便!
編號 地點 星期及時間 費用  
TW2403HH 在家 享用時期內每星期 7 天 (包括公眾假期),每天 24 小時全天候不限次數地觀看。 $6,980 按此報名:OCP Database Training Course (Upgrade to 19c) Training 課程
* 各政府部門可使用 P Card 付款  
如使用 P Card 繳付考試費,考試費需另加 1.3% 附加費  
在校免費試睇: 首 3 小時,請致電與本中心職員預約。 查看各地點電話
旺角 2332-6544
觀塘 3563-8425
北角 3580-1893
沙田 2151-9360
屯門 3523-1560
導師解答: 學員可於觀看某一課堂錄影後提出課堂直接相關的問題,課程導師會樂意為學員以單對單的形式解答!
課時: 30 小時
在家觀看時禁用程式: 一些危害課堂錄影版權的程式。
享用時期: 10 星期 (可於報讀日至 4 星期內觀看整個課程,另加 6 星期備用時期)。進度由您控制,可快可慢。
課堂錄影導師: Larry (任教課程清單)
在家觀看: 服務條款及守則、報讀程序及示範片段


地區 地址 電話 教育局註冊編號
旺角 九龍旺角亞皆老街 109 號,皆旺商業大廈 18 樓 1802 - 1807 室 2332-6544 533459
觀塘 九龍觀塘成業街 7 號寧晉中心 12 樓 G2 室 3563-8425 588571
北角 香港北角馬寶道 41-47 號華寶商業大廈 3 樓 01-02 號舖 3580-1893 591262
沙田 新界沙田石門安群街 3 號京瑞廣場 1 期 10 樓 M 室 2151-9360 604488
屯門 新界屯門屯喜路 2 號屯門柏麗廣場 17 樓 1708 室 3523-1560 592552
注意! 客戶必須查問報讀學校的教育局註冊編號,以確認該校為註冊學校,以免蒙受不必要的損失!


Oracle 是全球最大的數據庫管理軟件生產商之一,在美國 NASDAQ 市值 1788 億美元 (約 13,951 億港元),Oracle 2018/19 年度結算總營業額達 513 億美元,純利達 226 億美元。它推出的數據庫軟件有強大的穩定性和擴展能力,所以全球的各大企業、銀行、大學和政府機構,無一不採用 Oracle 的產品。而本課程將教授 Oracle Database 19c 的管理、規劃、調節及修復。

為了能證明你有專業水準來管理、規劃、調節及修復 Oracle Database,Oracle 便推出其 Oracle Database Administration 2019 Certified Professional (19c OCP) 國際認可考試。而本課程籌備多時,精心編排,由上堂、溫習、實習、考試研習、做試題至最後考試,均為你度身訂造,作出有系統的編排。務求真正教識你,又令你考試及格。


自從 2019 年起,Oracle Database Administration 認證只有一個級別:

  • Oracle Certified Professional (OCP):
    OCP 是 Oracle Database Administration 的專業級認證,大多數 DBA (DataBase Administrator) 都以此證書為修讀 Oracle Database 的終極目標。透過學習並考取 OCP 的過程來加深對 Oracle Database 管理的認識及實力,用以應付高端的數據處理工作需求。


Oracle Certified Professional (OCP) 常被外國知名 I.T. 網站如 CRN / CertMag 等評為十大優質與高回報的 I.T. 認證之一,而本地的僱主也更願意花費更高的薪金去僱用擁有 OCP 資格的專業人士去管理維繫公司核心業務的 Oracle Database 伺服器。
"Only OCP has a complete core DBA skill set." by Oracle

資料來源:
https://www.oracle.com/a/ocom/docs/dc/ww-ou-5297-database2019-faq-3.pdf


請留意,從 19c 版本的 Oracle Database 起,Oracle 便不會再簽發入門級的 OCA 認證!若你對 OCA 認證有興趣,請前往本中心的 OCA 12c 課程網頁 https://www.systematic.com.hk/oca.htm

課程名稱: 升級至 OCP: Database 19c (只教1科 Oracle Database 19c 1Z0-083) 國際認可證書課程
- 簡稱:OCP Database Training Course (Upgrade to 19c)
課程時數: 合共 30 小時 (共 10 堂),共 1 科
適合人士:

已考取以下任何一張證書人士

  • Oracle Database 10g Certified Associate (OCA10g)
  • Oracle Database 11g Certified Associate (OCA11g)
  • Oracle Database 12c Certified Associate (OCA12c)
  • Oracle Database 10g Administrator Certified Professional (OCP10g)
  • Oracle Database 11g Administrator Certified Professional (OCP11g)
  • Oracle Database 12c Administrator Certified Professional (OCP12c)
授課語言: 以廣東話為主,輔以英語
課程教材: 本中心導師親自編寫英文為主筆記,而部份英文字附有中文對照

1.模擬考試題目: 本中心為學員提供模擬考試題目,每條考試題目均附有標準答案。
2.導師親自編寫筆記: 由本中心導師親自編寫筆記,絕對適合考試及實際管理之用,令你無須「死鋤」如字典般厚及不適合香港讀書格調的書本。
3. 一人一機上課: 本課程以一人一機模式上課。
4. 免費重讀: 傳統課堂學員可於課程結束後三個月內免費重看課堂錄影。

Oracle 已公佈以下任何一張認證持有人必須通過 1 個 Oracle Database 19c 相關科目 (1Z0-083) 的考試,才可獲發 Oracle Database Administration 2019 Certified Professional 國際認可證書:

    • Oracle Database 10g Certified Associate (OCA10g)
    • Oracle Database 11g Certified Associate (OCA11g)
    • Oracle Database 12c Certified Associate (OCA12c)
    • Oracle Database 10g Administrator Certified Professional (OCP10g)
    • Oracle Database 11g Administrator Certified Professional (OCP11g)
    • Oracle Database 12c Administrator Certified Professional (OCP12c)

    考試編號 科目名稱
    1Z0-083 Oracle Database Administration II



Oracle 已公佈自 2022 年 9 月 1 日起學員必需親自前往 https://education.oracle.com/buy-exam 購買以下 1 個科目的 "Oracle Exam Attempt" 並由 Oracle 親自向您提供考試服務。

考試編號 1Z0-083,考試費為 HK$1,898。

考試題目由 Oracle 傳送到你要應考的電腦,考試時以電腦作答。所有考試題目均為英文,而大多數的考試題目為選擇題。

考試合格後會收到來自 Oracle 的作實電郵,並進入該電郵內的連結,登入 https://certview.oracle.com 下載您的證書。

考試不合格便可於5日後重新報考,不限次數。欲知道作答時間、題目總數、合格分數等詳細考試資料,可瀏覽本中心網頁"各科考試分數資料"。





課程名稱:升級至 OCP: Database 19c (只教1科 Oracle Database 19c 1Z0-083) 國際認可證書課程
- 簡稱:OCP Database Training Course (Upgrade to 19c)

1Z0-083 Oracle Database Administration II (30 hours)

1. Backup and Recovery Concepts
1.1 Introduction
1.2 Understanding and Configuring Recovery Components
1.2.1 Multiplexing Control Files
1.2.2 Backing Up Control Files
1.3 Understanding Checkpoints
1.4 Redo Log Files
1.4.1 Redo Log File Architecture
1.4.2 Log Switch Operations
1.4.3 Clearing Online Redo Log Files
1.4.4 Archived Redo Log Files
1.4.5 Archived Redo Log File Architecture
1.4.6 Setting the Archive Destination
1.4.7 Enabling ARCHIVELOG
1.5 The Fast Recovery Area
1.5.1 Fast Recovery Area Occupants
1.5.2 The Fast Recovery Area and SQL Commands
1.5.3 The Fast Recovery Area and the Enterprise Manager Cloud Control
1.5.4 Fast Recovery Area Management
1.6 Database Backup and Recovery Plan
1.7 Recovery Manager

2. Performing Database Backup and Disaster Recovery
2.1 Configuring RMAN for backup
2.2 Performing Disaster Recovery using Data Recover Advisor
2.2.1 Restore and Recover
2.2.2 Overview of the Data Recovery Advisor
2.2.3 Performing a cross check on backup media
2.2.4 Recovering a lost Control File
2.2.5 Recovering a lost Data File in NOARCHIVELOG mode
2.2.6 Recovering a lost Data File in ARCHIVELOG mode
2.2.7 Capabilities and Limitations of DRA
2.3 Scheduling Oracle Suggested Backup plan
2.4 Performing Point-in-time recovery of database

3. Multitenant Database Architecture
3.1 Introduction to Multitenant Database Architecture
3.2 More about Multitenant Container Database
3.3 The Root Container, Seed Container and Pluggable Container
3.3.1 About the Root Container
3.3.2 Various Container types
3.3.3 PDB Metadata
3.3.4 Managing the CDB and PDB
3.4 Instance and Storage Organization of Containers
3.4.1 Common entities of CDB and PDBs
3.4.2 Contents exclusive available only at PDB
3.5 Types of Containers during CDB and PDB initialization
3.5.1 About Root Container initialization
3.5.2 About Pluggable Database Containers initialization

4. Configuring and Managing Multitenant Databases
4.1 Creating a Container Database (CDB)
4.2 Creating and Configuration a PDB
4.2.1 Creating Pluggable Database by using the Seed database
4.2.2 More about file location of Pluggable Databases
4.3 Status and Open Mode of a Pluggable Database
4.4 Unplugging and Plugging a Pluggable Database
4.5 Cloning a Pluggable Database from another Pluggable Database
4.6 Plugging a Normal 19c Non-CDB into a CDB

5. RMAN Backup and Recovery for Multitenant Architecture
5.1 Backup and Recover PDBs and CDB
5.1.1 Performing Database backup on CDB
5.1.2 Backup the Root Container only
5.1.3 Backup Pluggable Database from the Root Container
5.1.4 Backup Pluggable Database from the Pluggable container
5.1.5 Backing Up Archived Redo Logs
5.2 Restoring a Tablespace in a Pluggable Database
5.3 Recovering Temporary Tablespace on CDB or PDBs
5.4 Recovering SYSAUX tablespace of the Root Container
5.5 Instance Recovery of lost Control Files
5.6 More about Point In Time Recovery (PITR) of PDB tablespaces

6. Managing Users, Roles and Privileges for Multitenant Architecture
6.1 Local Users and Common Users
6.2 Local Roles and Common Roles
6.3 Creating Local User in a PDB
6.4 Creating Common Users
6.5 Managing Privileges in a Multitenant Architecture
6.5.1 Granting a Local Privilege of a PDB to a Local User
6.5.2 Granting a Local Privilege of Root Container to a Common User
6.5.3 Granting a Common Privilege to a Common User
6.6 Managing Roles in a Multitenant Architecture

7. Core Concepts of the Oracle Database 19c Recovery Manager (RMAN)
7.1 Oracle DBA Tools for Backup and Recovery
7.2 Connecting to Oracle Recovery Manager (RMAN)
7.3 Quick Start: A Problem-Solution Approach
7.4 Configuring for Recoverability
7.4.1 Types of RMAN Commands
7.4.2 Configure Persistent Settings for RMAN

8. Configure RMAN Retention Policy
8.1 Understanding RMAN Retention Policy
8.2 Using Fast Recovery Area (FRA)
8.3 Multiplexing Control Files and Auto backup
8.4 Multiplexing Redo Log Files
8.5 Creating Archived Redo Log files
8.6 Using RMAN Recovery Catalog

9. Configuring Recovery Catalog Database
9.1 Preparing the Recovery Catalog Database
9.2 Managing Target Database Records in the Recovery Catalog
9.3 Using RMAN Stored Scripts
9.4 Maintaining and Protecting the Recovery Catalog
9.5 Virtual Private Catalogs

10. Backup Strategies and Terminology
10.1 Backup Solutions Overview and Terminology
10.2 Balancing Backup and Restore Requirements
10.3 Backing Up Read-Only Tablespaces
10.4 Best Practices for Data Warehouse Backups
10.5 Additional Backup Terminology

11. Performing Backups
11.1 RMAN Backup Types
11.2 Incrementally Updated Backups
11.3 Fast Incremental Backup
11.4 Block Change Tracking
11.5 Oracle-Suggested Backup
11.6 Reporting on Backups
11.7 Managing Backups

12. Improving Your Backups
12.1 Compressing Backups
12.2 Using a Media Manager (Optional Knowledge)
12.3 Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
12.4 Creating and Managing Archival Backups
12.5 Backing Up Recovery Files
12.6 Backing Up the Control File to a Trace File
12.7 Cataloging Additional Backup Files
12.8 Backing Up ASM Disk Group Metadata (Optional Knowledge)

13. RMAN-Encrypted Backups
13.1 Creating RMAN-Encrypted Backups
13.2 Using Transparent-Mode Encryption
13.3 Using Password-Mode Encryption
13.4 Using Dual-Mode Encryption
13.5 Considerations for RMAN-Encrypted Backups
13.6 Considerations for Restoring from Encrypted Backups

14. Diagnosing Database Failures
14.1 Reducing Problem Diagnosis Time
14.2 Automatic Diagnostic Repository
14.3 Interpreting RMAN Message Output and Error Stacks
14.4 Data Recovery Advisor
14.5 Handling Block Corruption

15. Restore and Recovery Concepts
15.1 Understanding File Loss and Data Repair Techniques
15.2 Instance Failure and Instance/Crash Recovery
15.3 Media Failure
15.4 An Overview of Complete Recovery
15.5 An Overview of Point-in-Time Recovery
15.6 Recovery Through RESETLOGS

16. Performing Recovery
16.1 Ensuring Backup media availability
16.2 RMAN Recovery in NOARCHIVELOG Mode (Optional knowledge)
16.3 Performing Complete Recovery (of critical and noncritical data files)
16.4 Restoring ASM Disk Groups
16.5 Recovery with Image Files
16.6 Restore Points
16.7 Performing Point-in-Time (PITR) or Incomplete Recovery

17. Flashback Technologies
17.1 Introduction to Oracle Flashback Technologies
17.1.1 Flashback Technologies Error Detection and Correction
17.1.2 Transactions and Undo
17.1.3 7 Flashback Technologies for different purposes
17.1.4 Preparing your Database for Flashback
17.2 Using Flashback Technology to Query Data
17.2.1 Flashback Query
17.2.2 Flashback Version Query
17.2.3 Flashback Table
17.3 Flashback Transaction (Query and Backout)
17.4 Flashback Drop and the Recycle Bin
17.5 Flashback Data Archive
17.6 Flashback Database Architecture
17.7 Configuring Flashback Database
17.8 Performing Flashback Database
17.9 Best Practices for Flashback Database

The course content above may change at any time without notice in order to better reflect the content of the examination.

 



以下是最近成功取得 OCP 認證的本中心部份學員名單:

  • Cao Siu Kwong
  • Chan Kit Man
  • Chan Lok Man
  • Chan Sin Keung
  • Cheung Fu Wing
  • Cheung Wai Leung
  • Cheung Wing Chiu
  • Choi Chin Ching
  • Choy Chi Fai
  • Chu Wing Tat
  • Chung Tak Wa
  • Feng Haobin
  • Fong Wai Wah
  • Ho Kwan Ho
  • Ho Pak Hei
  • Hung Ka Kam
  • Ko Hung Chi
  • Kong Tak Fung
  • Ku Man Wah
  • Lai Ka Chun
  • Lai Yiu Ming
  • Lam Chung Wai
  • Lau Hon Cheong
  • Lau Kin Pong
  • Lau King Sum
  • Lau Wai Ho
  • Lau Wing Tai
  • Law Wai Kit
  • Law Wai Kwong
  • Lee Chi Wai
  • Leung Hi Yung
  • Leung Ho Sum
  • Leung Wing Tat
  • Lo Tai Wai
  • Ng Shek Kei
  • Ng Wai Ying
  • Ng Yick Bun
  • Ngan Chun Yu
  • Pang Wai Hon
  • Poon Chun To
  • See Kwok Leung
  • Shek Kin Yu
  • Tam Kin Sang
  • Tam Siu Yun
  • Tang Chi Ming
  • Tang Ho Wing
  • Tong Kwan Ho
  • Tse Chung Kei
  • Wai Ho Cheong
  • Wong Ho Yin
  • Wong Hung Bun
  • Wong Leung Shing
  • Wong Tak Kei
  • Wong Ting Kit
  • Wong Wai Tong
  • Wu Ping Kee
  • Yeung Kam Lung
  • Yuen Wai Kit

......由於人數眾多,因此未能盡錄。




課堂錄影隨時睇 10 大優點之導師解答:您可於觀看某一課堂視像後提出相關問題,課程導師會樂意為學員以單對單的形式解答!

更多綜合課程
  攝影課程
  • 攝影初級
  • 攝影中級 (風景專題)
  英文課程
  • IPA 拼音:級別 1 2 3 4
  普通話課程
  • 基礎普通話拼音 (免費)
  • 進階普通話拼音
  • 普通話會話:級別 1 2 3
  西班牙語文課程
  • 級別 1 2 3
  中醫課程
  • 濕疹與皮膚敏感病
  • 暗瘡與色斑 | 鼻敏感與感冒
  • 脫髮與白髮 | 從五官看健康
  風水命理課程
  • 紫微斗數:級別 1 2 3
  • 子平八字:級別 1 2 3
  • 八字風水:級別 1 2 3
  • 奇門遁甲:級別 1 2 3