Database Objects in Oracle Database 10g

Overview/Description
To demonstrate how to create database views, sequences, indexes, and synonyms

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
1.9

Lesson Objectives

Database Objects in Oracle Database 10g

create simple and complex views in Oracle 10g.

modify, remove, and perform DML operations on views.

create and modify views in Oracle 10g.

use sequences in Oracle 10g.

create and remove indexes and synonyms.

create a sequence, index, and synonym.

Course Number:
223295_eng