Imate žicu za učenje?

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

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
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.
  • 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.
  • Trajanje: 
    1,75 h
    Šifra: 
    257522_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