OCA/OCP: Introduction to Oracle 9i SQL Study Guide (Exam 1z0- 007) (Paperback)

OCA/OCP: Introduction to Oracle 9i SQL Study Guide (Exam 1z0- 007) Book 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



Table of Contents



Assessment Test.



Chapter1 Basic SQL SELECT Statements.



Chapter2 SQL*Plus 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.

Book Details

Customer Reviews : OCA/OCP: Introduction to Oracle 9i SQL Study Guide (Exam 1z0- 007)

Be the first one to review this product!

Have you used this product?

    

Discussion : OCA/OCP: Introduction to Oracle 9i SQL Study Guide (Exam 1z0- 007)