Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets

This course is included in our On-demand training solution.

Overview

To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.

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

100 min.

Course Objectives

Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets

  • identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.
  • query the appropriate dictionary views to find information about schema objects in a given scenario.
  • recognize the steps for manipulating data using subqueries and explicit default values.
  • identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes to data.
  • manipulate large data sets using multitable INSERT and MERGE operations.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?