Oracle - Oracle Database 11g: SQL and PL/SQL New Features
Seminar
In Gummersbach, Düsseldorf und Dresden
Beschreibung
-
Kursart
Seminar
-
Ort
-
Dauer
2 Tage
-
Beginn
auf Anfrage
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.
Standorte und Zeitplan
Lage
Beginn
Beginn
Beginn
Beginn
Beginn
Hinweise zu diesem Kurs
Siehe Inhalte und Zielgruppe
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- SQL
- PL SQL
- Oracle Datenbanken
Inhalte
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
Oracle - Oracle Database 11g: SQL and PL/SQL New Features