Dawes / Thomas OCA / OCP

Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007
1. Auflage 2006
ISBN: 978-0-7821-5250-0
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 592 Seiten, E-Book

Here's the book you need to prepare for Exam 1Z0-007: Introductionto Oracle9i:
* In-depth coverage of official exam objectives
* Practical information on using SQL in a real-world Oracle9ienvironment
* Hundreds of challenging review questions, in the book and on theCD
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

Autoren/Hrsg.

Dawes, Chip

Thomas, Biju

Inhaltsverzeichnis

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.

Über Autor(innen)

Chip Dawes is an OCP and has worked with Oracle databasessince 1990. He is a consultant with D&D Technologies andfrequently presents at various Oracle User Group conferences.
Biju Thomas, OCP, has over 7 years of Oracle databasemanagement and application development experience. He currentlyworks as a Database Administrator Consultant for BurlingtonResources in Fort Worth, TX. Both authors contributed to OCP:Oracle8i DBA SQL Study Guide.