Oracle - Oracle Database 11g: SQL and PL/SQL New Features

PROKODA Gmbh
In Dresden, Düsseldorf und Gummersbach

1.260 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Beschreibung

Oracle - Oracle Database 11g: SQL and PL/SQL New Features: Learn the new features of SQL and PL/SQL in Oracle Database 11g by taking this course. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality, triggers, language performance, language usability. This course also explains addition of Secure Files with LOBs, and..
Gerichtet an: Learn the new features of SQL and PL/SQL in Oracle Database 11g by taking this course. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality, triggers, language performance, language usability. This course also explains addition of Secure Files with LOBs, and data warehousing enhancements.

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Dresden
Ostra-Allee 11, 1067, Sachsen, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Kanzlerstraße 4, 40472, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Monschauer Str. 7, 40549, Nordrhein-Westfalen, NRW, Deutschland
auf Anfrage
Gummersbach
Kirchstraße 6, 51647, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

Siehe Inhalte und Zielgruppe

Themenkreis

KURSZIEL
Oracle - Oracle Database 11g: SQL and PL/SQL New Features: Learn the new features of SQL and PL/SQL in Oracle Database 11g by taking this course. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality, triggers, language performance, language usability. This course also explains addition of Secure Files with LOBs, and data warehousing enhancements.

ZIELGRUPPE
Learn the new features of SQL and PL/SQL in Oracle Database 11g by taking this course. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality, triggers, language performance, language usability. This course also explains addition of Secure Files with LOBs, and data warehousing enhancements.

KURSINHALT
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.
Learn To:
  • Practice the performance improvements
  • Monitor dependency tracking and change notification
  • Write compound triggers and use the enhancements made to triggers
  • Use Secure File LOBS
  • Use the SQL Developer interface
  • Write SQL statements that include the new functions added to enhance regular expression support functionality


VORRAUSSETZUNG
Siehe Inhalte und Zielgruppe

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen