OCA/OCP: Introduction to Oracle9i SQL Study Guide / Edition 1

OCA/OCP: Introduction to Oracle9i SQL Study Guide / Edition 1

by Chip Dawes, Biju Thomas
     
 

ISBN-10: 0782140629

ISBN-13: 9780782140620

Pub. Date: 02/19/2002

Publisher: Wiley

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…  See more details below

Overview

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

Product Details

ISBN-13:
9780782140620
Publisher:
Wiley
Publication date:
02/19/2002
Series:
Certification Study Guide Series
Edition description:
BK&CD-ROM
Pages:
592
Product dimensions:
7.69(w) x 9.31(h) x 1.49(d)

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >