Back to Search Results

Training Course Summary:

This course is designed for Database Administrators, Technical Support Analysts and System Administrators. It will give the Oracle database administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to create and manage the structures of an Oracle9i database. The course teaches delegates to use an administration tool to start-up and shutdown a database, create a database, manage file and database storage and manage users and their privileges. The course also teaches delegates to organise the database and to move data into and between databases under different environments.

Course objectives

On completing this course, delegates will be able to:
Outline the Oracle9i architecture
Create an operational database
Start up and shut down an Oracle instance
Manage Oracle physical database files
Manage Oracle logical database structures
Manage Oracle users, privileges and resources
Use Global Support features

Pre-Requisites:

Delegates must have attended course SQLINT (Introduction to Oracle9i: SQL). An understanding of stored procedures, functions and packages concepts would be beneficial.