Kom i kontakt
 Varaktighet 21 timmar

Kursplan

Introduction

  • Overview of Oracle APEX features and architecture
  • Understanding database applications
  • Introduction to APEXlang: The human-readable application definition language 

Getting Started

  • Installing Oracle APEX
  • Accessing the development environment
  • Exploring the UI and tools
  • Setting up external tooling: Oracle SQL Developer for VS Code and SQLcl for APEXlang

Creating an Application

  • Setting up the workspace
  • Using the Create Application wizard
  • Adding and removing application features
  • Creating a database app from a file
  • Using an application blueprint
  • Copying an existing database application
  • Creating an application for mobile devices
  • Generative AI Development: Building apps from structured APEXlang specifications 
  • Configuring application attributes
  • Managing application groups
  • Using application and workspace utilities

Managing Pages

  • Adding pages to an application
  • Creating dialog pages
  • Branching with dialog pages
  • Copying database application pages
  • Deleting database application pages
  • Locking and unlocking pages
  • Programmatic team development: Using APEXlang locking and working copy APIs 

Using Page Designer

  • Navigating the Page Designer UI
  • Managing page attributes
  • Running a page from Page Designer
  • Using the runtime developer toolbar
  • Copying and deleting an application page
  • Co-developing UI: Synchronizing App Builder workflows with APEXlang text files (.apx) 

Building Reports and Forms

  • Creating a report using the wizard
  • Managing cards in a page
  • Creating and editing faceted search pages
  • Customizing interactive grids and reports
  • Managing classic reports
  • Viewing and printing reports
  • Understanding form types
  • Creating a form using the wizard
  • Creating master details forms
  • Validating user inputs
  • Working with BLOBs

Customizing Application Controls and Navigation

  • Managing page-level items
  • Adding dynamic actions, buttons, and trees
  • Creating navigation menus, breadcrumbs, and tabs
  • Using computations, validations, and processes
  • Working with shared components
  • Extending application functions (e-mail, plug-ins, globalization, etc.)

Managing Application Security and Performance

  • Security best practices
  • Controlling access to applications, pages, and components
  • Configuring user identity (authentication and authorization)
  • Identifying performance issues
  • Logging and reporting
  • Creating custom reports
  • Testing and debugging applications

Deploying Applications

  • Understanding the deployment process
  • Creating, managing, and upgrading custom applications
  • Building the 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 
  • Deploying an application remotely

Troubleshooting

Summary and Next Steps

Krav

  • Erfarenhet av apputveckling
  • Kännedom om Oracle SQL Database

Målgrupp

  • Utvecklare

Antal deltagare


Pris per deltagare

Vittnesmål (4)

Kommande Kurser

Relaterade Kategorier