Development/APEX Day

8th November 2022

Days
Hours
Minutes
Seconds


Registration for Development/APEX Day – 8th November 2022

My timezone: Australia/Melbourne

Note: Programs and Times may be subject to change 

Title
Date
Start Time
Duration
Registrations Closed

Oracle APEX 22.2: New Features by Marc Sewtz 

Oracle APEX Application Development 22.2 introduces several new features and many enhancements to existing functionality.

The new workflow approval component allows developers to easily integrate task management into their APEX applications.

Further enhancements to progressive web apps (PWAs) enable a more native mobile user experience for end users.

The new application search functionality provides declarative search functionality and a new “Invoke API” process type enables developers to easily map stored procedures to APEX form items.

We’ll share a comprehensive overview of the features introduced with this release and will include several demonstrations of our new capabilities

8/11/20229:00am AEDT50 minutes
 

Crimes Against SQL by Chris Saxon 

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements.

But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven application

8/11/202210:00am AEDT50 minutes
 

Python and Oracle Database: a new Thin driver with easy installation and fast data access by Christopher Jones

This year’s major update to the Python driver for Oracle Database introduced a new name: python-oracledb.

But more importantly, it now has a ‘Thin’ mode that dramatically simplifies installation.

The updated driver is much smaller and faster. What’s new and how to use the new Thin mode and traditional Thick mode will be shown in this session.

See how to use the driver’s standard Python DB API. Also, learn how Oracle Database’s unique features will let you build scalable and reliable applications.

This talk focuses on using the API directly from Python code, but it also shows basic examples of common Python frameworks and ORMs.

Whether you are doing data analysis, building websites and microservices, or creating management and monitoring scripts, python-oracledb is an easy-to-use and efficient driver you should know how to use.

8/11/202211:00am AEDT50 minutes
 

Becoming a Swan: Using APEX and VBCS to Build a New UX for Oracle EBS by Mia Urman

Today’s users want their Oracle EBS Systems to reflect modern UX expectations while preserving functionality.

In this session, you will learn how to leverage the power of Oracle’s next generation development tools - APEX and Visual Builder (VBCS), to reface your Oracle EBS applications and bring them from out-dated to next-generation.

Enabling users to create rich web/mobile apps from any browser, using drag and drop visual development tool. This session includes a live demo and customer case study.

8/11/202212:00pm AEDT50 minutes
 

Charge Me Up! Using Oracle ML, Analytics, and APEX For Finding Optimal Charge Points by Jim Czuprynski

You’re running late for the final 45-minute interview for your new developer position, your brand-new EV’s battery is down to 15%, and if you don’t pick up your five-year-old at daycare on time today,

it’ll cost you big time. So where’s the closest charging point? And why the heck did they put it over there?

This session will take a look at new realities that Smart Cities and the coming re-electrification movement will bring to our world as we transition to EVs.

I’ll show how Oracle technology – including Machine Learning, Analytics, and APEX – can be deployed to determine optimal placement of charging stations based on publicly-available data, as well as provide users the capability to quickly locate the closest and best charge point for their needs at the time.

8/11/20221:00pm AEDT50 minutes
 

Who’s Who in APEX by Adrian Png

A modular approach to authentication and authorization is one of the key features that makes Oracle Application Express (APEX), a great platform for developing web applications.

In this session, we will explore the fundamentals and mechanics of identifying and managing access to APEX applications and components.

Learn how we can either use pre-built or custom authentication schemes that take advantage of modern frameworks like OAuth2, SAML2, WebAuthn, Two-Factor Authentication and more

8/11/20222:00pm AEDT50 minutes
 

Leverage your internal processes using REST Synchronization and Automations by Andreea Munteanu

As a developer, you may encounter a lot of use cases where you need to manipulate and analyze external data sources.

How you do it in an easy way and centralize it in a single application?

Well, using REST features and automations in APEX has never been simpler.

Following the latest releases of APEX, handling REST APIs and automate processes based on them reduces complexity and your app becomes your single point of truth.

We will have a closer look on a Jira Service Desk integration with Oracle APEX, a way to keep track of the tickets for your specific projects.
A detailed walk-through the REST endpoints along with building automated processes to support the data analysis will be covered in the session.

As a low-code platform, APEX helps developers use features like REST Synchronization and Automations in a declaratively manner, however, another option is also using APEX APIs.

Examples on how to use their respective APEX APIs will be provided as well as tips to handle potential errors.

8/11/20223:00pm AEDT50 minutes
 

Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API by Niall Mc Phillips

In this presentation, through building practical examples, attendees will learn how to build a secured REST API to enable searching on their application.

The resulting technology-independent REST API will be usable by both Oracle and by non-Oracle environments alike.

Topics to be covered include:
- an architectural overview of the creation of ORDS web services in PL/SQL
- setting up ORDS for your database schema
- defining the search API in PL/SQL
- creating ORDS module and templates for the API
- management of HTTP return statuses and result pages pagination
- securing the API via OAuth2 using ORDS clients, privileges and roles.

8/11/20224:00pm AEDT50 minutes
 

Mastering sending template based emails in APEX by Dimitri Gielis

Your application can send rich HTML emails using the email templates defined in Shared Components - Email template.

This session will cover the declarative and programmatic options you have to create stunning personalized emails straight from APEX and PL/SQL.

Many demos will show how to send emails to a group of people from using simple to complex email templates with tabular data.

We will even include some customized PDFs as attachments by combining email templates with AOP.

8/11/20225:00pm AEDT50 minutes
 

Development/APEX Day Recordings- 8/11/2022

