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
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Illustrationen
Maße
Höhe: 23.3 cm
Breite: 19.9 cm
Dicke: 38 mm
Gewicht
ISBN-13
978-0-7821-4062-0 (9780782140620)
Schweitzer Klassifikation
Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences. 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.
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.