Expert Oracle Database 11g Administration

Part 1. Background, Data Modeling, UNIX/Linux, and SQL*Plus

1. The Oracle DBA’s World

2. Relational Database Modeling and Database Design

3. Essential UNIX (and Linux) for the Oracle DBA

4. Using SQL*Plus and Oracle Enterprise Manager

Part 2. Oracle Database 11g Architecture, Schema, and Transaction Management

5. Oracle Database 11g Architecture

6. Managing Tablespaces

7. Schema Management

8. Oracle Transaction Management

Part 3. Installing Oracle Database 11g, Upgrading, and Creating Databases

9. Installing and Upgrading to Oracle Database 11g

10. Creating a Database

Part 4. Connectivity and User Management

11. Connectivity and Networking

12. User Management and Database Security

Part 5. Data Loading, Backup, and Recovery

13. Loading and Transforming Data

14. Using Data Pump Export and Import

15. Backing Up Databases

16. Database Recovery

Part 6. Managing the Database

17. Automatic Management and Online Capabilities

18. Managing and Monitoring the Operational Database

Part 7. Performance Tuning

19. Improving Database Performance: SQL Query Optimization

20. Performance Tuning: Tuning the Instance

Avainsanat: COMPUTERS / Computer Science COM014000