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.