Course Outline
Introduction
- Overview of Oracle APEX features and architecture
- Understanding database applications
Getting Started
- Installing Oracle APEX
- Accessing the development environment
- Exploring the UI and tools
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
- 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
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
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 and components
- Importing and installing exported files
- Deploying an application remotely
Troubleshooting
Summary and Next Steps
Requirements
- Experience with application development
- Familiarity with Oracle SQL Database
Audience
- Developers
Testimonials (6)
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Apprendre certaines fonctionnalités
Henri Gobert - NSI IT Software & Services
Course - Oracle 11g - Programming with PL / SQL II
Trainer expertise on SQL tuning
Bogdan - DB Global Technology
Course - Oracle 11g - Application Tuning - Workshop
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Help Chops
Aarón Fernández Rodríguez - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated