在數據庫系統領域上，為人熟悉的甲骨文 (Oracle Corp) 當然少不了，Oracle 是全世界最大的數據庫系統生產商之一。而最新推出的數據庫系統軟件 Oracle Database 10g 擁有很強的穩定性和擴展能力，所以獲得全球很多大企業的廣泛應用，因此也令到 Oracle 所頒發的專業證書，成為一項專業技術的權威代表。 Oracle Database 10g 跟之前的版本一樣，除了延續 Oracle 9i 強大的功能之外，還加入許多革命性的資料處理技術，其目的在於成為網路應用以及電子商務的最佳資料庫平台，亦是企業最理想的數據管理方案，因為它功能齊全，容易安裝及配置，而且還配備最新的自我管理功能，能減少管理人員的繁瑣工作量，加上 Oracle 的數據庫系統是業界公認且擁有優質卓越性能，可靠性及安全性大大提高。
我們最新推出的 Oracle OCA 10g 課程由擁有多年數據庫管理經驗之導師任教，能幫助您學識安裝、管理及操作 Oracle Database 10g 系統外，更幫助您考取 OCA 專業證書。課程中已還包括 Oracle 10g OCA 筆記課本，以及最新的模擬試題，讓同學準備充足應付考試。

Oracle 10g Certified Database Associate  考試科目

(1Z0-042) Oracle Database 10g Administration Part 1    保證合格 !!

適合人仕 : - 數據庫管理人員 - 系統管理人員 - 資訊科技部門主管 - 對 Database 管理有興趣的人仕 修讀條件 : 對 Windows Server 系統有基本操作經驗 對網絡系統的運作有基本概念 課程包括 : - Oracle Database 10g 筆記課本 - Oracle Database 10g 試用版 CD-ROM - Oracle 10g OCA 精讀筆記全套 - 每月更新 的模擬試題連參考答案 (170 多條) - (模擬試題 "半年" 免費更新保證，考試更有彈性) - 由擁有多年數據庫管理經驗之導師任教

授課語言 :     以廣東話授課為主，亦會以英語輔助。


課程全長 :     8 堂 / 24 小時 (每堂 3 小時)


開課日期 :     OCA0927           09 月 27 日 (逢星期六， 7 - 10 p.m)    最後 1 位
                    OCA1018           10 月 18 日 (逢星期六， 7 - 10 p.m)    最後 5 位            
                                                                     

課程費用 :     原價 $2,380   特價 $ 1,980 (只限9月)
                 匯豐信用卡分期 $ 198 x 12 個月
　

(同學如 OCA 考試不合格的話，可免費重考一次)

現在報讀可額外獲得以下電子書作考試及温習參考之用

      

Sybex OCA 10g Study Guide Sample Chapter

Chapter 1: Oracle Database 10g Components and Architecture (PDF, 2.15MB)


Exam 1z0-042: Oracle Database 10g Administration Part 1 模擬試題


課程內容 :

1Z0-042: Oracle Database 10g Administration

Chapter 1
Introducing Oracle, briefly describes the range of Oracle products and provides some history of Oracle and relational databases.

Section 1.1. The Evolution of the Relational Database 
Section 1.2. The Oracle Family 
Section 1.3. Summary of Oracle Features 
Section 1.4. Database Application Development Features 
Section 1.5. Database Connection Features 
Section 1.6. Distributed Database Features 
Section 1.7. Data Movement Features 
Section 1.8. Performance Features 
Section 1.9. Database Management Features 
Section 1.10. Oracle Developer Suite 
Section 1.11. Oracle Lite

Chapter 2
Oracle Architecture, describes the core concepts and structures (e.g., files, processes, and so on) that are the architectural basis of Oracle8.

Section 2.1. Instances and Databases 
Section 2.2. The Components of a Database 
Section 2.3. The Components of an Instance 
Section 2.4. The Data Dictionary

Chapter 3
Installing and Running Oracle, briefly describes how to install Oracle and how to configure, start up, and shut down the database. It also covers a variety of networking issues.

Section 3.1. Installing Oracle 
Section 3.2. Creating a Database 
Section 3.3. Configuring Oracle Net 
Section 3.4. Starting Up the Database 
Section 3.5. Shutting Down the Database 
Section 3.6. Accessing a Database 
Section 3.7. Oracle at Work

Chapter 4
Data Structures, summarizes the various datatypes supported by Oracle and introduces the Oracle objects (e.g., tables, views, indexes). It also provides information about query optimization.

Section 4.1. Datatypes Section 4.2. Basic Data Structures
Section 4.3. Additional Data Structures 
Section 4.4. Data Design 
Section 4.5. Constraints 
Section 4.6. Triggers 
Section 4.7. Query Optimization 
Section 4.8. Understanding the Execution Plan 
Section 4.9. SQL Tuning Advisor 
Section 4.10. Data Dictionary Tables

