|
OCP: Introduction to Oracle 9i SQL
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
Introduction.
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.
|
