Oracle Database 10g: Administration I

Aims and Objectives
Install and configure the Oracle Database 10g.
Create and administer user accounts in the Oracle Database 10g.
Backup and Recovery of the Oracle Database 10g.
Monitor, troubleshoot and maintain the Oracle Database 10g.
Configure Oracle Net services for the Oracle Database 10g.

Target Audiences
This course is targeted towards Database Administrators of small to medium sized businesses.

Prerequisites

Course Content

Module 1: Introduction
Module 2: Installing Oracle Database 10g Software
Module 3: Create an Oracle Database
Module 4: Database interfaces
Module 5: Storage Structures
Module 6: Administering users
Module 7: Managing Schema Objects
Module 8: Managing Data
Module 9: PL/SQL
Module 10: Oracle Database Security
Module 11: Oracle Net Services
Module 12: Oracle Shared Server
Module 13: Performance Monitoring
Module 14: Proactive Maintenance: Objectives
Module 15: Undo Management
Module 16: Monitoring and Resolving Lock Conflicts
Module 17: Backup and Recovery Concepts
Module 18: Database backups
Module 19: Database Recovery