Synopses & Reviews
Here's the book you need to prepare for Exam 1Z0-001, Introduction to Oracle: SQL and PL/SQL. Written by Oracle8i experts, this affordable and comprehensive Study Guide provides:
- Full coverage of every exam objective-all the information you need
- Practical information on using SQL and PL/SQL in a real-world Oracle8i environment
- Hundreds of challenging review questions, in the book and on the CD
- Leading-edge exam preparation software, including a testing engine and electronic flashcards
This title is billed as the only study guide on the market targeting the PL/SQL exam, required for both the DBA and the Application Developer tracks. The book provides a self-assessment test, key term definitions, review questions, a practice exam, plus an enhanced CD with testing software.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Description
System requirements: Windows 95/98/NT4/2000 (or higher)
About the Author
Chip Dawns, OCP, has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and often is a presenter at Oracle User Group conferences.
Bijou Thomas has more than six years of Oracle database management and application development experience. He has written articles for both Oracle Magazine and Oracle Internals.
Table of Contents
INTRODUCTION.
Assessment Test.
Chapter 1: Relational Technology and Simple SQL SELECT Statements.
Chapter 2: Single-Row and Group Functions.
Chapter 3: Joins and Subqueries.
Chapter 4: Modifying Data and Security.
Chapter 5: Modifying Data and Security.
Chapter 6: Other Database Objects and the Data Dictionary.
Chapter 7: PL/SQL Basics.
Chapter 8: Interacting with the Database.
Chapter 9: Working with Composite Datatypes and Collections.
Chapter 10: Exception Handling.
Appendix A: Practice Exam.
Glossary.
Index.