home Agenda Presenters Presentations Register Sponsors Location

ODTUG has assembled the best APEX speakers from across the world and brought them to Montreal for APEXposed! There will be two concurent sessions for most of the conference, so take a look at the presentations below to determine which one is of greatest interest to you.

Tuesday, September 11

Keynote Address: Oracle Application Express Then, Now, and the Future

Joel Kallman, Oracle Corporation

Joel Kallman, director of software development for Oracle APEX, will look at where APEX has come from, how the latest release makes it quicker and easier to build better web applications, and then give insight into where the tool is heading.

9:45-10:45 - SESSION 1

Get Plugged In
Martin D'Souza, ClariFit

Now that APEX plugins have been around for a while, many developers have started to implement them in their applications. Are you a developer that's curious on how to take it one step further and develop your own plugin? This presentation will review what plugins are and provide you with the information required to start developing your own plugins.

APEX Behind the Scenes
Scott Spendolini, Enkitec

Oracle APEX is truly an amazing and robust development platform, enabling developers to build applications to meet almost any requirement. But behind the scenes, this sophisticated development tool is quite simple. This session will explore the inner-workings of APEX and describe just what happens when you view or submit a page. The overall intention of discussing APEX at such a low level is to provide APEX developers - beginners and advanced alike - with a better understanding of the environment, which will enable them to build better applications.

Back to Top

11:00-12:00 - SESSION 2

Oracle Cloud
David Peake, Oracle Corporation
The Oracle Database Cloud Service was introduced as part of the Oracle Public Cloud at OpenWorld in October of 2012. Based on Oracle APEX, the Database Cloud Service has provided a new way to use powerful Oracle technologies. This session will provide an overview of the Database Cloud Service, a historical perspective of the use and adoption of the Service, and some insights into why the Database Cloud Service will be an important part of the computing landscape going into the future.

jQuery in APEX–An Introduction for Database Developers
aceDan McGhan, Skillbuilders

Oracle APEX developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. Luckily JavaScript libraries, such as jQuery, which is integrated into APEX, have made the language much easier to use. In this session, learn about jQuery through a series of analogies, nine in total, which will relate important concepts in the library to what you already know in the database world.

Back to Top

13:00-14:00 - SESSION 3

Using Collections in APEX: The Definitive Intro
ACEDRaj Mattamal, Niantic Systems

Many developers who are new to APEX are unfamiliar with the powerful Collections capability provided with the tool. This session aims to introduce the concept of collections and walk through some of the most helpful use cases for them. Using the APEX-specific examples of a shopping cart, interactive reports with dynamic SQL, and running saved queries, the audience should leave the session feeling comfortable using collections in various scenarios. Although this session will contain demonstrations, the more important goal is to expose the audience to the potential uses of collections even beyond the proverbial shopping cart. The examples of running saved queries and interactive reports are two such atypical uses of collections, and time-allowing, the session will explain the use of collections when manually validating tabular forms (the speaker acknowledges that APEX 4.0 should have addressed the need to use collections for tabular forms, but many of the audience members will still be on prior versions of APEX at the time).

APEX: When Push Comes to Shove (or Using HTML5 WebSockets)
ACEDJohn Scott, APEX Evangelists

This session will cover one of the nice new features in HTML5, namely WebSockets. Rather than using the traditional polling methods to determine when data has changed in your application, WebSockets allow the server to
PUSH notifications to the browser, which has all kinds of implications for scalability and usability of applications. The presenter will show some different ways in which you can use WebSockets in any APEX application to really make your application stand out.

Back to Top

14:15-15:15 - SESSION 4

Websheets, the Hidden Treasure of the APEX Framework
Patrick Cimolini, Patrick International Consulting

Websheets is an under-utilized feature of Oracle APEX. This presentation demonstrates how easy it is to build and update a websheet. Key websheet features will be shown. In addition, a number of websheet styles will be illustrated. The styles will give the attendees insights as to how this versatile tool can be used to build wikis, on-line documentation, and collaborative manuals that can be kept updated and current without the overhead that is usually associated with traditional documentation tools. The presentation will clearly show that a small time investment can pay big dividends when this versatile tool is employed by both development and end user teams.

Dynamic Actions–What's Possible, What's Not, and How to Bridge the Gap
aceDan McGhan, Skillbuilders

Introduced with APEX 4.0, Dynamic Actions have successfully created a declarative interface around the complex event model used by modern browsers. Does this mean that knowledge of JavaScript been rendered useless? In short, no. This session will explore the declarative side of Dynamic Actions to find out exactly what is possible and what is not, but most importantly, it will demonstrate what one would need to know to bridge the gap.

Back to Top

15:30-16:30 - SESSION 5

APEX Listener 2.0

Kris Rice, Oracle Corporation

The APEX Listener went under major changes for the latest release.  Many customer are using the 1.1 release in production environments and have let us know what they'd like to see added to the product.  That feedback and the required changes to support Oracle Cloud have made a major leap forward in features in the new APEXListener 2.0.  Learn how to take advantage of these features in any environment.  The new features including multi database support, built in OAuth2, more tightly coupled RESTful templates, built in FOP, and many many more. The listener is also extensible so if there's something required that is missing anyone can extend the listener!

High Quality PDF Printing with APEX & PL/PDF
ACEDScott Spendolini, Enkitec

Since its introduction, Oracle APEX has evolved from a basic toolkit for small applications to an enterprise-ready platform for applications of almost any size. However, one area has been almost at a standstill since its inception: printing. This session will discuss how to integrate PL/PDF - a 3rd party PL/SQL-based printing solution - with Oracle APEX, so that you can provide your end users with beautiful PDF reports in almost no time. It will use real-world examples and discuss not only basic reports, but also charts, templates, and bar codes.

