Welcome to the AUSOUG webinar series dedicated to Oracle APEX and PL/SQL technology.

We are happy to announce second year around we will be running this dedicated webinar series. Webinars will cover a range of technical and business topics providing you with up to date information on your favorite development tools.


Run by world-class guest speakers, webinars will provide you with the opportunity to refresh your skills, learn the latest trends, ask questions and above all have fun learning from the best. They will range from introductory to advanced level, and will cover topics ranging from How to start with APEX and latest APEX 18.1 new features to best practices and PL/SQL tunning tips.


Program starts on Tuesday 10th of July, running each week till mid October. All sessions will be held in english. So register today using links below or by visiting AUSOUG event calendar.

Please click the Presenter's  image for more details (in chronological order)

 Tuesday, July 10, 2018 06:00pm - 07:00pm AEST
 On Oracle APEX 18.1   (view recording here)

As an intro session for 2018 webinar series this is a general non-technical session. For experienced developers find out - What is new in 18.1; for people new to APEX learn where to start and how to get into it.This is general session where we will go over 18.1 coolest features of our favorite RAD tool. Latest tips and news from Kscope will be revealed too. A lot ground to cover and lot info to share. Hope to see you all there!

 Tuesday, July 17, 2018 08:00pm - 09:00pm AEST
 Dive into Dynamic Actions   (view recording here)

Are you new to APEX? Do you want to be able to take your applications to the next level with very little knowledge of JavaScript? If so, learning  the basics of dynamic actions is a must! Dynamic actions are a powerful tool that allow you to quickly and easily define client-side behavior declaratively with little or no knowledge of JavaScript. However, dynamic actions can still be daunting to a novice APEX developer. In this session, I’ll introduce and explain the concept of dynamic actions as I progress through a number of common, real-world requirements that a developer may face. I will explain how to use dynamic actions to easily solve these problems. An application with examples ranging from basic to advanced will be available for download in order to facilitate further learning after the session.

 Tuesday, July 24, 2018 09:00pm - 10:00pm AEST
 Building Big Things for Small Screens   (view recording here)

The Universal Theme in APEX 18.1 will see a number of enhancements targeted at developers building responsive apps that are well suited for mobile and small-screen devices. In this tactical session, we’ll demonstrate how to transition from jQuery Mobile APEX apps, and how to apply mobile UI patterns with the Universal Theme to build great small-screen experiences.

 Tuesday, July 31, 2018 09:00pm - 10:00pm AEST
 Universal Theme: Understanding Core Technology and Lesser-Known Features   (view recording here)

The Universal Theme provides a plethora of tools to quickly build sleek and responsive applications. For more complex applications, you may want to either manipulate the page to perform certain actions or adjust the display. In this session we will explore custom responsive breakpoints, the underlying CSS principles of UT known as BEM, and the theme42 module for custom JavaScript components.

 Thursday, August 09, 2018 06:00pm - 07:00pm AEST
 APEX 18.1 and Beyond   (view recording here)

We all know that APEX 18.1 offers a lot of features right out of the box, but what if you get a requirement that goes beyond APEX 18.1's standard functionality? Let's go through some of these and learn what you can do to address:

  • XLSX import
  • reporting Drilldown reporting
  • Continuous integration
  • Automated testing
  • Tree with enhanced functionalities
  • Workflow support
  • Offline capability

 Tuesday, August 14, 2018 09:00pm - 10:00pm AEST
 Why Your DBA Hates You   (view recording here)

Who tunes SQL - the developer or the DBA? There are some SQL constructs that are known to be inefficient and others that will confuse the heck out of the optimizer. Your DBA will (or should) be looking out for them, but it’s better to identify and avoid them in the first place.

 Tuesday, August 21, 2018 06:00pm - 07:00pm AEST
 Customizing the Interactive Grid with Plugins   (view recording here)

