Audience

Database administrators

Prerequisites

Completion of the Oracle Introduction curriculum

Course Aim

To describe Oracle8i datatypes and introduce the student to Oracle tables and indexes

Learning Objectives

Choose between the different Oracle datatypes. Contrast the different methods for storing data. Create an Oracle table. Modify table storage parameters. Interpret table and index statistics. Choose between the different index types. Create indexes. Manage index growth.

Topics Covered

Tables and datatypes - Oracle datatypes - Table storage The table creation process - Designing and creating tables - Storage parameters - Hands-on: Creating a table Controlling table storage - The high water mark - Table maintenance - Gathering statistics - Hands-on: Monitoring extent usage Using indexes - Index types - Creating an index - Reorganizing and rebuilding indexes - Hands-on: Monitoring index growth

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.
1-877-298-1322