Best of Oracle PL/SQL Seminar - (PL/SQL Seminar)

Register by March 12 and pay by April 12 and this 2-day event is just $650 for DOUG members ($700 for non-members).

Price increases by $50 ($700/$750) if you register after March 12, 2010.

Compare to Oracle Corporation's $1500, plus travel expenses, for a generic instructor.

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 two-day seminar, created specially for Oracle UK, teaches attendees about the most important features of the PL/SQL language, focusing on the major advances in Oracle 9i Database and Oracle Database 10g. Steven then takes you beyond the basics to show you how to apply these features in the context of best practices, so that you 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.
• 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.

Prerequisites

Oracle Version

Download Presentation at: http://www.oracleplsqlprogramming.com/bestOraclePLSQL.html

Steven's free evening presentation

	Status:	Completed
	Speaker:	Steven Feuerstein
	Location:	SMU-in-Legacy Campus 5236 Tennyson Parkway Building 4 - Room 122 Plano, TX 75024-3544
	Sponsor:	Dallas Oracle Users Group
	Date:	May 11, 2010 - May 12, 2010
	Price:	$700.00 for DOUG members ($750.00 for non-members)
	Agenda   Speaker Info   Sponsor Web   Waiting List Driving Directions Nearby Hotels   Registration Closed Please note that check in and complimentary breakfast is from 8:30 to 9:00 and the seminar runs till 4:30.