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


 

Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.