Back to Top

Wednesday, September 12

8:30-9:30 - SESSION 6

APEX–A CEO’s Perspective
Cameron Mahbubian, ClariFit

Cameron Mahbubian, a Harvard educated executive who is the current president & CEO at ClariFit, gives insights into Oracle APEX. See APEX from a completely different angle: from behind the dev room curtains and straight into the private executive board rooms of America. How did he convince Fortune 500 companies to adopt Oracle APEX in their companies where they hadn't before? What type of demo packs enough punch and delivers enough wow-factor to convince the most skeptical non-technical executive to become excited about APEX vs. what the techie cares about seeing?

Building Mobile Web Applications with Oracle APEX
David Peake, Oracle Corporation

Oracle APEX is a declarative web application development tool for the Oracle Database. It allows the developer to rapidly build applications that run on any platform that supports a web browser, including mobile devices. With smart phones and tablets approaching 10% of all browser usage, building web applications that work well and look good on smaller screens and respond to touch input and gestures becomes increasingly important. To help our customers with building these kinds of user interfaces APEX integrates the jQuery Mobile framework. jQuery Mobile is a unified, HTML5-based user interface system, supporting all popular mobile platforms and built on the jQuery and jQuery UI foundation. This session gives an overview of the basics of jQuery Mobile, explains how it is integrated with APEX, and how customers can quickly build mobile web applications and extend their existing APEX applications with mobile capabilities.

Back to Top

9:45-10:45 - SESSION 7

Best Practices for Agile APEX Development
Patrick Cimolini, Patrick International Consulting

The marriage between Oracle APEX and Agile Software Development (Agile) was made in heaven; they complement each other beautifully. APEX is a tool; an efficient tool that is capable of high productivity. Agile is a process; a seriously practical process that values working software over project governance (bearing in mind that governance has value and is required). This presentation steps through a set of best practices that demonstrate how APEX can be used in ways that explicitly support the core Agile values like individuals and interactions, working software, customer collaboration, and responding to change. These best practices give developers a road map that leads them to a place where the winning combination of APEX and Agile enhances their ability to hit their quality, cost, and schedule targets effectively and efficiently.

SQL Analysis and Tuning for the APEX Developer & DBA
Joel Kallman, Oracle Corporation

All performance problems with APEX applications are deemed APEX problems until proven otherwise; but the vast majority of these are due to improper SQL tuning. DBA's usually have a poor understanding of APEX. APEX developers often have a poor understanding of the information the DBA's are presenting to them. In this session, we will review how to analyze a poor performing application from a DBA's perspective, using the tools most DBA's are familiar with such as Active Session History, Active Workload Repository, TKPROF, and more.

Back to Top

11:00-12:00 - SESSION 8

APEX Maintenance
aceFrancis Mignault, Insum Solutions

Common questions on APEX often are about the infrastructure and on how complex it is to install, maintain, and upgrade. This session will demistify the APEX installation. Architectures, install, upgrade, tablespace management, schema management, installing APEX with EBS, and backups will be some of the subjects covered in this session.

Super Fast Sorting and Pagination in APEX Report Regions ala jQuery
ACEDRaj Mattamal, Niantic Systems

APEX offers many options to sort and paginate data using server-side processing. These techniques can be slow at times, while many client-side and Ajax-based solutions are available to help in such cases. This session will walk through the considerations of client- versus server-side pagination and sorting with APEX applications. With this understanding, the session will show attendees how to implement client-side pagination and sorting in their APEX applications using commonly available jquery plugins. Time allowing, Ajax-based solutions will be demonstrated as well.

Back to Top

13:00-14:00 - SESSION 9

APEX 4 Error Handling Enhancements
ACEDJohn Scott, APEX Evangelists

Let's face it, no application is perfect, but how you handle the errors in your application can make a big difference to how your end users perceive your application. With the new error handling capabilities in APEX4 you can do some truly amazing things. In this session I will show practical uses for what is possible and just how far you can take it.

APEX 4 + HTML 5 = Awesome
ACEDMartin D'Souza, ClariFit

This presentation is a continuation of last year's award winning talk on some of the new HTML 5 features and how to integrate them in APEX. HTML 5 is the next major version for HTML. It consists of many new features which will make developers' jobs a lot easier and improve end-user experience. This presentation will highlight some of these new features and demonstrate how to leverage them within an APEX application. New features include (but are not limited to) drag & drop, media, and graphics.

Back to Top

14:15-15:15 - SESSION 10

Extending Oracle E-Business Suite Release 12 using Oracle Application Express
David Peake, Oracle Corporation

Oracle Application Express is a very popular tool for building rapid database-centric Web applications. It is also one of the primary choices for extending E-Business Suite. This session will introduce you to how to integrate APEX into your E-Business Suite environment in a fully certified and supported manner.

Back to Top

SQL Developer for the APEX Developer
Kris Rice, Oracle Corporation

SQL Developer is the PL/SQL development tool for any developer.  All the PL/SQL and SQL features are applicable to the Application Express development community.  There are features to help tune, test , and deploy database objects.  Beyond general purpose database development there have also been specific features added to help the Application Express developers.  It ranges from deploying applications to remote debugging a running application to extracting anonymous PL/SQL blocks

15:30-16:30 - SESSION 11

Expert Panel

Speakers from both days will discuss all things APEX and answer your questions.

Oracle Development Tools User Group Seriously Practical Conferences
2520 Independence Blvd., Suite 201
Wilmington, NC 28412 USA
Web site: www.odtug.com        E-mail: info@odtug.com