Oracle Database 10g: Managing Schema Objects and Data

Overview/Description
To demonstrate how to manage schema objects and data in an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
180 Minutes

Objectives:

Oracle Database 10g: Managing Schema Objects and Data

  • identify the basic features of objects in a database schema.
  • recognize how to create and modify tables in an Oracle 10g database.
  • create, delete, and modify tables in an Oracle 10g database.
  • recognize how to create indexes and views and use sequences in an Oracle 10g database.
  • work with indexes, views, and sequences in an Oracle 10g database.
  • manipulate tables, indexes, and views in an Oracle 10g database.
  • recognize how to manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands.
  • recognize how to use Oracle's Data Pump to export and import data.
  • export and import data using Oracle's Data Pump utility.


    • Course Number: 211327_eng