Do you have requirements for your APEX applications that cannot be fulfilled using the declarative options of the Interactive Grid? Join this session to explore the issue and view solutions in live demonstrations. The interactive grid has quickly become the number one component in most APEX applications. Although APEX 18.1 continues to extend its capabilities, JavaScript customizations will always be necessary. After exploring API, you will better understand the underlying architecture and you’ll be able to build superior applications and speed up development. You might even start to think like an Interactive Grid! Learn how can you turn hundreds of lines of JavaScript Initialization Code into plugins. You will see a collection of plugins, which will make doing your advanced customizations a piece of cake.

 Tuesday, August 28, 2018 06:00pm - 07:00pm AEST
 Automated Browser Tests with APEX   (view recording here)

This session will look more closely at how APEX developers can use Test Driven Development and Data Driven Testing to improve the quality of their APEX applications.

 Thursday, September 06, 2018 09:00pm - 10:00pm AEST
 Advanced CSS Techniques to Make Your Application Look Even Better   (view recording here)

In this session, we will look at the more advanced CSS techniques that will make your application look and feel great. You have no idea how many problems can be solved with a little CSS.

 Monday, September 10, 2018 06:00pm - 07:00pm AEST
 Bringing Virtual Reality (VR) and Augmented Reality (AR) to APEX   (view recording here)

This is the first ever 3D APEX presentation. You will receive a Google Cardboard to follow along as I introduce the concepts of the WebVR, WebAR API, and the newer WebXR API. I will also showcase the first Mixed Reality Oracle APEX app. Mixed Reality (WebXR) is designed to allow web developers to easily create web applications that adapt to the capabilities of each platform. These examples run in WebVR- and AR-enabled browsers. Maybe you don't use Mixed Reality just yet in your apps, but I'm sure in the future you will. Either way, this presentation will be fun!

 Tuesday, September 18, 2018 06:00pm - 07:00pm AEST
 APEX Internal Workspace   (view recording here)

After installation of APEX we can login only to one workspace - internal. In this workspace we can create “real” workspaces. Most likely this step is known to many APEX developers. But there is a lot more to do in internal workspace then just creating new workspaces and this tasks are (per documentation) done by instance administrator, but at the same time it’s good that also developers know and understand what is going on in internal workspace. In this presentation I will highlight some of the features that are sometimes overlooked and I will also talked about features that developers should at least know that they exist.

 Tuesday, September 25, 2018 06:00pm - 07:00pm AEST
 The best SQL and PL/SQL features for Developers   (view recording here)

SQL and PL/SQL are big topics. Huge! So it is hard to keep up with new features, and even easier to be unaware of features from older releases.This session will try to correct that. We'll cover enhancements to SQL and PL/SQL functionality in 12c Release 2 and 18c, so that you'll be marching down to your DBA's office to demand an upgrade. But we'll also cover some lesser known features that have existed for many years but are underutilized by developers.

 Tuesday, October 02, 2018 09:00pm - 10:00pm AEST
 Hacking Oracle APEX   (view recording here)

There have been many conference presentations, books, and webinars on how to secure APEX applications. But most, if not all, never explore what an actual attack would look like or the damage it might cause. This session will demonstrate just that—actual Cross Site Scripting and SQL Injection attacks against APEX applications which do a whole lot more than print “hello, world.” Along with the demonstration, the session will cover how you can mitigate and prevent these types of attacks.

 Tuesday, October 09, 2018 09:00pm - 10:00pm AEST
 Timecards and Timekeeping in Five Acts: Microapps in APEX for Web, Desktop, Slack, SMS, and Voice   (view recording here)

Accurate and timely reporting of time is the lifeblood of a services business. In this case study, we reimagine the classic time card as an APEX Microapp deployed in five different flavors: as a web app, as a native desktop app, in Slack (desktop & mobile), and as a chatbot on both SMS and Voice. This approach allows the application to utilize any channel to reach out and collect time from team members.


AUSOUG highly appreciates and acknowledges all APEX and DB community experts who will be our guest speakers for this series. Thank you all.


We encourage you to provide feedback on each session and if there is a topic you would like covered but do not see it here? We are happy to take any of your webinar suggestions for the future. Email us at contact@ausoug.org.au.