Defining and Manipulating Data in Oracle9i

Overview/Description
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
220 Minutes

Objectives:

Defining and Manipulating Data in Oracle9i

  • describe how to create and manage Oracle9i database tables.
  • describe, create, and maintain constraints in an Oracle9i database.
  • create a table, define constraints on a table, and view constraint information.
  • describe how to create and manage views in an Oracle database.
  • describe how to create and manage sequences, indexes, and synonyms in an Oracle database.
  • create views, indexes, sequences, and synonyms in an Oracle database.
  • describe how to use Oracle9i database external tables.
  • describe how to insert, update, and delete data in an Oracle9i database.
  • use DML statements to insert, update, and delete data from an Oracle9i database.
  • explain how database transactions work in an Oracle9i database.
  • explain the use of multitable INSERT statements in an Oracle9i database.


    • Course Number: 67002_eng