Expert Oracle 9i Database Administration

Part I: Data Basics, Data Modeling and UNIX/Linux
- The Oracle Database Administrator's World,
- Relational Database Modeling and Database Design
- Essential UNIX/Linux for the Oracle DBA

Part II: The Oracle RDBMS. Installing the Oracle9i RDBMS
- Introduction to the Oracle9i Architecture
- Using SQL*Plus and iSQL*Plus
- Schema Management in Oracle9i
- Oracle Transaction Management

Part III: Database Creation, Connectivity, and User Management. Creating an Oracle Databases
- Connectivity and Networking
- User Management and Database Security

Part IV: Data Loading, Backing Up and Recovery. Loading and Transforming Data
- Using the Export and Import Utilities
- Backing Up Databases
- Database Recovery

Part V: Managing the Operational Oracle Database. Managing the Operational Database
- Using Oracle9i Enterprise Manager

Part VI: Performance Tuning and Troubleshooting the Production Database. Improving Database Performance: SQL Query Optimization
- Performance Tuning: Tuning the Instance
- The Oracle Data Dictionary and the Dynamic Performance Views
- Using Oracle PL/SQL Packages
- Managing Oracle Databases on Windows and Linux Systems

- Appendix
- Index.

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.