Oracle PL/SQL Expertise On-Line with Steven Feuerstein - November 2009

Steven Feuerstein

Oracle PL/SQL Expertise On-Line:
In-depth training
 
Start date: 24 November 2009
 
Oracle University is proud to present
Oracle PL/SQL Expertise On-Line: In-depth training
with Steven Feuerstein

This is a unique opportunity to attend an online Seminar with one of Oracle's most experienced
PL/SQL Gurus, consisting of two and half hour sessions over three consecutive days.


Steven Feuerstein
Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL (all published by O'Reilly Media). Steven, an Oracle ACE Director, has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. Steven's online technical cyberhome is located at www.ToadWorld.com/SF.

Quotes from the attendees:

"The class gave me energy to move on for 10 more years. It is very exciting to exchange information with people that do their job with passion."

"Thanks for organising the event. Although I'm just getting started with PL/SQL again after many years of not touching it, I found the talk very informative and interesting. Several areas (length of code sections and encapsulation) were, I think, equally applicable to other areas of programming."


Join us for this novel and original Celebrity Seminars virtual series designed to combine compacted learning experiences with virtual discussions right from your desktop.

Seminar description:

Each training session gives you the opportunity to gain deep insight into PL/SQL. These highly advanced sessions will cover the following:
  • 24 November 2009 2PM - 4:30PM CET - Programming with Collections:

    Collections (array-like structures in PL/SQL) are critical data structures that are used in some of the most important features of PL/SQL. Every PL/SQL developer should have a deep familiarity with collections and the wide range of features that Oracle has implemented for them over the years.

    This session introduces collections and quickly moves on to detailed explanations of collection methods, how to leverage string indexing in associative arrays, multi-level collections, set-level operations on nested tables and more.

    After attending this webinar, you will be well-positioned to apply collections in your every day development and, most important, take advantage of features like BULK COLLECT and FORALL to improve application performance.


  • 25 November 2009 2PM - 4:30PM CET - Say Goodbye to Hard-Coding in PL/SQL:

    Everyone knows that hard-coding is a bad idea. Too many developers, however, only think in terms of literal values when they think of hard-coding. There are, unfortunately, many ways that hard-coding manifests itself in our programs.

    This webinar offers a comprehensive look at all the types of hard-coding that can appear in your programs, from literals to explicit declarations to exposed formulas, and offers specific techniques to get rid of the hard-coding. The result is code that is much easier to read and to maintain.

    After attending this webinar, you will be able to more easily and quickly identify hard-codings, and apply well-understood and safe transformations to remove those hard-codings.

  • 26 November 2009 2PM - 4:30PM CET - Dynamic SQL in Oracle PL/SQL:

    Dynamic SQL (construction, parsing and execution of SQL statements and PL/SQL blocks at runtime) has become a common and critical element of most modern applications. PL/SQL offers two distinct methods for dynamic SQL: native dynamic SQL (NDS) and DBMS_SQL.

    This webinar focuses primarily on the capabilities of native dynamic SQL: how to use EXECUTE IMMEDIATE to execute dynamic query, DML, and DDL statements. We will also go beyond the basics and delve into when to use DBMS_SQL (method 4 dynamic SQL), and new Oracle Database 11g features for dynamic SQL (most importantly, interoperability between DBMS_SQL and NDS.

    After attending this webinar you will be able to quickly identify the type of dynamic SQL challenge you face and from there apply the correct PL/SQL functionality to get the job done.
Click here for more information and to Book
Register now!
Do not miss this unique opportunity
to advance your skills in Oracle PL/SQL
PLEASE NOTE: When you register for this event it will appear you are booking for an event on the 26th of November only. This is not an error but due to constraints within our booking system. Please do proceed with your booking and you will in fact receive the details for access to all 3 events.
E-mail this page