Oracle8i DBA: SQL and PL/SQL Certification Bible

Oracle8i DBA: SQL and PL/SQL Certification Bible brings you comprehensive coverage of the exam objectives, presented according to the Oracle certification guide. Because Oracle's exam scoring provides section scores according to the exact objectives, each exam objective is covered in its own chapter complete with self-assessment opportunities. Four appendices include a listing and description of the Oracle initialization parameters and other elements that will be tested on the exam. These appendices will provide information useful post-exam in real-work implementation of the Oracle systems.

Covers: Exam 1Z0-001

Table of Contents

Preface.

Acknowledgments.

PART I: The Oracle SQL Language.

Chapter 1: The Oracle Database.

Chapter 2: Retrieving Data Using Basic SQL Statements.

Chapter 3: Using Single- and Multi-Row Functions.

Chapter 4: Advanced SELECT Statements.

Chapter 5: Adding, Updating, and Deleting Data.

PART II: Managing Database Objects.

Chapter 6: The SQL*Plus Environment.

Chapter 7: Creating and Managing Oracle Database Objects.

Chapter 8: Configuring Security in Oracle Databases.

PART III: Using PL/SQL.

Chapter 9: Introduction to PL/SQL.

Chapter 10: Controlling Program Execution in PL/SQL.

Chapter 11: Interacting with the Database Using PL/SQL.

Chapter 12: Handling Errors and Exceptions in PL/SQL.

Chapter 13: Introduction to Stored Programs.

Appendix A: What's on the CD-ROM?

Appendix B: Practice Exam.

Appendix C: Objective Mapping.

Appendix D: Exam Tips.

Appendix E: Database Schema for Labs.

Appendix F: Data Dictionary Views.

Appendix G: Suggested Readings, Web Sites, and Other Resources.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.