Synopses & Reviews
Here’s the book you need to prepare for Exam 1Z0-007: Introduction toOracle9i:
- In-depth coverage of official examobjectives
- 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 statementsRestricting and sortingdataDisplaying data from multiple tablesAggregating data using groupfunctionsProducing readable output with iSQL*PlusCreating and managing tablesControlling user access
Synopsis
Oracle is the leading database on the market, putting Oracle database administrators in high demand. Oracle recently restructured their certification program into three tiers--OCA (Oracle Certified Associate), OCP (...Professional), and OCM (... Master). The first two tiers are exam based, while the third tier (Master) is a hands-on exam in a lab environment. Candidates must pass two exams for the OCA certification, and an additional two for the OCP. This book covers the Introduction to Oracle9i: SQL exam, the first exam required for both the OCA and OCP certifications.
Synopsis
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
About the Author
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.
Table of 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.