Provided by: Serebra Learning Corporation

Oracle8i DBA: Indexes and Constraints

Click here for more information or to take this course

home : Computer : Oracle : Oracle8i

Get More Information

Search for Training

Find Your Genius!

Training Provided by Serebra Learning Corporation

In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	Contact Serebra Learning Corporation for more information

Schedule:	5 hours
Training Presented in:	English

Related Keywords: oracle8i dba

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 and manage indexes

Identify types of constraints

Create and manage constraints

Topics Include

Unit 1: Indexes

An Index Overview
Creating Indexes
Reorganizing Indexes
Dropping Indexes
Obtaining Information About Indexes

Unit 2: Constraint Concepts

Constraint Overview
Key Constraints

Unit 3: Working with Constraints

Implementing Constraints
Managing Constraints
Using the Exceptions Table
Obtaining Information About Constraints

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

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Oracle8i DBA Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/18/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you an Oracle8i dba training provider?

You could be on this page today - for FREE!