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

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

Book rating: 04 CD-ROM

By (author) Chip Dawes, By (author) Biju Thomas

List price $59.27

Unavailable - AbeBooks may have this title.

  • Publisher: Sybex Inc.,U.S.
  • Format: CD-ROM | 592 pages
  • Dimensions: 196mm x 231mm x 38mm | 1,043g
  • Publication date: 22 March 2002
  • Publication City/Country: New York
  • ISBN 10: 0782140629
  • ISBN 13: 9780782140620
  • Edition statement: Study Guide ed.
  • Sales rank: 882,417

Product description

Oracle is the leading database on the market, putting Oracle database administrators in high demand. Oracle recently restructured their certification program into three tiers - OCA (Oracle Certified Associate), OCP (...Professional), and OCM (...Master). The first two tiers are exam based, while the third tier (Master) is a hands-on exam in a lab environment. Candidates must pass two exams for the OCA certification, and an additional two for the OCP. This book covers the Introduction to Oracle9i: SQL exam, the first exam required for both the OCA and OCP certifications.

Other books in this category

Showing items 1 to 11 of 11

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.

Customer reviews

By tunji 04 Aug 2010 4

This is a very good book for anyone loooking to take the 1Z0-007 exam. Lots of exercises included and I suggest you read it twice to really gain some benefit.
It is a shame none of the authors have Oracle 11g books as I liked the style and structure of it and would have been happy to continue buying their books.

Back cover copy

Here's the book you need to prepare for Exam 1Z0-007: Introduction toOracle9i: In-depth coverage of official examobjectivesPractical information on using SQL in a real-world Oracle9ienvironmentHundreds of challenging review questions, in the book and on theCD Authoritative coverage of all exam objectives, including: Writing basic SQL SELECT statementsRestricting and sortingdataDisplaying data from multiple tablesAggregating data using groupfunctionsProducing readable output with iSQL*PlusCreating and managing tablesControlling user access

Table of contents

Contents at a Glance. Introduction. Assessment Test. Chapter1 Basic SQL SELECT Statements. Chapter2 SQLPlus Overview. Chapter3 Single--Row Functions. Chapter4 Aggregating Data And Group Functions. Chapter5 Joins and Subqueries. Chapter6 Modifying Data. Chapter7 Managing Tables and Constraints. Chapter8 Managing Views. Chapter9 Other Database Objects. Chapter10 User Access and Security. Glossary. Index.