Training

2 Day class in Needham, Ma.

Two-Day Training
Sponsored by DOAG (German Oracle User Group)

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.

2 day Seminar by Steven Feuerstein hosted by AMIS Services (8 and 9 December).

A day with Steven Feuerstein - world renowned trainer of Oracle professionals, presenting: "Must Know Features of Oracle PL/SQL"

Description:

Best Practices for PL/SQL
Development in APEXPresentation Date: to come Time: to come

Say Goodbye to
Hard-coding!Presentation Date: 6/29/2011 Time: 4:15 PM-5:15 PM

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.