Oracle Database 11g: Using DDL, Views, and Schema Objects

Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Using DDL, Views, and Schema Objects

recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.

recognize the steps for using constraints to prevent invalid data entry into tables.

recognize the steps for altering or dropping a table.

identify the steps for creating and manipulating views to view or hide a table's data.

recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.

create a new table and create and use a sequence, index, and synonym.