OCA/OCP: Introduction to Oracle9i SQL -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Why Become an Oracle Certified Professional? -- What Does This Book Cover? -- How to Contact the Authors -- Assessment Test -- Answers to Assessment Test -- Chapter 1: Basic SQL SELECT Statements -- SQL Fundamentals -- Writing Simple Queries -- Other Operators -- Sorting Rows -- Using Expressions -- Summary -- Exam Essentials -- Key Terms -- Commands Used in This Chapter -- Review Questions -- Answers to Review Questions -- Chapter 2: SQL*Plus Overview -- SQL*Plus Fundamentals -- Producing More Readable Output -- Accepting Values at Runtime -- Using iSQL*Plus -- Summary -- Exam Essentials -- Key Terms -- Commands Used in This Chapter -- Review Questions -- Answers to Review Questions -- Chapter 3: Single-Row Functions -- Single-Row Function Fundamentals -- NULLs and Single-Row Functions -- Using Single-Row Character Functions -- Using Single-Row Numeric Functions -- Using Single-Row Date Functions -- Using Single-Row Conversion Functions -- Using Other Single-Row Functions -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 4: Aggregating Data And Group Functions -- Group Function Fundamentals -- Using Group Functions -- Nesting Functions -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 5: Joins and Subqueries -- Multiple-Table Queries -- Subqueries -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 6: Modifying Data -- Using DML Statements -- Inserting into Multiple Tables -- Updating Rows in a Table -- Merging Rows into a Table -- Deleting Rows from a Table -- Truncating a Table -- Selecting Rows -- Locking a Table -- Understanding Transaction Control -- Summary.

Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 7: Managing Tables and Constraints -- Database Objects Review -- Built-in Datatypes -- Creating Tables -- Modifying Tables -- Managing Constraints -- Creating Constraints -- Dropping Constraints -- Enabling and Disabling Constraints -- Deferring Constraint Checks -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 8: Managing Views -- Creating and Modifying Views -- Using Views -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 9: Other Database Objects -- Creating and Managing Sequences -- Creating and Managing Synonyms -- Creating and Managing Indexes -- Calling Stored Programs -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Chapter 10: User Access and Security -- Creating and Modifying User Accounts -- Creating and Using Roles -- Granting and Revoking Privileges -- Managing User Groups with Profiles -- Summary -- Exam Essentials -- Key Terms -- Review Questions -- Answers to Review Questions -- Index.