So to those contemplating it, just go for it. It's like riding a bike. And you learn so much about Oracle when you're essentially forced to tinker & play.
I've got a label in my blog for all things presentation related - announcements, suggestions, experiences...
Below is a list of presentations I've done so far at various user group events.
(And yes, it turns out I'm a fan of alliteration)
Updated late March 2013 - prezi link for reasons to upgrade
Reasons why you should upgrade your APEX environment - Discover how APEX 4.x makes your life easier ( prezi | bookmark )
Unless you truly pick things apart, version numbers don't proffer much to explain the differences between product releases.
Over time with Application Express I have taken note of the differences, and I might suggest you'd barely call APEX 4.2 even the same species as 3.2 - it has evolved fantastically!
We've seen the introduction of Dynamic Actions, Plug-ins, support for mobile, improved security - all of which lead to improved productivity, more user friendly applications and ongoing support.
We'll explore the growing tree that is Application express with a relatively unique presentation style -and we'll will climb it all the way to the canopy, exposing what's ahead with APEX 5.
DBAs will gain awareness, Development Managers will get ideas, Business Analysts will see options, and Developers can get some details.
AUSOUG WA Branch Meeting 2013
Mobile development had beginnings even prior to Oracle Application Express 4.x, but with 4.1 itching to be a true mobile development platform - only held back by the jQuery library - APEX 4.2 has arrived with it as standard armory in the utility belt.
Before coming along you can check out a sample application used this presentation by visiting apex.oracle.com/pls/apex/f?p=SW2012 (via tinyurl.com/SW2012AUSOUG)
Use this application to register (anonymous) interest in presentations you may consider attending, then to provide feedback on each session.
Then come see how the sausage was made; what you may expect to see out of APEX
mobile development in the future; and what you need to consider learning before putting on
AUSOUG WA Conference 2012
There have always been many options for securing Oracle APEX applications, and many of them don't require much effort - just a little understanding.
This presentation will cover all things APEX Security. Scott covers discussions and examples of many of APEX's security features, including changes to Authentication & Authorisation in 4.1 towards using plug-ins.
AUSOUG WA Conference 2011 - Awarded Best Paper
Insync Melbourne Conference 2012
Oracle APEX Performance ( pdf | prezi | bookmark )
I will go through various performance tweaks (not tweets) for Oracle Application Express without limiting myself to a golden number.
These improvements will vary from simple PL/SQL refactoring; to monitoring for bottlenecks in your application; to cutting down maintenance time - which relates to the performance of you as an Oracle developer with only 24 hours in a day.
We may even visit a little APEX instrumentation on the way.
AUSOUG WA Conference 2010
AUSOUG SA Conference 2011
InSync Sydney Conference 2011
AUSOUG SA Conference 2011
InSync Sydney Conference 2011
APEX with Oracle Text ( pdf | inline | bookmark )
Oracle Text is a facility within the database that provides more advanced indexing & search techniques - including the ability to index documents stored in your database; on your server; or even the web!
Now you can incorporate this functionality into your web application using Oracle Application Express.
This presentation will demonstrate how easy it is to combine the two, and give you a platform for further expansion and exploration within a very powerful product.
AUSOUG WA Branch Meeting 2010
Trials & Tribulations of an Oracle Forms -> APEX Conversion ( pdf | bookmark )
Abstract: One of the hot topics these days questions how long you should keep hold of your long standing, hard working Forms application. Oracle support timeframes for Forms has been quite fluid over recent years and ultimately you may need to make a move..
Depending on the size and complexity of your application, a number of options present themselves.
Oracle Application Express is one such option. The question remains, however, is there some black box tool we can use to plug our Forms in and have it pump out APEX pages? And how much assistance does this tool need before and after the conversion process?
This presentation will cover some of the considerations you may need to make when contemplating this event. We'll show what happens when you convert a form with various types of components and reveal the gaps, if any, you'll find at the other end.
Let's not forget the other components of our Forms application. What about PL/SQL libraries, reports, menus? Is it worth tackling some of these items manually? We shall see...
AUSOUG WA and Vic National Conference 2009 - Oracle ACE ODTUG Stream
Oracle Documentation ( inline | bookmark )
Abstract: If you're a database developer, regardless of whether you have 6 months or 6 years experience, you need a good reference manual.
By good, I mean one that you can locate what you need within seconds. I know you know what I mean...
I'd like to show you how easy the free Oracle supplied documentation really is to use. And if for some reason it still doesn't cater to your needs, I'll show you some other methods and destinations that might save you a few headaches.
In this short presentation, I'll show you how to find most day to day documentation requirements in 2 clicks, maybe 3 if you're unlucky - without connecting to the net.
You might also hear some other new words such as Ubiquity & Bookmarklets.
AUSOUG WA Branch Meeting 2009
11g New Features ( inline | ppt | bookmark )
Abstract: There are a wealth of new features available in the 11g database release. This presentation touches on SQL & PL/SQL features I found of interest, and concentrates particularly on virtual columns.
Relevant scripts are available here.
ACTOUG May 2009
Creative Conditional Compilation ( inline | ppt | bookmark )
Abstract: Oracle released a feature in 10g Release 2 they thought worthy of facilitating in previous versions via patch sets - so I thought it was worthy enough for a closer look.
Conditional compilation isn't a foreign concept in the programming world, and for the developer aficionado it's a wonderful paradigm to explore.
Conditional compilation was designed with the main intention of being able to create database version specific code. With the recent advent of 11g, developers can actually start adding 11g features to their 10g code today!
However it provides the savvy PL/SQL developer to enhance their code in more ways than just gearing up for the next release… Dust of your software engineering hats and discover how to utilise conditional compilation to explore concepts such as latent self tracing code; latent assertions; and enhanced prototyping for your unit tests.
This seminar will illustrate several examples of conditional compilation that will open your mind; ultimately benefit your users; and can be implemented as far back as 9.2!
AUSOUG WA and QLD National Conference 2008
AUSOUG VIC Branch Meeting 2009
AUSOUG Qld Branch Meeting 2010
Be a Bulk Binding Baron ( inline | pdf | bookmark )
Abstract: Developers - If you are not using Bulk Binds you are not writing PL/SQL efficiently!
Bulk binding has been around for a long time, yet there are sites out there that don't utilise this feature to its full extent, if at all. Every release of Oracle improves on this functionality so obviously it's a topic worthy of consistent awareness.
In PL/SQL and SQL, there are a few nifty features related to bulk binding you may not have seen - it's not all about BULK COLLECT. Whether you're on 8i, 11g or anything in between, you'll benefit from the concepts described in this seminar and become a Bulk Binding Baron!
AUSOUG WA Branch Meeting 2008
AUSOUG SA Conference 2011
The Model Clause ( inline | bookmark )
Abstract: The session will breakdown the Model clause into its fundamental components and provides some basic real-world examples to demonstrate its greater potential.
Though most developers have heard of the SQL Model clause in 10g, many may baulk at the idea of using it - daunted by seemingly foreign syntax that might well have come out of a FORTRAN program.
Look a little closer and you'll find it's just like building a spreadsheet. Concise, easy to read syntax that provides the functionality for demanding calculations that would normally require elaborate joins, unions, analytics or PL/SQL. In addition to the development and maintenance burden, we are also faced with the all too familiar problem of business customers duplicating data to an Excel spreadsheet that is shared and erroneously modified around the workplace.
This session uses the Model clause as a high performance tool that can simplify approaches to every day problems. It demonstrates that Model is an extension to SQL that forms multi-dimensional arrays with inter-row & inter-array calculations that automatically resolves formula dependencies.
AUSOUG WA and VIC National Conference 2007