| |
Steven Feuerstein, generally considered the world's leading PL/SQL expert, will be presenting his all-new, 2-day, "Higher Performance PL/SQL and Oracle 11g PL/SQL New Features" seminar on July 23 & 24 at Level 3 Communications in Broomfield, CO. The cost is $600 for RMOUG members and out-of-state registrants and $700 for non-members.
In 2012, the Oracle PL/SQL language will celebrate its 23rd birthday. Not bad for a language that initially found its application inside SQL*Forms V3 and is now widely regarded as the most powerful, flexible and well-structured relational database programming language.
Twenty-three years also has provided Oracle with lots of opportunity to enhance PL/SQL, which makes it ever more challenging for programmers to keep up with all the enhancements.
This two-day training covers the most critical features you need to know about if you are going to write PL/SQL programs that fully utilize the capabilities of PL/SQL, including the most important enhancements of Oracle Database 11g.
Detailed Description of Topics to be Covered- Bulk Processing with BULK COLLECT and FORALL: the most important performance optimization feature of PL/SQL, bulk processing turbo-charges the speed of repeated execution of the same SQL statement (think: DML inside a loop) by reducing the number of context switches. We'll explore every nook and cranny of BULK COLLECT and FORALL.
- The Function Result Cache (11g): a fantastically elegant and high-impact feature, the function result cache provides an SGA-based cache that helps you optimize the performance of queries across an entire instance that repeatedly retrieve the same rows of data.
- Row-Level Error Suppression in DML: added in Oracle Database 10g Release 2, the LOG ERRORS clause (along with the built-in package, DBMS_ERRLOG) offers row-level suppression of errors in DML statements, especially helpful when modifying large numbers of rows.
- PL/Scope (11g): new to Oracle Database 11g, PL/Scope analyzes the way that all identifiers (variables, constants, subprograms, exceptions, types, etc.) are used in your code. It allows us to perform analysis on our code in a way never before possible. For example, you can implement your own scripts to check code for compliance with naming conventions - no parser required!
- The NOCOPY Hint: so simple, and yet so impactful. Add one keyword to your IN OUT parameter definition and get a significant boost in performance. Along the way, learn about the difference between formal parameters and actual argument values, passing by reference vs. value.
- Dynamic SQL Advanced Features: Oracle Database 11g includes many enhancements for dynamic SQL, especially for Method 4 dynamic SQL.
- Advanced Collection Features: the year is 2012 and all PL/SQL developers should be aware of and use collections (PL/SQL's version of arrays). So we'll skip the basics and concentrate on advanced features like use of the TABLE operator, string-indexed associative arrays, and nested collections.
PrerequisitesA working knowledge of PL/SQL and at least a year's worth of experience with the language. All developers, from beginner to expert, will benefit from Steven's ideas and examples.Oracle VersionSteven will demonstrate techniques and principles that apply to all recent versions of Oracle, but will also showcase new features in Oracle Databases 10g and 11g that can dramatically improve the quality and performance of code that you write.
We will finish with a quiz on the topics covered, and prizes awarded to the top 10 scorers. Winners will be announced at the PL/SQL Challenge website, where thousands of Oracle technologists play daily, weekly and monthly quizzes on PL/SQL, SQL and APEX.
|
Status: |
Completed
|
| |
Speaker: |
Steven Feuerstein |
| |
Location: |
Level 3 Communications
1025 Eldorado Blvd.
Broomfield, CO 80021
|
| |
Sponsor: |
Rocky Mountain Oracle Users Group |
| |
Date: |
Jul 23, 2012 - Jul 24, 2012 |
| |
Price: |
$600.00 for RMOUG members ($700.00 for non-members) |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Registration Closed |
|
|
|
|
|
|
There are no seminars on the
calendar at this time.
View all Seminars |
