Click here for a full listing of presentations

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