Oracle Database 10g: Managing Schema Objects and Data Release 2

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 (hours)
3.0

Lesson Objectives

Oracle Database 10g: Managing Schema Objects and Data Release 2

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 the most common index types, 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, views, and indexes 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.