This recording is available for until 8th February 2023 to everyone, and will only be available to AUSOUG members after this date

Title
Date
Register

Oracle APEX 22.2: New Features by Marc Sewtz  

Oracle APEX Application Development 22.2 introduces several new features and many enhancements to existing functionality.

The new workflow approval component allows developers to easily integrate task management into their APEX applications.

Further enhancements to progressive web apps (PWAs) enable a more native mobile user experience for end users.

The new application search functionality provides declarative search functionality and a new “Invoke API” process type enables developers to easily map stored procedures to APEX form items.

We’ll share a comprehensive overview of the features introduced with this release and will include several demonstrations of our new capabilities

8/11/2022Recording 

Crimes Against SQL by Chris Saxon 

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements.

But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven application

8/11/2022Recording

Presentation Slides - Crimes Against SQL by Chris Saxon

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements.

But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven application

8/11/2022

Crimes-against-SQL.PDF

write-scalable-sql-setup

crimes-against-sql

 

Python and Oracle Database: a new Thin driver with easy installation and fast data access by Christopher Jones

This year’s major update to the Python driver for Oracle Database introduced a new name: python-oracledb.

But more importantly, it now has a ‘Thin’ mode that dramatically simplifies installation.

The updated driver is much smaller and faster. What’s new and how to use the new Thin mode and traditional Thick mode will be shown in this session.

See how to use the driver’s standard Python DB API. Also, learn how Oracle Database’s unique features will let you build scalable and reliable applications.

This talk focuses on using the API directly from Python code, but it also shows basic examples of common Python frameworks and ORMs.

Whether you are doing data analysis, building websites and microservices, or creating management and monitoring scripts, python-oracledb is an easy-to-use and efficient driver you should know how to use.

8/11/2022Recording 

Becoming a Swan: Using APEX and VBCS to Build a New UX for Oracle EBS by Mia Urman

Today’s users want their Oracle EBS Systems to reflect modern UX expectations while preserving functionality.

In this session, you will learn how to leverage the power of Oracle’s next generation development tools - APEX and Visual Builder (VBCS), to reface your Oracle EBS applications and bring them from out-dated to next-generation.

Enabling users to create rich web/mobile apps from any browser, using drag and drop visual development tool. This session includes a live demo and customer case study.

8/11/2022Recording 

Charge Me Up! Using Oracle ML, Analytics, and APEX For Finding Optimal Charge Points by Jim Czuprynski

You’re running late for the final 45-minute interview for your new developer position, your brand-new EV’s battery is down to 15%, and if you don’t pick up your five-year-old at daycare on time today,

it’ll cost you big time. So where’s the closest charging point? And why the heck did they put it over there?

This session will take a look at new realities that Smart Cities and the coming re-electrification movement will bring to our world as we transition to EVs.

I’ll show how Oracle technology – including Machine Learning, Analytics, and APEX – can be deployed to determine optimal placement of charging stations based on publicly-available data, as well as provide users the capability to quickly locate the closest and best charge point for their needs at the time.

8/11/2022Recording 

Who’s Who in APEX by Adrian Png

A modular approach to authentication and authorization is one of the key features that makes Oracle Application Express (APEX), a great platform for developing web applications.

In this session, we will explore the fundamentals and mechanics of identifying and managing access to APEX applications and components.

Learn how we can either use pre-built or custom authentication schemes that take advantage of modern frameworks like OAuth2, SAML2, WebAuthn, Two-Factor Authentication and more

8/11/2022Recording 

Leverage your internal processes using REST Synchronization and Automations by Andreea Munteanu

As a developer, you may encounter a lot of use cases where you need to manipulate and analyze external data sources.

How you do it in an easy way and centralize it in a single application?

Well, using REST features and automations in APEX has never been simpler.

Following the latest releases of APEX, handling REST APIs and automate processes based on them reduces complexity and your app becomes your single point of truth.

We will have a closer look on a Jira Service Desk integration with Oracle APEX, a way to keep track of the tickets for your specific projects.
A detailed walk-through the REST endpoints along with building automated processes to support the data analysis will be covered in the session.

As a low-code platform, APEX helps developers use features like REST Synchronization and Automations in a declaratively manner, however, another option is also using APEX APIs.

Examples on how to use their respective APEX APIs will be provided as well as tips to handle potential errors.

8/11/2022Recording 

Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API by Niall Mc Phillips

In this presentation, through building practical examples, attendees will learn how to build a secured REST API to enable searching on their application.

The resulting technology-independent REST API will be usable by both Oracle and by non-Oracle environments alike.

Topics to be covered include:
- an architectural overview of the creation of ORDS web services in PL/SQL
- setting up ORDS for your database schema
- defining the search API in PL/SQL
- creating ORDS module and templates for the API
- management of HTTP return statuses and result pages pagination
- securing the API via OAuth2 using ORDS clients, privileges and roles.

8/11/2022Recording 

Mastering sending template based emails in APEX by Dimitri Gielis

Your application can send rich HTML emails using the email templates defined in Shared Components - Email template.

This session will cover the declarative and programmatic options you have to create stunning personalized emails straight from APEX and PL/SQL.

Many demos will show how to send emails to a group of people from using simple to complex email templates with tabular data.

We will even include some customized PDFs as attachments by combining email templates with AOP.

8/11/2022Recording 

Speakers

Thank you to all the following speakers, from within Australia and around the globe, who have kindly submitted their papers for Connect 2021.

Senior Software Development Manager

Oracle Corporation

Partners

Oracle ace alumni

Oracle ACE Alumni

AUSOUG reserves the right to change speakers, events and/or session times, dates, prices and other details as deemed necessary.