OCP Training Guide

NOTE: (Chapters conclude with Exercises, Review Questions, and Anwers to Review Questions.)

Introduction.


Who Should Read This Book. How This Book Helps You. Understanding What the OCP Database Administration Track Covers. Hardware and Software Needed. Tips for the Exam. New Riders Publishing.

I. SQL AND PL/SQL.

1. Introduction to SQL.


Introduction. Tables and Columns. SQL Grammar. The INSERT Statement. The UPDATE Statement. The DELETE Statement. Working with Dates. The Oracle Optimizer.

2. PL/SQL Language Structure.


Introduction. Reserved Words. Modular Top-Down Design Syntax. Identifiers and Variable Declarations. Executable Statements. More on Exception Handling. SQL Within PL/SQL. Conditional Statements. Unconditional Statements. Iterative Statements. Getting Output.

3. PL/SQL in Use.


Introduction. Subprograms, Procedures, and Functions. Stored Subprograms. Packages.

4. Security.


Introduction. Users. Roles. Privileges. System Resource Limits. Real-World Problems. Database Administrator (DBA) Authentication. Auditing Database Activity.

II. ORACLE DATABASE ADMINISTRATION.

5. Oracle Database Architecture.


Introduction. Memory Structures. Oracle Background Processes. Characteristics of an Oracle Instance. Oracle's External Files. Transaction Processing. Creating a Database. Multithreaded Server (MTS).

6. Managing Database Structures.


Introduction. Oracle Structure Fundamentals. Managing Database Structures. Working with Tablespace Reports. Managing Storage Allocation. Managing Table and Index Segments. Working with Database Indexes. Managing Cluster Segments. Managing Constraints. Managing Rollback Segments.

7. Utilities.


Introduction. What You Can Do with SQL*Loader. Using Oracle's Export Utility. Recovering from a Logical Backup with Oracle's Import Utility.

III. BACKUP AND RECOVERY.

8. Backing Up a Database.


Introduction. Why Back Up a Database?. Backing Up to Another Device.

9. Database Recovery.


Introduction. Some Common Errors and Failures. Explanations of Structures. Data Files. Control Files. Redo Logs. Key Recovery Principles. Checkpoints. Database Recovery Options.

IV. TUNING.

10. Database Tuning.


Introduction. Optimal Configuration. Reducing Contentions. Disk (I/O) Contention. Database Design. Application Performance Design and Database Objects.

11. Tuning Memory Structures.


Introduction. Tuning Applications. Tuning the Shared Pool. Tuning the Buffer Cache. Tuning Redo Logs. Tuning Rollback Segments. Tuning Sorts. Monitoring Databases.

APPENDIXES.

Appendix A. Glossary.
Appendix B. Overview of the Certification Process.
Appendix C. Study Tips.


Pretesting Yourself. Hints and Tips for Doing Your Best on the Tests.

Appendix D. What's on the CD-ROM.


Top Score. Copyright Information and Disclaimer.

Appendix E. All About Top Score.


Scoring.

Index.