Training Course: DBA Fundamentals

Training Course Summary:

Delegates:

This course is for Database Administrators, Systems Administrators and Network Managers who need to gain practical experience in setting up and administering an Oracle9i database and who also need to plan and implement database backup and recovery strategies and configure Oracle databases in a network environment.

Objectives:

By the end of this course, the delegate will have been given practical experience in creating and managing an Oracle9i database and in using the various Oracle backup and recovery commands. The delegate will also have had practical experience in configuring Net Architecture, the Oracle Shared Server and the Listener. Experience of troubleshooting backup and recovery and simple network problems will also have been gained. The main examination topics for the Oracle9i Database Fundamentals I (IZ0-031) and the Backup and Recovery and Networking topics of the Oracle9i Database Fundamentals II (IZ0-032) exams are also covered in this course.


Topics Covered:

Creating an Oracle database
Managing an Oracle instance
Altering an Oracle database
Managing disk space, tablespaces and datafiles
Managing redo log files and control files
Managing rollback segments and undo data
Managing temporary segments
Managing tables and indexes
Managing users, profiles, privileges and roles
Maintaining Database Security
Backup and Recovery Strategies
Disaster Recovery Plan
Failure Scenarios
Oracle Recovery Structures and Processes
Using ARCHIVELOG and NOARCHIVELOG Modes
Physical Backups
Complete Database Recovery
Incomplete Recovery with Archiving
The Export and Import Utilities
Loading Data with SQL*Loader
Troubleshooting Utilities
Recovery Manager Overview
Creating and Maintaining a Recovery Catalog
Backing up and Restoring with RMAN
Data Guard Architecture
Configuring the Oracle Network
Oracle Net Architecture and Net Configuration
Oracle Net Manager and Configuration Assistant
Net Server and Client Side Configuration
Listener Configuration
Configuration of Net Service Names
Configuration of the Oracle Shared Server
Overview of Oracle Internet Directory
Troubleshooting the Network Environment
Network Environment Security

Requirements:

A working knowledge of SQL*Plus is required. This can be obtained by attendance on the "Oracle SQL*Plus" course. A good working knowledge of operating system commands is also required.

Before taking any exam, ensure you have the recommended experience.

Pre-Requisites Courses:

SQL*Plus


Follow-On Courses:

DBA Performance & Tuning

DBA Network Administration