ODTUG OPP Agenda

Preliminary Agenda (Check for updates regularly)

AGENDA - November 10
7:00 - 8:00	Registration
8:30 - 8:45	Welcome and Orientation
8:45 - 9:45	Keynote: Guaranteeing Application Success Steven Feuerstein (Quest Software)
9:45 - 10:00	Break
TRACK	Track 1	Track 2	Track 3	Track 4	Track 5
		FUNDAMENTALS		DEEP DIVE	TOOLS TRACK
Session 1 10:00-11:15	APEX for PL/SQL Developers Scott Spendolini, Sumner Technologies	Writing SQL in PL/SQL Warren Capps Illuminations		*Conditional Compilation* Bryn Llewellyn Oracle Corporation	*Writing PL/SQL Productivity Gains with Oracle SQL Developer* Kris Rice Oracle Corporation
11:15 - 11:30	Break
	APPLIED PL/SQL	FUNDAMENTALS	PERFORMANCE	BEST PRACTICES	TOOLS TRACK
Session 2 11:30 - 12:45	Introduction to Oracle and XML John King King Training Resources	Modular Construction in PL/SQL Mary Gable Preferred Training Solutions	Pipelined Table Functions Patrick Barel, AMIS	Automated Testing Options for PL/SQL Steven Feuerstein Quest Software	Toad Hidden Treasures for Developers Ben Boise, Quest Software
12:45-1:45	Lunch
	APPLIED PL/SQL	FUNDAMENTALS		BEST PRACTICES	TOOLS TRACK
Session 3 1:45-3:00	Manipulating XML through the XMLType John King King Training Resources	Introduction to Dynamic SQL Warren Capps Illuminations		Doing SQL in PL/SQL: Best and Worst Practices Bryn Llewellyn Oracle Corporation	Toad Tips and Tricks for DBAs Ben Boise, Quest Software
3:00 - 3:15	Break
	APPLIED PL/SQL	FUNDAMENTALS	DEEP DIVE	DEEP DIVE	TOOLS TRACK
Session 4 3:15-4:30	Using PL/SQL APIs to Manage XML Data John King King Training Resources	Introduction to Collections and Records Mary Gable Preferred Training Solutions	Advanced Capabilities with Collections Steven Feuerstein Quest Software	Object-Oriented Development With PL/SQL Don Bales Computer applications consultant
4:30-4:45	Break
	APPLIED PL/SQL	PERFORMANCE	BEST PRACTICES		TOOLS TRACK
Session 5 4:45-6:00	Optimizing XML Performance in PL/SQL John King King Training Resources	*Performance Instrumentation* Karen Morton, Agilex	Error Management for PL/SQL Applications Steven Feuerstein Quest Software		*PL/SQL Developer: Tips and Tricks* Patrick Barel, AMIS
	Reception

DATE	November 11
8:00 - 9:15	Keynote: Implementing online application upgrade using edition-based redefinition Bryn Llewellyn (Oracle Corporation)
9:15 - 9:30	Break
TRACK	Track 1	Track 2	Track 3	TRACK 4
	FUNDAMENTALS	APPLIED PL/SQL	PERFORMANCE	TOOLS TRACK
Session 6 9:30 - 10:45	Introduction to PL/SQL Exceptions Mary Gable Preferred Training Solutions	PL/SQL Internet Programming John Jeunnette Prairie Systems, Limited	Optimizing SQL with Collections Patrick Barel, AMIS	Automating testing options for PL/SQL Steven Feuerstein Quest Software
10:45 - 11:00	Break
	BEST PRACTICES	APPLIED PL/SQL	PERFORMANCE	TOOLS TRACK
Session 7 11:00 - 12:15	How to Write SQL Injection Proof PL/SQL Bryn Llewellyn Oracle Corporation	Stateless Application Issues John Jeunnette Prairie Systems, Limited	*Writing Modular Code* Warren Capps Illuminations	*Data Modeling with Oracle SQL Developer Data Modeler* Kris Rice Oracle Corporation
12:15 - 1:15	Lunch
	BEST PRACTICES	APPLIED PL/SQL	DEEP DIVE	TOOLS TRACK
Session 8 1:15 - 2:30	Writing Maintainable Code Don Bales, Computer Applications Consultant	Advanced PL/SQL Web Toolkit Topics John Jeunnette Prairie Systems, Limited	*Globalization and Localization in PL/SQL Applications* Ron Hardman Academy OnDemand	Oracle SQL Developer: User Extensions, Tuning and other Interesting features Kris Rice Oracle Corporation
2:30 - 2:45	Break
	BEST PRACTICES	DEEP DIVE	APPLIED PL/SQL	TOOLS TRACK
Session 9 2:45-4:00	Doing SQL in PL/SQL: Best and Worst Practices Bryn Llewellyn Oracle Corporation	Advanced Testing Topics Finn Ellebaek Nielsen Ellebaek Consulting ApS	Implement Search with PL/SQL and Oracle Text Ron Hardman Academy OnDemand

Two days of seriously practical, intensive training on the latest developments in Oracle's PL/SQL, including best practices, internet programming with PL/SQL, testing, and much more. Our expert PL/SQL instructors include:

Steven Feuerstein, PL/SQL Evangelist, Quest Software, author of Oracle PL/SQL Programming and Oracle Magazine's 2006 PL/SQL Programmer of the Year
Bryn Llewellyn, PL/SQL Product Manager, Server Technologies Division, Oracle Corporation
John Jeunnette, President, Prairie Systems Group, Limited and former Oracle Development Tools User Group President
Mary Gable, President, Preferred Training Solutions, Inc.
Ron Hardman, coauthor of Expert Oracle PL/SQL and Oracle Database 10g PL/SQL Programming

An ODTUG Seriously Practical Conference | 910.452.7444 | www.odtug.com