"Exam 1Z0-007"--Cover.

Includes index.

Preparing for OCP DBA Exam I: Introduction to SQL -- Overview of Oracle Databases -- Theoretical and Physical Aspects of Relational Databases -- Oracle's RDBMS and ORDBMS Implementations -- Usage and Benefits of PL/SQL -- Writing Basic SQL Statements -- Capabilities of SQL select Statements -- Executing select Statements -- Differentiating Between SQL and SQL *Plus Commands -- Limiting, Sorting, and Manipulating Return Data -- Restricting and Sorting Row Data -- Sorting Return Data with the order by Clause -- Limiting Return Data with the where Clause -- Using Single-Row Functions -- Various Single-Row Functions Explained -- Using Functions in select Statements -- Date Functions -- Conversion Functions -- Advanced Data Selection in Oracle -- Displaying Data from Multiple Tables -- The Keys to Table Joins -- Select Statements That Join Data from More Than One Table -- Creating Outer Joins -- Joining a Table to Itself -- Group Functions and Their Uses -- Identifying and Using Group Functions -- Using the group by Clause -- Excluding group Data with having -- Subqueries -- Understanding and Defining Subqueries -- Listing and Writing Different Types of Subqueries -- Writing Multiple-Column Subqueries -- NULL Values and Subqueries -- Subqueries in a from Clause -- Producing Readable Output with SQL *Plus -- Entering Variables -- Customizing SQL *Plus Environments -- Producing Readable Output -- Creating and Executing Scripts -- Saving Customizations -- Creating Oracle Database Objects -- Creating the Tables of an Oracle Database -- Describing Tables -- Creating Tables -- Datatypes and Column Definitions -- Altering Table Definitions -- Dropping, Renaming, and Truncating Tables -- Including Constraints -- Describing Constraints -- Creating and Maintaining Constraints -- Manipulating Oracle Data -- Adding New Rows to a Table -- Making Changes to Existing Row Data -- Deleting Data from the Oracle Database -- Merging Data in Oracle Tables -- The Importance of Transaction Control -- Creating Other Database Objects in Oracle -- Creating Views -- Creating Simple Views -- Creating Views That Enforce Constraints -- Creating Complex Views -- Modifying and Removing Views -- Other Database Objects -- Overview of Other Database Objects -- Using Sequences -- Using Indexes -- Using Public and Private Synonyms -- User Access Control in Oracle -- Creating Users -- Granting and Revoking Object Privileges -- Using Roles to Manage Database Access -- OCP Oracle9i DBA Practice Exams.

Prepare to pass the Oracle Certified Professional Introduction to Oracle9i: SQL exam--a required exam for OCP DBA certification--using this Oracle Press study guide. Throughout each chapter, users will find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what they've learned.