Oracle8i 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. Ulrike Schwinn (Munich, Germany) works for Oracle Deustchland and is a curriculum content provider who creates the certification test exams.

Unit I: Preparing for OCP DBA Exam I: SQL and PL/SQL. Chapter 1: Selecting Data from Oracle. Chapter 2: Avanced Data Selection in Oracle. Chapter 3: Creating Oracle Database Objects. Chapter 4: Creating Other Database Objects in Oracle. Chapter 5: Introducing PL/SQL. Unit II: Preparing for OCP DBA Exam 2: Database Administration. Chapter 6: Basics of the Oracle Database Architecture. Chapter 7: Managing the Physical Database Structure. Chapter 8: Managing Database Objects I. Chapter 9: Managing Database Objects II. Chapter 10: Managing Database Use. Chapter 11: Data Loads and National Language Support. Unit III: Preparing for OCP DBA Exam 3: Backup and Recovery Workshop. Chapter 12: Overview of Backup and Recovery. Chapter 13: Database Failure and Recovery. Chapter 14: Topics in Data Recovery. Chapter 15: Using Recovery Manager for Backups. Unit IV: Preparing for OCP DBA Exam 4: Performance Tuning Workshop. Chapter 16: Introducing Database Tuning. Chapter 17: Tuning Oracle Memory Usage. Chapter 18: Tuning Disk Utilization. Chapter 19: Tuning Database Applications. Chapter 20: Tuning Other Areas of the Oracle Database. Unit V: Preparing for OCP Exam 5: Network Administraton. Chapter 21: Overview of Net8 for Client and Server. Chapter 22: Oracle Names on MTS. Chapter 23: Connection Manager, Troubleshooting, and Security.