Imate žicu za učenje?

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

Overview/Description
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
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.7

Lesson Objectives

Oracle Database 11g: 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 in data.
  • manipulate large data sets using multitable INSERT and MERGE operations.
  • Trajanje: 
    1,5 h
    Šifra: 
    257876_ENG

    Koraci do učenja

    1Prijavi se

    Prijavite se, a ako nemate korisničko ime, registrirajte se.

    2Pronađi i upiši program

    Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

    3Uči

    Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

    »Detaljne upute