Oracle8i Oracle8i DBA Oracle 8i DBA - Understanding Storage Allocation Training available online e-learning

This course covers the various aspects of optimizing database objects. It discusses tables clusters and index-organized tables. This course explains the different types of tables supported by Oracle 8i the structure of a row the different data types supported by Oracle 8i and the guidelines to create a table. Further the course covers how to create the cluster the cluster index and the tables in the cluster. The course also covers how to create and manage the index-organized tables. 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:

Create tables by using appropriate storage settings

Control the space used by tables

Analyze tables to check integrity and migration

Control space used by tables

Retrieve information about tables from the data dictionary

Topics Include

Unit 1: Tables

Introduction to Tables
Introduction to Oracle 8i Datatypes
Creating Tables
Managing Storage Parameters for Tables

Unit 2: Managing Tablespaces

Changing Storage Parameters
Allocating Extents Manually
Reorganizing Tables
Deallocating Unused Space

Unit 3: Tables: Deleting

Truncating a Table
Dropping a Column
Dropping a Table
Table Information

Unit 4: Clusters And Index Organized Tables

Clusters
Creating Index Clusters
Creating Hash Clusters
Maintaining Clusters
Index Organized Tables
Creating Index Organized Tables

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 - Understanding Storage Allocation

Training Provided by Serebra Learning Corporation

Training Avaliability and Delivery