OCA / OCP: Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007ISBN: 978-0-7821-4062-0
592 pages
March 2002
|
Description
* 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.
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.
Author Information
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.
Errata
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
Chapter | Page | Details | Date | Print Run |
---|