OCA/OCP: Introduction to Oracle9i SQL Study Guide

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

• 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

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