Expert Oracle Database 10g Administration

Part 1. Background, 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

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

4. Introduction to the Oracle Database 10g Architecture

5. Schema Management

6. Oracle Transaction Management

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

7. Installing the Oracle Database 10g RDBMS

8. Upgrading to Oracle Database 10g

9. Creating an Oracle Database

Part 4. Connectivity and User Management

10. Connectivity and Networking

11. User Management and Database Security

12. Using SQL*Plus and iSQL*Plus

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 Operational Oracle Database

17. Automatic Management and Online Capabilities

18. Managing and Monitoring the Operational Database

19. Using Oracle Enterprise Manager

20. Managing Oracle Databases on Windows and Linux Systems

Part 7. Performance Tuning

21. Improving Database Performance: SQL Query Optimization

22. Performance Tuning: Tuning the Instance

Part 8. The Data Dictionary, Dynamic Views, and the Oracle-Supplied Packages

23. The Oracle Data Dictionary and the Dynamic Performance Views

24. Using Oracle PL/SQL Packages

Keywords: COMPUTERS / Computer Science COM014000