OCA/OCP: Introduction to Oracle9i<sup><small>TM</small></sup> SQL Study Guide: Exam 1Z0-007,9780782140620

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

by ;
Edition: CD
ISBN13: 9780782140620
ISBN10: 0782140629
Format: Hardcover
Pub. Date: 2002-03-01
Publisher(s): Sybex
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $49.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $5.50

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.