Oracle Certified Professional - DBA Certification Exam Guide

Jason Couchman (New York, NY) is an OCP-certified Oracle DBA and author of Oracle Certified Professional DBA Certification Exam Guide, Oracle Certified Professional Application Developer Exam Guide, Oracle Certified Professional DBO Certification Exam Guide, and Oracle8 Certified Professional DBA Practice Exams. He has led Oracle database projects with Fortune 500 corporations and presented topics at the North Carolina Oracle User Group. His articles on Internet and intranet development have been published internationally.

Unit I: Preparing for OCP DBA Exam I: SQL and PL/SQL. Selecting Data from Oracle. Advanced Data Selection in Oracle. Creating the Oracle Database. Creating Other Database Objects in Oracle. Introducing PL/SQL. Unit II: Preparing for OCP DBA Exam 2: Database Administration. Basics of the Oracle Database Architecture. Managing the Physical Database Structure. Managing Database Objects. Managing Database Usage. Using SQL*Loader. Unit III: Preparing for OCP DBA Exam 3: Backup and Recovery Workshop. Overview of Backup and Recovery. Logical Backup and Recovery. Physical Recovery Without Archiving. Backup and Recovery Options with Archiving. Advanced Topics of Oracle Backup and Recovery. Unit IV: Preparing for OCP DBA Exam 4: Performance Tuning Workshop. Introducing Database Tuning. Tuning Database Applications. Tuning Memory Utilization. Tuning Disk Utilization. Tuning Other Areas of the Oracle Database. Unit V: Preparing for OCP DBA Exam 5: Oracle8 Features for Administrators. Oracle8: Partitioning Tables and Indexes. Oracle8: New Features and Object Relation Design. Oracle8: Parallel DML, LOBs, and Advanced Queuing. Oracle8: Using Recovery Manager. Oracle8: Networking, Security, and Migration.