Chip Dawes & Biju Thomas 
OCA / OCP [PDF ebook] 
Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007

Here’s the book you need to prepare for Exam 1Z0-007: Introductionto Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9ienvironment* Hundreds of challenging review questions, in the book and on the CDAuthoritative coverage of all exam objectives, including:* Writing basic SQL SELECT statements* Restricting and sorting data* Displaying data from multiple tables* Aggregating data using group functions* Producing readable output with i SQL*Plus* Creating and managing tables* Controlling user access

Table of Content

Introduction.Assessment Test.Chapter 1 Basic SQL SELECT Statements.Chapter 2 SQL*Plus Overview.Chapter 3 Single-Row Functions.Chapter 4 Aggregating Data And Group Functions.Chapter 5 Joins and Subqueries.Chapter 6 Modifying Data.Chapter 7 Managing Tables and Constraints.Chapter 8 Managing Views.Chapter 9 Other Database Objects.Chapter 10 User Access and Security.Glossary.Index.

About the author

Chip Dawes is an OCP and has worked with Oracle databasessince 1990. He is a consultant with D&D Technologies andfrequently presents at various Oracle User Group conferences.Biju Thomas, OCP, has over 7 years of Oracle databasemanagement and application development experience. He currentlyworks as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP:Oracle8i DBA SQL Study Guide.