Oracle APEX Developer Professional

Descrizione del corso

Il corso Oracle APEX Developer Professional offre una formazione completa sulla creazione e gestione di applicazioni con Oracle APEX, partendo dalla configurazione dell'ambiente di sviluppo sul database autonomo Oracle. Si esploreranno le tecniche per progettare applicazioni scalabili, gestire dati e report, personalizzare interfacce utente e implementare funzionalità avanzate come l'automazione e la gestione della sicurezza. Inoltre, verranno trattate le modalità di estensione delle applicazioni e la migrazione tra diversi ambienti, fornendo tutte le competenze necessarie per sviluppare soluzioni moderne e sicure.

Programma

Getting Started with Oracle APEX on the Oracle Autonomous Database

• Describe Oracle APEX
• Creating and Managing a Workspace
• List and describe the major components of Oracle APEX

Using SQL Workshop

• Create and modify database objects
• Run SQL Commands and Scripts
• Load and Unload data using the Data Workshop Utility
• Generate SQL using Quick SQL

Creating an APEX Application

• Create an APEX application based on existing tables
• Create an APEX application from a file
• Create a progressive web application (PWA)
• Managing Application Attributes with App Builder Concepts

Working with Pages and Regions

•  Create different page types and regions
• Manage pages in Page Designer
• Manage page attributes
• Add Page Components

Developing Reports

• Create and customize the interactive report
• Create and customize the interactive grid
• Create and customize the classic report
• Create a report with a form
• Create and customize Cards
• Create and customize Smart Filter
• Create and customize a faceted search page

Creating and Using Forms

• Create an editable interactive grid
• Create a simple form and link a report to this form
• Create different types of master-detail forms
• Modify a form

Creating Application Page Controls

• Create and use page-level items and buttons

Adding Computations, Processes, Validations, and Branches

• Create computations
• Create page processes
• Create validations
• Create branches

Implementing Navigation in Your Application

• Create, edit, and use the following shared components that aid navigation in an application: Lists, Navigation Menus. Breadcrumbs, Navigation bar entries
• Search Configurations

Managing Application Data

• Use Collections
• Manage REST Enabled SQL References
• Manage REST Data Sources
• Data Synchronisation

Using Themes and Theme Styles

• Create and use a new theme
• Use Theme Styles
• Use Theme Roller and Live Template Options

Extending Application Capabilities

• Sending E-Mail from an application
• Automation
• Approvals and Unified Tasks Lists
• Describe and Implement Plug-ins in your application

Implementing Security in Your Application

• Create and use an authentication scheme for your application
• Create and attach an authorization scheme to your application, page, or components
• Using Session State Protection

Adding Additional Pages to Your Application

• Oracle JET Charts
• Calendars
• Trees
• Maps

Creating and Using Dynamic Actions

• Create and use Dynamic Actions
• Implement Plug-ins in your application

Migrating Application Development Between Environments

• Export the application definition, underlying database objects, and data from your development environment and import them into the target development environment
• Perform One-click Remote Application Deployment