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

This course is distributed with:
 

	Exercises that allow users to practice in Oracle8
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to the Oracle8 product
	An Oracle8 glossary