Expert Oracle Database 11g 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.

• Background, Data Modeling, UNIX/Linux, and SQL*Plus.- The Oracle DBA’s World.- Relational Database Modeling and Database Design.- Essential UNIX (and Linux) for the Oracle DBA.- Using SQL*Plus and Oracle Enterprise Manager.- Oracle Database 11g Architecture, Schema, and Transaction Management.- Oracle Database 11g Architecture.- Managing Tablespaces.- Schema Management.- Oracle Transaction Management.- Installing Oracle Database 11g, Upgrading, and Creating Databases.- Installing and Upgrading to Oracle Database 11g.- Creating a Database.- Connectivity and User Management.- Connectivity and Networking.- User Management and Database Security.- Data Loading, Backup, and Recovery.- Loading and Transforming Data.- Using Data Pump Export and Import.- Backing Up Databases.- Database Recovery.- Managing the Database.- Automatic Management and Online Capabilities.- Managing and Monitoring the Operational Database.- Performance Tuning.- Improving Database Performance: SQL Query Optimization.- Performance Tuning: Tuning the Instance.