OCA/OCP: Exam 1Z0-007

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

By (author) , By (author)

List price: US$49.98

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

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.

show more

Product details

  • CD-ROM | 592 pages
  • 195.58 x 231.14 x 38.1mm | 1,043.26g
  • John Wiley & Sons Inc
  • Sybex Inc.,U.S.
  • New York, United States
  • English
  • Study Guide ed.
  • 0782140629
  • 9780782140620
  • 968,720

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

show more

About Biju Thomas

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.

show more

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.

show more

Customer reviews

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.show more
by JongWhee Lee