Training

A two-day course that focuses on the latest and greatest PL/SQL features, with an emphasis on Oracle11g enhancements. Sponsored by Oracle Corporation, get more information and register here.

Although writing code is very important, it is just one aspect of building applications and fully leveraging PL/SQL. As your code volume increased and as Oracle offers more and more options for configuring PL/SQL, it becomes more important to take full advantage of advanced PL/SQL compiler features, data dictionary views and so much more. This webcast shows developers how to correctly apply the PL/SQL compiler optimizer, compile-time warnings and conditional compilation.

Training delivered to your desktop: Oracle PL/SQL makes writing SQL incredibly easy. In fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result is that the same or similar SQL statements are repeated throughout the application, making it very hard to optimize and maintain code. This session starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL.

This first session in the three-part series takes an in-depth look at I/O (input/output). Even though most activity in PL/SQL programs involves interaction with the Oracle database, programs often find it necessary to perform I/O operations on files, display output on the screen (system output) and send e-mail. You will receive detailed information on how to use the UTL_FILE package to read and write files. The session then expands beyond the UTL_File package to explore the use of Java Stored Procedures and external tables to interact with files.

I will be in Berlin to present my two day, Best of Oracle PL/SQL training. This event is sponsored by the German Oracle User Group (DOAG). For more information and to register, click here.

Join PL/SQL Evangelist of Quest Software and author of Oracle PL/SQL Programming for his two-day class, "Best of Oracle PL/SQL." In this two-day in-classroom 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. More information here.

Back to Europe for a two day training sponsored by Trivadis, a highly regarded consulting/training firm and Quest Software partner. If you live in or near Zurich, I hope you will not miss this opportunity to, well, hang out and listen to me talk at you for two days!

For more information and to register, click here.

Back to Europe for a two day training sponsored by Trivadis, a highly regarded consulting/training firm and Quest Software partner. If you live in or near Frankfurt, I hope you will not miss this opportunity to, well, hang out and listen to me talk at you for two days!

For more information and to register, click here.

I will head down to Florida in December (ah, what a hardship!) to do a one-day version of my "best of" course on PL/SQL. Here is the general description below. Click here for more information and to register.