Synopsis
Oracle8: Database Schema Objects shows users how to manage tables and indexes.

Audience
This course is for anyone who is interested in learning about table views and indexes in Oracle8.

Time
4 hours

Product Code: ORCC05
After completing Oracle8: Database Schema Objects, the user should be able to:
Create tables
Manage different table views and types
Create indexes
Identify and use index types

Understanding Tables
Parts of a table
How tables work
Oracle data types

Creating Tables
Enterprise Manager
Schema Manager
CREATE TABLE command
Including the STORAGE clause

Special Tables and Table Views
Partitioned tables
Object tables
Views

Indexes
Using indexes
Index types
How the Oracle index works
Deciding what to index

Creating Indexes
Taking advantage of indexes
Creating indexes with Schema Manager
CREATE INDEX command

Special Indexes
Partitioned indexes
Bitmap indexes

Synonyms and Table Sequences
Synonyms
Table sequences


 

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information