Looking for a way to strengthen your PL/SQL skills without leaving your cubicle? Then I encourage you to talk to your manager about enrolling in or more of the following Quest-sponsored webinars:
Back by popular demand! Steven Feuerstein, Quest Software’s PL/SQL Evangelist and one of the world’s leading experts in the language, will conduct a third series of webcasts that will put you on the fast track to maximizing your understanding and use of Oracle PL/SQL. Attend this Quest-exclusive series of webcasts delivered by Steven and gain invaluable techniques and insights that you can put to work immediately. You will learn how to make the most of PL/SQL to dramatically improve the quality and performance of your programs. Steven will also answer questions from attendees during a live Q&A session at the end of each webcast. Each webcast lasts approximately two hours.
Session 1: Programming with Collections
Monday, September 27, 2010 at 2:00 p.m. Eastern ($200.00 US)
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. The session will run for approximately two hours.
Session 2: Say Goodbye to Hard-Coding in PL/SQL
Wednesday, October 6, 2010 at 2:00 p.m. Eastern ($200.00 US)
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. The session will last approximately two hours.
Session 3: Dynamic SQL in Oracle PL/SQL
Wednesday, October 20, 2010 at 2:00 p.m. Eastern ($200.00 US)
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. The session will last approximately two hours.