Oracle8i^TM DBA: SQL and PL/SQL Certification Bible

by Damir Bersinic; Stephen Giles; Susan Ibach; Myles Brown

• ISBN13: 9780764548321
• ISBN10: 0764548328
• Edition: CD
• Format: Hardcover
• Copyright: 2001-10-01
• Publisher: Wiley

Summary

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

Author Biography

Damir Bersinic, an Oracle Certified DBA as well as an MCSE and MCDBA, has worked with Oracle and SQL Server for nearly two decades. He is the founder and president of Bradley Systems Inc., a Microsoft certified partner specializing in database, Internet, and system integration consulting and training. Stephen Giles, creator of a customized SQL course, Susan Ibach, an application developer, and Myles Brown, a database programming specialist, all teach the Oracle curriculum at TMI-Lernix, a leading training company based in Canada.

Table of Contents

Preface	ix
Acknowledgments	xiv
Part I: The Oracle SQL Language	1	(224)
The Oracle Database	3	(32)
Retrieving Data Using Basic SQL Statements	35	(54)
Using Single-and Multi-Row Functions	89	(50)
Advanced SELECT Statements	139	(52)
Adding, Updating, and Deleting Data	191	(34)
Part II: Managing Database Objects	225	(176)
The SQL *Plus Environment	227	(40)
Creating and Managing Oracle Database Objects	267	(92)
Configuring Security in Oracle Databases	359	(42)
Part III: Using PL/SQL	401	(214)
Introduction to PL/SQL	403	(40)
Controlling Program Execution in PL/SQL	443	(36)
Interacting with the Database Using PL/SQL	479	(54)
Handling Errors and Exceptions in PL/SQL	533	(38)
Introduction to Stored Programs	571	(44)
Appendix A: What's on the CD-ROM?	615	(6)
Appendix B: Practice Exam	621	(32)
Appendix C: Objective Mapping	653	(12)
Appendix D: Exam Tips	665	(4)
Appendix E: Database Schema for Labs	669	(18)
Appendix F: Data Dictionary Views	687	(30)
Appendix G: Suggested Readings, Web Sites, and Other Resources	717	(4)
Index	721	(20)
End-User License Agreement	741	(3)
CD-ROM Installation Instructions	744