Best of PL/SQL - (1 Day Workshop) - by Steven Feuerstein

Oracle PL/SQL expert, evangelist, author and trainer

The Best of Oracle PL/SQL

 

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.

 

This one-day seminar teaches attendees about the most important features of the PL/SQL language. Steven then takes you beyond the basics to show you how to apply these features in the context of best practices, so that you can and will write highly optimized and easily maintained and enhanced applications.

 

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. 

Prerequisites

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.

Seminole Community College Sanford/Lake Mary Campus, CROP auditorium near the V building. (see directions and map links below)

http://www.scc-fl.edu/slm/

This is an all day workshop.  Materials, books, and food provided (breakfast, lunch, snacks, coffee, water and sodas) with raffles and book signings at the end. A detailed agenda and schedule will be posted shortly and all registrants will be periodically emailed updates with additional useful information.

Directions: http://www.scc-fl.edu/slm/directions.php

Map: http://www.scc-fl.edu/media/maps/slm-campus-map.pdf

(A more detailed map with annotations marking the auditorium and access routes will be posted shortly and emailed to all registrants.)

Parking: Park in the Visitor Parking Lot in front of the V Building (see map). Signage will be in place to direct traffic to parking and attendees to the CROP auditorium.

PAYMENT

Payment: Please register in advance on-line at via link to the left, and pay $150 per seat

via PayPal to the CFOUG PayPal account: cfoug_admin@cfoug.org

Or by check at regular CFOUG meeting: http://www.cfoug.org

Or by mail to (Make checks payable to: "Central Florida Oracle Users Group"):

Membership Chairperson  Central Florida Oracle Users Group P.O. Box 780321 Orlando, FL 32878-0321

More information, email: cfoug_admin@cfoug.org