Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and S

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

• 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.
• Tecognize 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.