Oracle9i DBA JumpStart -- Acknowledgments -- Contents -- Introduction -- What You Need -- What This Book Covers -- Understanding Oracle Certification -- Making the Most of This Book -- About the Author -- Chapter 1: Relational Database Concepts -- Are Spreadsheets Like Databases? -- Relational Databases -- Object-Relational Databases -- Chapter 2: SQL*Plus and iSQL*Plus Basics -- Some SQL Formalities -- Tools for Running SQL -- The Ubiquitous SELECT Statement -- DML for Making Changes -- DDL for Handling Database Objects -- DCL for Handling Privileges -- Chapter 3: Oracle Database Functions -- Query Basics -- Built-in Single-Row Functions -- User-Defined Functions -- Chapter 4: Restricting, Sorting, and Grouping Data -- The WHERE Clause -- The ORDER BY Clause -- Group Functions and the GROUP BY Clause -- Chapter 5: Using Multiple Tables -- Join Syntax: Out with the Old and In with the New (SQL:1999) -- Equijoins -- Non-equijoins -- Outer Joins -- Self-Joins -- Cartesian Products: The Black Sheep of the Family -- Chapter 6: Advanced SQL Queries -- Subqueries -- Set Operators -- ROLLUP and CUBE -- Chapter 7: Logical Consistency -- Constraints -- Transaction Processing -- Chapter 8: Installing Oracle and Creating a Database -- Oracle Components Overview -- Installing Oracle Software -- Creating an Oracle Database -- Chapter 9: Reporting Techniques -- iSQL*Plus Configuration -- Report Formatting -- Substitution Variables -- Saving and Running Scripts -- Chapter 10: Creating and Maintaining Database Objects -- Creating Tables -- Creating Indexes -- Creating and Using Views -- Creating Sequences and Synonyms -- Chapter 11: Users and Security -- Creating User Accounts -- Granting and Revoking Privileges -- Auditing -- Chapter 12: Making Things Run Fast (Enough) -- Oracle's Tuning Methodology -- Indexes -- Data Design Tuning -- SQL Application Tuning.

Memory Tuning -- Chapter 13: Saving Your Stuff (Backups) -- Database Failures -- User Backup and Recovery Methods -- DBA Backup and Recovery Methods -- Chapter 14: Troubleshooting -- The Alert Log File -- OEM's Event Manager -- System Trace Files -- User Trace Files -- Appendix A: Answers to Review Questions -- Chapter 1 -- Chapter 2 -- Chapter 3 -- Chapter 4 -- Chapter 5 -- Chapter 6 -- Chapter 7 -- Chapter 8 -- Chapter 9 -- Chapter 10 -- Chapter 11 -- Chapter 12 -- Chapter 13 -- Chapter 14 -- Appendix B: Glossary -- Appendix C: Common Database Platforms -- Enterprise Databases -- Personal and Freeware Databases -- Index.