OCA/OCP: Introduction to Oracle9i^TM SQL Study Guide: Exam 1Z0-007

by Chip Dawes; Biju Thomas

• ISBN13: 9780782140620
• ISBN10: 0782140629
• Edition: CD
• Format: Hardcover
• Copyright: 2002-03-01
• Publisher: Sybex

Summary

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative 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 iSQL*Plus * Creating and managing tables * Controlling user access

Author Biography

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

Table of Contents

Introduction	xxi
Assessment Test	xxxi
Basic SQL SELECT Statements	1	(52)
SQL*Plus Overview	53	(58)
Single-Row Functions	111	(78)
Aggregating Data And Group Functions	189	(52)
Joins and Subqueries	241	(48)
Modifying Data	289	(44)
Managing Tables and Constraints	333	(56)
Managing Views	389	(32)
Other Database Objects	421	(34)
User Access and Security	455	(48)
Glossary	503	(10)
Index	513