Tony's Top 10 Oracle Tips and Tricks for Developers (394Kb) Presented at: Oracle Open World (OOW) Presented by: Tony Catalano Date: 09/23/2008 Abstract: Throughout the years, this session's speaker has accumulated a list of tips and techniques that assist with the development of Oracle Database-based custom applications. These tips and tricks can be used to improve application performance, streamline code, and create higher-quality applications. The speaker describes each topic in detail and provides real-world examples of how to use them.

The PL/SQL Challenge: 15 Key Tips Everyone Must Know (4.47MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover 15 top Oracle PL/SQL tips and features. There are many features and tips that have presented in various presentations throughout the years. There are many features that have been incorporated into Oracle PL/SQL over the past 15 years. This presentation takes 15 of the top features and tips and educates the attendees on the usefulness and power of these top 15. They are all covered with examples throughout the presentation.

Catapult to the New PL/SQL: 10gR1 and 10gR2 Key Features (3.24MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle10g release 1 and release 2. The new features covered include the following: new conditional compilation, new PL/SQL commands (regular expressions), new and enhanced Oracle supplied packages (dbms_output, dbms_ddl wrap procedure, dbms_warning, dbms_stats), new functions, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Time to Master the Other Side - Key Non Technical Traits for Success (4.49MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation focuses on the keys to being successful at your job by applying non-technical skills. Far too often, employees become technically proficient through education, but they are never educated on the other half of the equation - namely, the non-technical skills. These should not be overlooked. The presentation reviews a variety of skills that can be applied to your work environment to make you and your company more effective. The presentation covers the following areas: customer service, change, effective meetings, listening, responding to situations, building a winning team and effective communication.

Take the Plunge: Top New 11g PL/SQL Features (3.87MB) Presented at: Collaborate Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle 11g. The new features covered include the following: new conditional compilation, new PL/SQL commands, new and enhanced Oracle supplied packages, new functions, new enhanced SQL commands, etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Cool Apex Integration with AJAX, YUI, Google Maps, and more. (5.65MB) Presented at: Utah Oracle Users Group (UTOUG) Presented by: Brad Brown Date: 03/14/2008 Abstract: Years ago I used to discuss performing asynchronous activities with the hidden JavaScript page. With the improvements to JavaScript and our use of XML, Asynchronous JavaScript and XML (AJAX) provides functionality we've been using for years, but it's much easier to implement now. This presentation will cover AJAX in a variety of forms. Oracle Application Express (Apex) provides a little known secret called the "On Demand" feature...which allows for AJAX calls back to the database. Google and other companies provide AJAX functionality that you can use for application integration. In this presentation you'll learn how to write your own AJAX server side code and how to make use of existing server side AJAX code. This presentation will also discuss and demonstrate how you can take a series of latitudes and longitudes and turn them into a visual map containing your data using AJAX.

Web 2.0 (8.03MB) Presented at: Northern California Oracle Users Group (NoCOUG) Presented by: Brad Brown Date: 02/19/2008 Abstract: You've heard the term Web 2.0 and might be wondering exactly what it means to you and your business. You might be wondering what Web 2.0 includes. On the other hand, you might be right in the middle of it all, but noticing that more and more Oracle products seem to offer Web 2.0 entry points. Or maybe you're not using Oracle technology for anything but your backend database. You might be wondering which other products should be under consideration? Which should be avoided? What's a good entry point solution?

Arrow of Truth - Conflict Resolution (2.69MB) Presented at: Northern California Oracle Users Group (NoCOUG) Presented by: Brad Brown Date: 02/19/2008 Abstract: Have you ever run into a conflict at work or at home, but you had difficulty resolving the problem? By using the methods described in this presentation (the arrow of truth), you will be able to work through issues that otherwise may appear irresolvable. This method works not just at work, but at home too.