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.