"Best of Oracle PL/SQL" with Steven Feuerstein
2-Day Class in Needham, MA
Watch Steven discuss BULK COLLECT in this clip from his preview webinar.
Watch Steven's full 1-hour webinar, "Look What You Can Do With PL/SQL!", a preview of this 2-day seminar (login or free registration required).
Instructor: Steven Feuerstein
Upcoming Class Schedule
|April 5-6||9am–5pm||Sheraton Needham||Enroll Now|
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.
Over its lifetime, PL/SQL has grown increasingly robust and complex. Many programmers are barely aware of the new capabilities of PL/SQL, much less fully understand the implications for their programs. And virtually all PL/SQL developers are too pressured by deadlines to have the time to think through the best way to apply PL/SQL's many features.
In this two-day seminar you'll learn about the most important features of the PL/SQL language, focusing on the major advances in Oracle Database 10g and Oracle Database 11g. Steven will then take you beyond the basics and show how to apply these features in the context of best practices, so you write highly optimized, and easily maintained and enhanced, applications.
Steven will demonstrate techniques and principles that apply to all versions of Oracle, but will also showcase new features in Oracle Database 10g and 11g that can dramatically improve the quality and performance of your code.
- After attending this seminar, you will be ready and able to:
- Improve query and DML performance by an order of magnitude or more with BULK COLLECT, FORALL and PL/SQL collections (array-like structures).
- Unit test your PL/SQL subprograms like never before, utilizing the processes and tools Steven offers in his "six simple steps to unit testing happiness."
- Optimize the construction of your SQL statements in PL/SQL programs, both from the standpoint of performance and maintainability.
- Build modular, reusable code: Steven will show you how to take advantage of packages, local subprogram units, cursor variables, autonomous transactions, and more to craft small, reusable units of code.
- Manage errors by following a standard, consistent process for handling, raising, and reporting errors.
- Apply collections, a critical but under-utilized data structure, to solve a wide variety of problems, from slow query performance to mutating table trigger errors.
- Take advantage of both forms of dynamic SQL in PL/SQL to write the kind of flexible programs that are required in a world driven by the Internet.
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."
"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."