Chapter 5
Managing Oracle, provides an overview of issues involved in managing an Oracle system, including security, using the Oracle Enterprise Manager (EM) product, and dealing with database fragmentation and reorganization issues.

Section 5.1. Management and Enterprise Manager 
Section 5.2. Oracle Database 10g Self-Tuning and Management 
Section 5.3. Implementing Security 
Section 5.4. Fragmentation and Reorganization 
Section 5.5. Backup and Recovery 
Section 5.6. Working with Oracle Support

Chapter 6
Oracle Performance, describes the main issues relevant to Oracle performance especially the major performance characteristics of disk, memory, and CPU tuning and pays special attention to parallelism in Oracle.

Section 6.1. Performance Tuning Basics 
Section 6.2. Oracle and Disk I/O Resources 
Section 6.3. Oracle and Parallelism 
Section 6.4. Oracle and Memory Resources 
Section 6.5. Oracle and CPU Resources 
Section 6.6. Database Resource Manager 
Section 6.7. Monitoring 
Section 6.8. Real Application Clusters and Performance

Chapter 7
Multiuser Concurrency, describes the basic principles of multiuser concurrency (e.g., transactions, locks, integrity problems) and explains how Oracle handles concurrency.

Section 7.1. Basics of Concurrent Access 
Section 7.2. Oracle and Concurrent User Access 
Section 7.3. Oracle's Isolation Levels 
Section 7.4. Oracle Concurrency Features 
Section 7.5. How Oracle Handles Locking 
Section 7.6. Concurrent Access and Performance 
Section 7.7. Workspaces

Chapter 8
Oracle and Transaction Processing, describes online transaction processing (OLTP) in Oracle.

Section 8.1. OLTP Basics 
Section 8.2. Oracle's OLTP Heritage 
Section 8.3. Architectures for OLTP 
Section 8.4. Oracle Features for OLTP 
Section 8.5. High Availability 
Section 8.6. Oracle Advanced Queuing and Streams 
Section 8.7. Object Technologies and Distributed Components

Chapter 9
Oracle and Data Warehousing, describes the basic principles of data warehouses and business intelligence configurations and how you can use Oracle to build such systems.

Section 9.1. Business Intelligence Basics 
Section 9.2. Data Warehouse Design 
Section 9.3. Query Optimization 
Section 9.4. Analytics, OLAP, and Data Mining in the Database 
Section 9.5. Managing the Data Warehouse 
Section 9.6. Other Data Warehouse Software 
Section 9.7. The Metadata Challenge 
Section 9.8. Best Practices

Chapter 10
Oracle and High Availability, discusses Oracle's backup and recovery facilities, including the latest failover and data-redundancy solutions.

Section 10.1. What Is High Availability? 
Section 10.2. System Crashes 
Section 10.3. Protecting Against System Crashes 
Section 10.4. Recovering from Disasters 
Section 10.5. Complete Site Failure 
Section 10.6. Data Redundancy Solutions

Chapter 11
Oracle and Hardware Architecture, describes how the choice of various types of architectures (e.g., uniprocessor, SMP, MPP, NUMA, grid computing) affects Oracle processing.

Section 11.1. System Basics 
Section 11.2. Uniprocessor Systems 
Section 11.3. Symmetric Multiprocessing Systems 
Section 11.4. Clusters 
Section 11.5. Massively Parallel Processing Systems 
Section 11.6. Non-Uniform Memory Access Systems 
Section 11.7. Grid Computing 
Section 11.8. Disk Technology 
Section 11.9. Which Platform Deployment Solution?

Chapter 12 
Distributed Databases and Distributed Data, briefly summarizes the Oracle facilities used in distributed processing—for example, two-phase commits and Oracle Streams (Advanced Queuing).

Section 12.1. Accessing Multiple Databases as a Single Entity 
Section 12.2. Two-Phase Commits 
Section 12.3. Moving Data Between Distributed Systems 
Section 12.4. Advanced Queuing 
Section 12.5. Oracle Streams

Chapter 13
Extending Oracle Datatypes, discusses how Oracle provides object-orientation and support of various media type extensions to the Oracle datatypes and to the overall processing framework.

Section 13.1. Object-Oriented Development 
Section 13.2. Extensibility Features and Options 
Section 13.3. Using the Extensibility Framework in Oracle

Chapter 14
Network Deployment Models, describes how Oracle is now being used as an Internet computing platform and for grid computing, and introduces various web-related components, such as Oracle Application Server, Oracle Portal, and Java.

Section 14.1. The Impact of the Internet 
Section 14.2. The Oracle Database and the Internet 
Section 14.3. Oracle Application Server 
Section 14.4. Grid Computing