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

Seminarziel

Optimieren sie ihre Oracle DB Performance durch die Verwendung der Oracel 10g SQL und PL/SQL Funktionen. Der Kurs bietet die neuen Funktionen für das Release 1 und 2. LOBs, SQL Konzepte innerhalb eines Data Warehouse und die Neuerungen in Bulk Binding werden angesprochen.
Learn To: o Identify and use the SQL enhancements o Search for complex patterns using regular expressions o Program using the PL/SQL enhancements o Perform inter-row calculations with the SQL MODEL clause o Use the Oracle data types and data enhanced data types o Identify the SQL Enhancements for data warehousing

Zielgruppe

Entwickler, PL/SQL-Entwickler, Systemanalytiker

Voraussetzungen

- Oracle 9i or earlier RDBMS SQL and PL/SQL Knowledge - SQL*Plus or iSQL*Plus tools
Seminarinhalte
o Use the Oracle data types and data enhanced data types o Identify the Large Objects (LOB) enhancements o Write code that uses the nested table and VARRAY enhancements o Identify and use the SQL enhancements o Use Regular Expressions to search for and manipulate complex patterns in string data o Perform a case-insensitive or accent-insensitive linguistic sort using NLS_SORT o Perform a linguistic comparison using NLS_COMP o Identifying the New PL/SQL Compilation Initialization Parameters o Setting and using the New PL/SQL Compile Time Warnings for Subprograms o Use conditional compilation o Obfuscate PL/SQL source code o Use the SQL model clause o Use Analytic Functions in the SQL model clause o Use SQL enhancements for Data Warehousing o Cleanse data using the DELETE clause o Densify data with partitioned outer joins
Sachgebiete:
- Using Oracle Database 10g Data Types
- Using Large Objects (LOB) Enhancements
- Using Nested Table and VARRAY Enhancements
- Using General SQL Enhancements
- Using Regular Expressions and Linguistic Sort and Comparison
- Using the New PL/SQL Compiler
- Programming with PL/SQL Enhancements
- Using the SQL Model Clause
- Using SQL Enhancements for Data Warehousing