Oracle8i Oracle8i DBA Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure Training available online e-learning

The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands used to perform administrative tasks. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.

Training Program Details

Audience

This course is designed for database administrators application developers business and systems analysts MIS managers and technical support professionals and ordinary Oracle users. It will prepare students for the Oracle8i: Architecture and Administration Exam.

Prerequisites

The audience should be familiar with RDBMS concepts Graphical User Interfaces (GUIs) SQL and basics of PL/SQL.

Objective

Upon completion of this course the student will be able to:

Identify the components of the INIT.ORA file

Start up and shut down an Oracle instance

Identify the different phases of the startup and shutdown process

Query the dynamic performance views

Manage dynamic intialization parameters

Manage sessions

Identify the process of creating a database

Create a database

Topics Include

Unit 1: Oracle Instances

The Initialization Parameter File
The Startup and the Shutdown Process
Starting up an Instance
Changing Database Availability
Shutting Down an Instance

Unit 2: Controlling Oracle at Runtime

Dynamic Performance Views
Dynamic Initialization Parameters
Managing Sessions
Terminating Sessions
Alert and Trace Files

Unit 3: Creating Databases

Preparing for a Database
Database Configuration Assistant
Database Creation: Initial Steps
Database Creation: the CREATE DATABASE Command

Duration

5 Hours

Minimum Requirements

IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

Media

CDROM
Web Based Training

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada

Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure

Training Provided by Serebra Learning Corporation

Training Avaliability and Delivery