Sybex

Home Certification IT Administration Architecture & Design
3D Animation & CGI Internet Marketing
Print this page Share

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

ISBN: 978-0-7821-4062-0
592 pages
March 2002
OCA / OCP: Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007 (0782140629) cover image

Description

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
See More

Table of Contents

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.

See More

Author Information

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.

See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
See More

Learn more about