Expert Oracle9i Database Administration

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

• One Database Basics, Data Modeling, and UNIX/Linux.- 1 The Oracle DBA’s World.- 2 Relational Database Modeling and Database Design.- 3 Essential UNIX (and Linux) for the Oracle DBA.- Two The Oracle RDBMS.- 4 Installing the Oracle9i RDBMS.- 5 Introduction to the Oracle9i Architecture.- 6 Using SQL*Plus and iSQL*Plus.- 7 Schema Management in Oracle9i.- 8 Oracle Transaction Management.- Three Database Creation, Connectivity, and User Management.- 9 Creating an Oracle Database.- 10 Connectivity and Networking.- 11 User Management and Database Security.- Four Data Loading, Backup, and Recovery.- 12 Loading and Transforming Data.- 13 Using the Export and Import Utilities.- 14 Backing Up Databases.- 15 Database Recovery.- Five Managing the Operational Oracle Database.- 16 Managing the Operational Database.- 17 Using Oracle9i Enterprise Manager.- Six Performance Tuning and Troubleshooting the Production Database.- 18 Improving Database Performance: SQL Query Optimization.- 19 Performance Tuning: Tuning the Instance.- 20 The Oracle Data Dictionary and the Dynamic Performance Views.- 21 Using Oracle PL/SQL Packages.- 22 Managing Oracle Databases on Windows and Linux Systems.- Appendix A Brief Oracle9i SQL and PL/SQL Primer.- The Oracle9i Sample Schemas.- Basic SQL.- The Select Statement.- The Insert Statement.- The Delete Statement.- The Update Statement.- Filtering Data.- Sorting the Results of a Query.- The Order By Clause.- Sorting Order.- Sorting by Multiple Columns.- Operators.- Comparison Operators.- Logical Operators.- The Set Operators.- SQL Functions.- Single-Row Functions.- Aggregate Functions.- Number and Date Functions.- General Functions and Conditional Expressions.- SQL Analytical Functions.- Hierarchical Retrieval of Data.- Selecting Data from Multiple Tables.-The Cartesian Product.- The Four Types of Oracle Joins.- Grouping Operations.- Nesting Group Functions.- The Group By Clause with a Rollup Operator.- The Group By Clause with a Cube Operator.- The Group By Clause with a Grouping Operator.- The Group By Clause with a Grouping Sets Operator.- The Having Clause.- Writing Subqueries.- Top N Analysis.- Single-Row Subqueries.- Multiple-Row Subqueries.- Multiple-Column Subqueries.- Advanced Subqueries.- The Exists and Not Exists Operators.- Abstract Data Types.- The Create Type Command.- Object Tables.- Collections.- Type Inheritance.- The Cast Operator.- Using PL/SQL.- The Basic PL/ SQL Block.- Declaring Variables.- Writing Executable Statements.- Handling Errors.- PL/SQL Control Structures.- Conditional Control.- PL/ SQL Looping Constructs.- Cursors.- Implicit Cursors.- Explicit Cursors.- Cursor Attributes.- Cursor For Loops.- PL/ SQL Records.- Cursor Variables.- Functions.- Packages.- Oracle XML DB.- Storing XML in Oracle XML DB.- The Oracle XML DB Repository.- Setting Up an XML Schema.- Creating a Relational View from an XML Document.- Using Java with Oracle.- Summary.