Best Practice PL/SQL

Download Now! (.75 MB, Updated: May 04, 2006)

Detailed Description

Designed especially for Oracle Scandinavia, Best Practice PL/SQL with Steven Feuerstein is a one-day whirlwind guide to the best that PL/SQL has to offer and the best practices for writing faster, more modular and eminently maintainable applications.

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.

Steven Feuerstein, one of the world's leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 12 years and has developed a deep understanding of how best to build applications with this language.  He will share what he has learned with Oracle technologists in Scandinavia in May 2006.

The Best Practice PL/SQL one-day seminar will focus on N critical areas of development:

  • Writing SQL in PL/SQL: SQL statements lie at the heart of any PL/SQL application and PL/SQL makes it incredibly easy to write that SQL. This means that most of us take SQL totally for granted, which is a big mistake, since SQL statements are the slowest elements of our code and often need changing.  Steven will show you how to take advantage of best features of PL/SQL for writing SQL and also offer best practices for writing SQL statements that can be more easily maintained and optimized.
  • Optimizing performance of PL/SQL applications: beyond SQL, there are many concerns and ways to improve the performance of one's PL/SQL code.  From new features to the careful application of long-standing features, Steven will show you how to analyze code performance and, at least in some cases, improve it by one or more orders of magnitude.
  • Unit testing PL/SQL programs: let's face it, few of us test our code sufficiently.  Who has the time?  And how are you supposed to write that code, anyway?  In this section of the course, Steven offers "six simple steps to unit testing happiness" that will utterly transform the quality and quantity of your PL/SQL testing.
  • Building modular, reusable code: just say "no" spaghetti code that is impossible to read, maintain, or enhance.  In this section, 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.
  • Error management: every well-crafted application follows a standard, consistent process for handling, raising and reporting errors.  PL/SQL offers a powerful, flexible exception handling architecture, but it has its weaknesses.  Steven will show you how to compensate for those weaknesses, take advantage of the latest error management features, and build a reusable package to log and raise exceptions.


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.

Oracle Version

Steven will demonstrate techniques and principles that apply to all versions of Oracle, but will also showcase new features in Oracle Database 10g that can dramatically improve the quality and performance of code that you write.

Download Now! (.75 MB, Updated: May 04, 2006)


Copyright © 2003-2006 PL/Solutions. All Rights Reserved.