Defining and Manipulating Data in Oracle9i

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

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?