Oracle Database Foundations -- Frontmatter -- Acknowledgments -- Contents -- Introduction -- Chapter 1: Relational Database Concepts -- Are Spreadsheets Like Databases? -- Relational Databases -- Tables, Rows, and Columns -- Primary Keys, Datatypes, and Foreign Keys -- Data Modeling -- Object-Relational Databases -- Abstraction -- Methods and Encapsulation -- Inheritance -- Object-Relational Support -- Terms to Know -- Review Questions -- Chapter 2: SQL*Plus and iSQL* Plus Basics -- Some SQL Formalities -- Tools for Running SQL -- SQL*Plus -- iSQL*Plus -- SQL*Plus Worksheet -- Third-Party Tools -- ODBC/JDBC -- OCI -- The Ubiquitous SELECT Statement -- Column Specification -- Column Renaming -- Duplicate Removal -- Expressions -- DML for Making Changes -- The UPDATE Statement -- The INSERT Statement -- The DELETE Statement -- The MERGE Statement -- DDL for Handling Database Objects -- The CREATE Statement -- The ALTER Statement -- The DROP Statement -- The RENAME Statement -- The TRUNCATE Statement -- DCL for Handling Privileges -- The GRANT Statement -- The REVOKE Statement -- Terms to Know -- Review Questions -- Chapter 3: Oracle Database Functions -- Query Basics -- The DUAL Table -- NULLs: What, When, Why, and How -- String Literals and Concatenating Strings -- Numeric Literals -- Operators and Operator Precedence -- Built-In Single-Row Functions -- String Functions -- Numeric Functions -- Date Functions -- Conversion Functions -- General Functions -- User-Defined Functions -- Terms to Know -- Review Questions -- Chapter 4: Restricting, Sorting, and Grouping Data -- The WHERE Clause -- Comparison Conditions -- AND, OR, and NOT -- BETWEEN, IN, and LIKE -- IS NULL and IS NOT NULL -- The ORDER BY Clause -- Group Functions and the GROUP BY Clause -- Group Functions -- The GROUP BY Clause -- Using NVL with Group Functions -- The HAVING Clause.

Terms to Know -- Review Questions -- Chapter 5: Using Multiple Tables -- Join Syntax: Out with the Old and In with the New (SQL:1999) -- Equijoins -- Pre-Oracle9i Equijoin Syntax -- Oracle9i Equijoin Syntax -- Non-equijoins -- Pre-Oracle9i Non-equijoin Syntax -- Oracle9i Non-equijoin Syntax -- Outer Joins -- Pre-Oracle9i Outer Join Syntax -- Oracle9i Outer Join Syntax -- Self-Joins -- Pre-Oracle9i Self-Join Syntax -- Oracle9i Self-Join Syntax -- Cartesian Products: The Black Sheep of the Family -- Pre-Oracle9i Cartesian Product Syntax -- Oracle9i Cartesian Product Syntax -- Terms to Know -- Review Questions -- Chapter 6: Advanced SQL Queries -- Subqueries -- Single-Row Subqueries -- Multiple-Row Subqueries -- Correlated Subqueries -- Multiple-Column Subqueries -- Set Operators -- UNION and UNION ALL -- INTERSECT -- MINUS -- ROLLUP and CUBE -- ROLLUP -- CUBE -- Terms to Know -- Review Questions -- Chapter 7: Logical Consistency -- Constraints -- NOT NULL -- CHECK -- UNIQUE -- PRIMARY KEY -- FOREIGN KEY -- Transaction Processing -- The COMMIT Statement -- The ROLLBACK Statement -- The SAVEPOINT Statement -- Terms to Know -- Review Questions -- Chapter 8: Installing Oracle and Creating a Database -- Oracle Components Overview -- Logical Storage Structures -- Physical Storage Structures -- Oracle Memory Structures -- Background Processes -- Installing Oracle Software -- Using the Oracle Universal Installer -- Using the Oracle Enterprise Manager Tools -- Creating an Oracle Database -- Disk and Memory Requirements -- Using the Database Configuration Assistant -- Terms to Know -- Review Questions -- Chapter 9: Reporting Techniques -- iSQL*Plus Configuration -- Interface Configuration -- Script Formatting and System Variables -- Change Password -- Report Formatting -- Headers and Footers -- Column Formatting -- BREAK Processing -- Summary Operations (Totals).

Substitution Variables -- Saving and Running Scripts -- Terms to Know -- Review Questions -- Chapter 10: Creating and Maintaining Database Objects -- Creating Tables -- Relational Tables -- Create Table As Select (CTAS) -- External Tables -- Temporary Tables -- Creating Indexes -- Creating and Using Views -- User-Defined Views -- Data Dictionary Views -- Dynamic Performance Views -- Creating Sequences and Synonyms -- Sequences -- Synonyms -- Terms to Know -- Review Questions -- Chapter 11: Users and Security -- Creating User Accounts -- Assigning Passwords -- Creating and Assigning Profiles -- Assigning Default Tablespaces and Quotas -- Granting and Revoking Privileges -- System Privileges -- Object Privileges -- Creating and Assigning Roles -- Auditing -- Statement Auditing -- Object Auditing -- Terms to Know -- Review Questions -- Chapter 12: Making Things Run Fast (Enough) -- Oracle's Tuning Methodology -- Indexes -- When to Create Indexes -- Index Types -- Creating, Dropping, and Maintaining Indexes -- Monitoring Indexes -- Data Dictionary Index Information -- Data Design Tuning -- Partitioned Tables -- Materialized Views -- SQL Application Tuning -- Top SQL Tool -- Explain Plan Graphical Tool -- The Oracle Optimizer -- Memory Tuning -- Terms to Know -- Review Questions -- Chapter 13: Saving Your Stuff (Backups) -- Database Failures -- User Backup and Recovery Methods -- Export and Import for Users -- Flashback Query -- DBA Backup and Recovery Methods -- Export and Import for DBAs -- Cold Backups -- Hot Backups -- Log Miner -- Recovery Manager -- Terms to Know -- Review Questions -- Chapter 14: Troubleshooting -- The Alert Log File -- Locating the Alert Log File -- Viewing the Alert Log File -- Maintaining the Alert Log File -- Event Notification -- Oracle9i OEM Event Manager -- Oracle 10g Advisory Framework -- System Trace Files.

User Trace Files -- Enabling Tracing -- Locating the User Trace Files -- Converting the Trace File -- Terms to Know -- Review Questions -- 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: Common Database Platforms -- Enterprise Databases -- Personal and Freeware Databases -- Glossary -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- Z.