Lunch with Steven Feuerstein:
1, 2 or 3 Afternoon PL/SQL Sessions

Oracle ACE Director Steven Feuerstein is an expert on the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices. He is Quest Software's PL/SQL Evangelist and has been developing software since 1980. He's twice received the Oracle Magazine PL/SQL Developer of the Year award and was the first recipient in 2009 of ODTUG's Lifetime Achievement award. You can find out more about Steven at www.stevenfeuerstein.com and www.ToadWorld.com/SF.

Session 1: Turbo-charge PL/SQL Execution with Bulk Processing
The focus of this first presentation is on enhancing the performance of multi-row SQL statements executed from within PL/SQL, using FORALL and BULK COLLECT. After attending this seminar, you'll be able to create new programs using the features discussed and use them to redesign existing programs safely for enhanced PL/SQL execution.

Session 2: Writing Maintainable PL/SQL Code
Software managers (and, therefore, their developers) are very focused on delivering applications "on time" (that is, to meet the current production deadline). Sure, that's important. But as (or maybe even more) important is to build applications so that they can be maintained and enhanced without consuming all the resources of the development team (thereby interfering with new development).

This webinar offers a wide-ranging set of techniques to make your code easy to understand and maintain over time. These techniques include: the use of subtypes and local modules; how to activate and check compliance with standards; and encapsulation (information hiding).

Session 3: Error Management Features of Oracle PL/SQL
In the third and final webcast, you'll go beyond the basics of exception handling in PL/SQL to explore the abundance of specialized error management features in Oracle, plus receive recommendations for achieving consistent, robust application construction. After attending, you'll be able to fully leverage PL/SQL error management features and ensure your development team follows best practices for consistent error management.

Prerequisite courses or experience:

You should have a 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.

"I've been coding PL/SQL for 10 years and it's incredible to find I've still so much to learn. To be honest I'd become pretty jaded by the "sameness" of things over recent times, but after your presentation I can say I'm now refreshed and re-invigorated. My excitement and enthusiasm are back! I can't say thanks enough."

—Don, London

"I've been doing software development since 1985, after receiving a degree in Computer Science. I have attended many trainings, seminars, and conferences, but yours, by far, is the best I've ever attended. In fact, I had stopped going to conferences and seminars because I was consistenly dissappointed. However, I found yours refreshing and loaded with ideas, tips, and information. Thanks so much for a most enjoyable and helpful seminar!!!!"

—Timothy, Dartmouth College

"I said to Steven afterwards that he'd "lit a fire," and this has been borne out by the number of people who are talking about improving their approach to PL/SQL. The most concrete outcome is that we have started cross-business-unit discussions of a common set of PL/SQL standards. Also how we can incorporate Steven's ideas as a model of best practice. I personally found the seminar very stimulating and entertaining."

—Tony, British Telecom

"On behalf of the many COUG members who attended your PL/SQL best practices class yesterday I want to say thanks and compliment you on a job well done! I know that many students, myself included, will be able to put at least some of the best practices we learned to immediate use in our daily jobs."

—Tony, COUG

Read reviews of all SkillBuilders classes.