Oracle APEX

Oracle APEX brings applications directly to the database. The workshop explains how APEX works, how good applications are structured and how to run them securely and reproducibly. Beginners get a solid foundation, experienced teams go deeper into architecture, performance and security.

Audience

Developers starting with APEX or putting their applications on a professional footing, and DBAs who operate APEX.

Modules

The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.

• Architecture: how APEX and ORDS work, workspaces, schemas, sessions
• Application design: pages, regions, processes, dynamic actions, shared components
• SQL and PL/SQL in APEX: logic in packages, efficient queries, data modeling
• Performance: analysis with debug and activity log, typical bottlenecks and their fixes
• Security: authentication, authorization, session state protection, common vulnerabilities
• REST: providing ORDS services and consuming them in APEX
• Deployment: export, versioning, APEXlang, SQLcl and CI/CD
• Operations: APEX on OCI and Autonomous Database

Outcome

Your team builds, assesses and operates APEX applications on its own, directly related to your actual requirements.

Preview

For a first look: the talks on this topic give you an overview, and the talk pages include the slides.

• Low Code Development with APEX and REST DOAG Database 2022
• APEX & ORDS from a DBA's Perspective OUGN 2019