Watch this webinar to see the broad set of Oracle APEX features you can use to quickly deliver and maintain beautiful, functional solutions that add immediate business value. Enjoy end-to-end or expand the YouTube description for a detailed topic timeline to view just a segment. See below for a list of what you’ll learn…
Studying an app for a fictional medical clinic, you’ll see & learn about:
Productive Development
- Using Generative AI help for SQL, PL/SQL, app creation, and more
- Creating Gen AI chatbots and using AI services to save users time
- Modeling data visually using the Quick SQL ER Diagram
- Automating business processes with workflow and approvals
- Laying out responsive web pages with minimal effort
Easy User Interfaces and Reporting
- Visualizing business process status for end users in a diagram
- Exploring data interactively with filters, aggregates, and charts
- Saving reports and downloading/emailing/scheduling results
- Generating pixel-perfect PDF reports from Word templates
- Presenting data with Maps, Cards, Calendars, and Charts
- Filtering data with Faceted Search and Smart Filters
- Searching application-wide with unified results display
- Reacting to end-user interactions with dynamic behavior
- Incorporating community plug-ins like a Kanban Board
- Handling parent/child lists, regions, and conditional display
- Geocoding addresses
- Creating reusable UI components with only HTML markup skills
- Reusing repeating layouts consistently with configurable slots
- Installing Progressive Web Apps that launch like native ones
- Uploading images from a mobile device’s camera
- Capturing GPS location of a mobile user
Simple Business Processes, App Logic, and Integration
- Orchestrating app logic with workflows that react to data changes
- Sending Emails and push notifications
- Integrating data from MySQL, OData, Fusion Apps, and REST APIs
- Synchronizing remote data periodically to a local cache
- Querying based on spatial distances
- Predicting outcomes from historical data with machine learning
- Validating parent/child data using simple SQL checks
- Using semantic similarity searching with 23ai vector search
- Improving Gen AI results with Retrieval-Augmented Generation
- Offloading longer-running processing to the background
- Loading CSV, Excel, or JSON data in foreground or background
- Enriching remote data with local joins and computations
- Exposing application data as REST APIs using JSON Duality Views
- Producing reusable REST API catalogs from OpenAPI documents
Hassle-free Dev Ops and Application Lifecycle
- Tracking issues and tackling tickets in teams with working copies
- Merging changes from a separate working copy back to main
- Testing apps and deploying to test and prod environments
- Valuing APEX scalability, extensibility, security, and governance
