Get in Touch
 Duration 21 hours

Course Outline

Introduction

  • Overview of Oracle APEX capabilities and architectural design
  • Concepts behind database applications
  • Introduction to APEXlang: The human-readable language for application definitions 

Getting Started

  • Installation of Oracle APEX
  • Gaining access to the development workspace
  • Exploring the interface and available tools
  • Configuring external tools: Oracle SQL Developer for VS Code and SQLcl for APEXlang

Creating an Application

  • Configuring the workspace
  • Utilizing the Create Application wizard
  • Incorporating and removing application features
  • Generating a database app from a source file
  • Applying an application blueprint
  • Duplicating an existing database application
  • Developing an application optimized for mobile devices
  • Generative AI Development: Constructing apps from structured APEXlang specifications 
  • Adjusting application properties
  • Oversight of application groups
  • Utilizing application and workspace utilities

Managing Pages

  • Incorporating pages into an application
  • Constructing dialog pages
  • Implementing branching logic with dialog pages
  • Duplicating pages from database applications
  • Removing pages from database applications
  • Locking and releasing page versions
  • Programmatic team collaboration: Leveraging APEXlang locking and working copy APIs 

Using Page Designer

  • Navigating the Page Designer interface
  • Overseeing page properties
  • Executing a page directly from Page Designer
  • Utilizing the runtime developer toolbar
  • Duplicating and deleting application pages
  • Collaborative UI Development: Aligning App Builder workflows with APEXlang text files (.apx) 

Building Reports and Forms

  • Creating reports via the wizard
  • Managing cards within a page
  • Creating and modifying faceted search pages
  • Tailoring interactive grids and reports
  • Administering classic reports
  • Displaying and printing reports
  • Exploring various form types
  • Constructing forms using the wizard
  • Building master-detail forms
  • Validating user inputs
  • Handling BLOB data

Customizing Application Controls and Navigation

  • Overseeing page-level items
  • Incorporating dynamic actions, buttons, and trees
  • Designing navigation menus, breadcrumbs, and tabs
  • Applying computations, validations, and processes
  • Utilizing shared components
  • Enhancing application features (such as e-mail, plug-ins, and globalization)

Managing Application Security and Performance

  • Adhering to security best practices
  • Regulating access to applications, pages, and components
  • Setting up user identity (authentication and authorization)
  • Diagnosing performance bottlenecks
  • Implementing logging and reporting mechanisms
  • Generating custom reports
  • Testing and debugging application logic

Deploying Applications

  • Understanding the deployment lifecycle
  • Creating, maintaining, and upgrading custom applications
  • Compiling applications and components
  • Publishing the database application URL
  • Exporting applications as APEXlang packages (structured .apx files, native SQL, and assets vs. monolithic SQL scripts) 
  • Source Control integration: Managing APEXlang in Git and automating CI/CD pipelines 
  • Importing and installing exported files
  • Targeted updates: Executing File-Level Imports from an APEXlang package 
  • Managing environment configurations using APEXlang Deployment Files 
  • Remotely deploying an application

Troubleshooting

Summary and Next Steps

Requirements

  • Background in application development
  • Proficiency with Oracle SQL Database

Target Audience

  • Software Developers

Testimonials (4)

Upcoming Courses

Related Categories