付款。(在家觀看 = 0%，在校觀看 = 100%)
100% 在校觀看日期及時間：
自由選擇，點選以下地區觀看辦公時間及位置
課時： 66 小時
享用時期： 22 星期。進度由您控制，可快可慢。
課堂錄影導師：Larry
在校免費試睇：首 3 小時，請致電以上地點與本中心職員預約。
本課程提供在校免費重睇及導師解答服務。
(在家觀看 = 100%，在校觀看 = 0%)
100% 在家觀看日期及時間：
每天 24 小時全天候不限次數地觀看
學費：$12,960 報名 phone
電話：2332-6544
課時： 66 小時
享用時期： 22 星期。進度由您控制，可快可慢。
課堂錄影導師：Larry
在校免費試睇：首 3 小時，請致電以上地點與本中心職員預約。
本課程提供導師解答服務。
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 認證了！
| 課程名稱： |
Oracle Database Administration Certified Professional (2科 19c OCP) 國際認可證書課程 - 簡稱：OCP Database 19c Training Course |
| 課程時數： | 合共 66 小時 (共 22 堂)，共 2 科 |
| 適合人士： | 對電腦網絡有基本認識 及 初學數據庫人士 |
| 授課語言： | 以廣東話為主，輔以英語 |
| 課程教材： | 本中心導師親自編寫英文為主筆記，而部份英文字附有中文對照 |
Oracle 已公佈考生必須通過以下 2 個 Oracle Database 19c 相關科目的考試，才可獲發 Oracle Database Administration 2019 Certified Professional 國際認可證書：
|
Oracle 已公佈自 2022 年 9 月 1 日起學員必需親自前往 https://education.oracle.com/buy-exam 購買以下 2 個科目的 "Oracle Exam Attempt" 並由 Oracle 親自向您提供考試服務。 第 1 科：考試編號 1Z0-082，考試費為 HK$1,899。 考試題目由 Oracle 傳送到你要應考的電腦，考試時以電腦作答。所有考試題目均為英文，而大多數的考試題目為選擇題。 考試合格後會收到來自 Oracle 的作實電郵，並進入該電郵內的連結，登入 https://certview.oracle.com 下載您的證書。 考試不合格便可於 5 日後重新報考，但 12 個月內最多只可以考 4 次。欲知道作答時間、題目總數、合格分數等詳細考試資料，可瀏覽本中心網頁"各科考試分數資料"。 |
|
課程名稱：Oracle Database Administration Certified Professional (2科 19c OCP) 國際認可證書課程 - 簡稱：OCP Database 19c Training Course |
1Z0-082 Oracle Database Administration I (36 hours)
1. Oracle Server Technologies and Relational Paradigm
1.1 Prerequisite knowledge to Oracle Servers
1.2 The Oracle Server Architecture
1.3 The Oracle Application Server
1.4 The Oracle Enterprise Manager
2. Deploying Oracle Database Server
2.1 Requirements for Oracle Database 19c
2.2 Computer (Virtual Machines) Requirement
2.3 Database Installation using Oracle Universal Installer on Windows Server
2.4 Database Installation using Oracle Universal Installer on Oracle Enterprise Linux Server
3. Oracle Database Management Consoles
3.1 Tools available to manage an Oracle Database Server
3.2 SQL*Plus
3.3 SQL Developer
3.4 Enterprise Manager: Database Control
4. Relational Data
4.1 Normalization
5. Demonstration Schema
5.1 Addressing the Demonstration Schema
5.2 Definition of a Database Schema
5.3 The HR and OE Schema
5.4 Enabling the HR and OE user
6. Data Retrieval Using the SQL SELECT Statement
6.1 The DESCRIBE table command
6.2 Describing the HR schema
6.3 Capabilities of SELECT Statement
6.4 Executing the SELECT Statement
7. Restricting and Sorting Data
7.1 Introduction
7.2 Limit the Rows Retrieved by a Query
7.3 Sort the Rows Retrieved by a Query
7.4 Ampersand Situation
8. Single Row Functions
8.1 Introduction to Single Row Functions
8.2 Describing Various Types of Functions Available in SQL
8.3 Types of Functions
8.4 Working with Dates
9. Using Conversion Functions and Conditional Expressions
9.1 Introduction
9.2 Describing Various Types of Conversion Functions Available in SQL
9.3 Using TO_CHAR, TO_NUMBER and TO_DATE
9.4 Apply Conditional Expressions in a SELECT Statement
10. Reporting Aggregated Data Using Group Functions
10.1 Introduction
10.2 Describe the Group Functions
10.3 Identify the Available Group Functions
10.4 Restrictions of using Nested Group Functions
10.5 Group Data Using the GROUP BY Clause
10.6 Include or Exclude Grouped Rows Using the HAVING Clause
11. Displaying Data From Multiple Tables
11.1 Introduction
11.2 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
11.3 Types of Joins
11.4 Natural Joins
11.5 Oracle Join Syntax
11.6 Joining Tables Using SQL:1999 Syntax
11.7 Qualifying Ambiguous Column Names (Optional Knowledge)
11.8 N-Way Joins and Additional Join Conditions
11.9 Nonequijoins (Optional Knowledge)
11.10 Join a Table to Itself Using a Self-Join (Optional Knowledge)
11.11 View Data That Does Not Meet a Join Condition by Using Outer Joins
11.12 Left Outer Join
11.13 Right Outer Join
11.14 Full Outer Join
11.15 Cross Join
12. Using Sub Queries to Solve Problems
12.1 Introduction
12.2 Define Subqueries
12.3 Describe the Types of Problem that Subqueries Can Solve
12.4 List the Types of Subqueries
12.5 Write Single-Row and Multiple-Row Subqueries
13. Using the Set Operator
13.1 Introduction
13.2 Describe the Set Operators
13.3 Set and Venn Diagram (Optional Knowledge)
13.4 Trying the Set Operators
13.5 Use a Set Operator to Combine Multiple Queries into a Single Query
13.6 General Principals of using Set Operators (Optional Knowledge)
13.7 More Complex Examples
14. Creating Schema Objects
14.1 Introduction
14.2 Create Simple and Complex Views
14.3 Reasons of using views
14.4 Simple and Complex Views
14.5 CREATE VIEW
14.6 Private and Public Synonyms
14.7 Sequences
15. Exploring the Oracle Database Architecture
15.1 Introduction
15.2 Description of a Single-Instance Architecture
15.3 Description of a Distributed System Architectures (Optional Knowledge)
15.4 Description of Memory Structures
15.5 Investigating the Memory Structures of the Instance
15.6 Description of Oracle Background Process Structures
15.7 Investigating the Processes Running in your instance
15.8 Summarize the Storage Structures
15.9 Logical Database Structures
15.10 Investigating the Storage Structures in your database
16. Creating an Oracle Database
16.1 Various tasks about Creating an Oracle Database
16.2 Using the Database Configuration Assistant (DBCA) to Create a Database
16.3 Scripts and Other Files Created by the DBCA
17. Managing the Oracle Instance
17.1 Introduction
17.2 Configuring EM Express for new instance
17.3 Managing the Oracle Listener
17.4 Database Startup and Shutdown
17.5 Set Database Initialization Parameters
17.6 Use the Alert Log and Trace Files
17.7 Using Data Dictionary and Dynamic Performance Views
18. Configuring the Oracle Network Environment
18.1 Introduction
18.2 Oracle Net and Communication Protocols
18.3 Creating a Listener
18.4 Techniques for Name Resolution
18.5 Database Registration
18.6 Database Link
19. Managing Database Storage Structures
19.1 Introduction
19.2 Identifying Oracle Storage Structures
19.3 Managing Tablespaces
19.4 The Oracle Data Block format
19.5 Managing Datafiles
20. Administering User Security
20.1 Database User Account
20.2 Choosing Authentication Methods
20.3 Choosing a Default Tablespace
20.4 Choosing a Temporary Tablespace
20.5 Choosing a Profile for a User
20.6 Creating a database user
20.7 About Database Schema
20.8 Granting and Revoking Privileges
20.9 Roles
20.10 Controlling Access to Applications by Secured Application Role
20.11 Quotas
20.12 Data Dictionary Views (Optional Knowledge)
21. Implementing Oracle Database Security
21.1 Introduction
21.2 Database Security and Principle of Least Privilege
21.3 PUBLIC privileges
21.4 Security-Critical Instance Parameters
21.5 Working with Traditional Database Auditing
22. Unified Auditing
22.1 Introduction to Oracle Database Unified Auditing
22.2 Implementing Mixed Auditing Mode
22.3 Implementing Unified Auditing
22.4 Creating Unified Audit Policy for Datapump example
22.5 Auditing RMAN
22.6 Cleaning up Audit Data
23. Real-Time Database Operation Monitoring
23.1 Monitoring in previous generations vs 19c
23.2 Definition of Database Operation
23.3 Control_Management_Pack_Access
23.4 Using Database Operation Monitoring
23.5 Emergency Monitoring and Real-Time ADDM
23.6 End-To-End Application Tracing
24. Managing Undo Data
24.1 Purpose of Undo Data
24.2 Compatibility of Undo Data
24.3 Understanding How Transactions Generate Undo
24.4 Work with Transactions and Flashback query
24.5 Managing Undo
24.6 Computing the Minimum Undo Tablespace Size Using the Undo Advisor
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 認證的本中心部份學員名單：
......由於人數眾多，因此未能盡錄。 |