Oracle APEX 24.1 Product Tour

Dive into Oracle APEX 24.1 capabilities by exploring an app for a fictional medical clinic. Learn how APEX uses generative AI to streamline development tasks and enhance the user experience. See the full range of low-code enterprise app-building features APEX offers, and discover how APEX helps you quickly deliver business value, from data modeling and UX design to workflow automation, approvals, and business logic. See how to seamlessly integrate external services and data, and how teams collaborate to rapidly build, deploy, and maintain high-quality solutions.

00:00 Introduction
01:28 Overview of the "Woods Clinic" Demo App
02:40 Developer Tools
02:43 Integrated Agile Planning & Team Development
03:13 Visual Data Modeling
03:35 Generative AI Assitance for SQL and General Coding
05:33 Low-Code and Pro-Code Collaboration via Packages
05:56 Productive, Iterative, Immediate Page Development
07:02 Powerful Data-Savvy UX Patterns
08:20 Easy Reporting and Data Visualization
10:04 Plug-ins and Extension Apps Let Community Add Value
12:00 User Experience Design
12:04 Generative AI Assistance for App Building
12:59 Building Responsive Pages for Web and Mobile Users
13:54 Easy Parent/Child & Conditional Dynamic Behavior
14:46 AI-Powered Chatbot Experiences
15:45 Geocoding Addresses
16:24 One-Click Progressive Web Apps
17:16 Notify Users with Email & Push Notifications
18:08 Use Mobile Location and Camera Services
19:11 Show End-Users Status of Business Processes
19:48 Template Components and Component Groups
22:21 Build and Compose Template Components
23:45 Universal Search for Google-style Search Across App Data
25:12 Process and Business Logic Design
25:16 Visual Workflow That's Easy-to-Use and Extensible
26:26 Low-Code and Pro-Code Collaboration via Visual Business Processes
26:48 Low-Code Spatial Data Queries
27:12 Low-Code Machine Learning Predictions
28:06 Human Workflow Approval Integrated in Visual Business Processes
29:11 Visual Business Logic Can React to Data Changes
30:47 Data Validation
31:30 Easy Validation Constraints Over Parent/Child Data
33:02 Generative AI to Save End-Users Time
35:43 Native Vector Search and RAG
38:05 Pixel-Perfect Reporting
39:46 Configure Background Processing and Business Logic
41:35 Application + Data Connectivity
41:39 Working with MySQL, OData, Fusion Apps and Arbitrary REST Services
43:27 REST Data Synchronization
43:49 Easy Creation of Any REST Data Service APIs
44:35 Easily Blend Remote Data with Local Data
45:00 23ai JSON Relational Duality Views & JavaScript for Simplified REST APIs
49:07 Secure, Low-Code Push Notifications
49:42 REST Catalogs (from OpenAPI)
50:25 Easy Background Data Loading and Parsing
50:57 Application Testing
51:00 Unit Testing Your Code
51:53 Cypress for UI Testing
52:55 Dev Ops
52:58 Choose a Ticket to Work On
53:28 Create a Working Copy for the Ticket
53:37 Make Required Changes in the Working Copy
54:09 Run the Unit Tests
54:14 Merge Back to the Main App
54:45 Export Main App to Local Git Workarea
55:06 Review Diffs, Commit, Sync to Git with Favorite Tools
55:21 Create Build and Deploy to Production
55:28 Exercise the Fix in Production
55:35 Team-Centric vs Feature-Centric DevOps
56:00 Scalability & Extensibility
56:54 Security
57:49 Governance
58:42 Conclusion