.

ORACLE 9I DATABASE ADMIN
-------------------------------------

COURSE OUTLINE
 

1. WHAT'S NEW IN ORACLE 9I
2. BASIC ORACLE DATABASE ADMINISTRATION
     A. THE ORACLE DATABASE ADMINISTRATOR
     B. CREATING AN ORACLE DATABASE
     C. USING ORACLE-MANAGED FILES
     D. STARTING UP AND SHUTTING DOWN
3. THE ORACLE SERVER PROCESSES AND STORAGE STRUCTURE
     A. MANAGING ORACLE PROCESSES
     B. MANAGING CONTROL FILES
     C. MANAGING THE ONLINE REDO LOGS
     D. MANAGING ARCHIVED REDO LOGS
     E. LOG MINER TO ANALYZE REDO LOG FILES
     F. MANAGING JOB QUEUES
     G. MANAGING TABLE SPACES
     H. MANAGING DATA FILES
     I. MANAGING UNDO SPACE
4. THE SCHEMA OBJECTS
     A. MANAGING SPACE FOR SCHEMA OBJECTS
     B. MANAGING TABLES
     C. MANAGING INDEXES
     E. MANAGING PARTITIONED TABLES AND INDEXES
     F. MANAGING CLUSTER
     G. MANAGING VIEWS SEQUENCE AND SYNONYMS
     H. GENERAL MANAGEMENT OF SCHEMA OBJECTS
     I. DETECTING AND REPAIRING DATA BLOCK CORRUPTION
5. DATABASE SECURITY
     A. ESTABLISHING SECURITY POLICIES
     B. MANAGING USERS AND RESOURCES
     C. MANAGING USERS PRIVILEGES AND ROLES
     D. AUDITING DATABASE USE
6. DATABASE RESOURCE MANAGEMENT
     A. USING THE DATABASE RESOURCE MANAGEMENT
7. DISTRIBUTED DATABASE MANAGEMENT
     A. DISTRIBUTED DATABASE CONCEPTS
     B. MANAGING A DISTRIBUTED DATABASE
     C. DEVELOPING APPLICATION FOR A DISTRIBUTED DATABASE SYSTEM
     D. DISTRIBUTED TRANSACTION CONCEPT
     E. MANAGING DISTRIBUTED TRANSACTION