Oracle Database 11g: SQL and PL/SQL New Features Ed 1

Global Network Communication
In Wien (Österreich)

1.260 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
-1-37... Mehr ansehen

Wichtige informationen

Tipologie Kurs
Beginn Wien (Österreich)
Dauer 2 Tage
  • Kurs
  • Wien (Österreich)
  • Dauer:
    2 Tage
Beschreibung

In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers. Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhance..
Gerichtet an: PL/SQL-Entwickler Entwickler Systemanalytiker Data Warehouse-Administrator

Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Wien
Nußdorfer Lände, 23, 1190, Wien, Österreich
Karte ansehen
Beginn auf Anfrage
Lage
Wien
Nußdorfer Lände, 23, 1190, Wien, Österreich
Karte ansehen

Themenkreis

In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.

Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features are also discussed in this course. Students also learn about the reengineered LOB data type that offers advanced, next-generation functionality such as intelligent compression and transparent encryption. Additionally, students explore the data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators.

Kursbeschreibung

Sachgebiete

  • Implementing the Language Functionality Enhancements
  • Executing Dynamic SQL in PL/SQL with the 11g Enhancements
  • Utilizing the Performance Improvement Enhancements
  • Practicing the Language Usability Enhancements
  • Coding the Trigger Enhancements
  • Administering Secure-File LOBs
  • Using the Data Warehousing Usability Enhancements
  • Using the SQL Developer Enhancements



Teilnehmerkreis

  • PL/SQL-Entwickler
  • Entwickler
  • Systemanalytiker
  • Data Warehouse-Administrator



Kategorie

Oracle Grundlagen und Sprachen

Sprache Unterlagen

English


User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen