Using Advanced Features in Oracle 10g

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To outline the processes and considerations for using the advanced features of Oracle Database 10g

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
1.2

Lesson Objectives

Using Advanced Features in Oracle 10g

identify the steps required to use the resumable statements feature.

create an external table.

create and configure materialized views.

enable resumable statements and create external tables and materialized views.

Course Number:
221276_eng