Tables and Indexes in Oracle9i

This course is included in our On-demand training solution.

Overview

To describe how to manage tables and indexes in an Oracle9i database

Target Audience

Anyone wanting to learn about Oracle9i database administration

Prerequisites

An understanding of database concepts and technologies

Expected Duration

180 min.

Course Objectives

Tables and Indexes in Oracle9i

  • describe the various methods used to store user data in an Oracle9i database.
  • describe the various datatypes used in an Oracle9i database.
  • describe how to create tables in an Oracle9i database.
  • create a table in an Oracle9i database.
  • describe the classification of indexes and their types in an Oracle9i database.
  • describe how to create normal B-tree and bitmap indexes in an Oracle9i database.
  • describe how to manage indexes in an Oracle9i database.
  • create an index in an Oracle9i database.
  • rebuild or coalesce an index in an Oracle9i database.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?