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

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

Prerequisite
Familiarity with data processing concepts and techniques

Expected Duration
105 minutes

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.

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.