Current Status
Not Enrolled
Enroll in this course to get access
Price
Included with OEG One
Get Started
Course Duration: 30 Hours
| # | Agenda |
|---|---|
| 1 | Oracle APEX Modules |
| 1.1 | How to Create Secure, Scalable Enterprise-Scale APEX Applications on Oracle Cloud |
| 1.2 | Build and Manage Powerful Reports |
| 1.3 | Develop and Manage Different Types of Forms |
| 1.4 | Build a Variety of Pages: Cards, Faceted Search, Smart Filters, Maps, Charts, and Calendars |
| 1.5 | Manage Pages and Regions |
| 1.6 | Implement Navigation in APEX Applications |
| 1.7 | Enhance APEX Applications Using Computations, Processes, Validations, and Dynamic Actions |
| 1.8 | Implement Security in APEX Applications |
| 1.9 | Extend APEX Application Capabilities |
| 1.10 | Migrate Application Development Between Environments |
| 1.11 | Preparation for Oracle APEX Certification Exams |
| 2 | Module 1: Introduction to Oracle APEX |
| 2.1 | What is Oracle APEX? |
| 2.2 | Introduction to Oracle Autonomous Database |
| 2.3 | Understand Low-Code Application Development |
| 2.4 | Oracle APEX Availability and Architecture |
| 2.5 | Oracle APEX Use Cases |
| 3 | Module 2: Oracle APEX Set Up |
| 3.1 | Provisioning an APEX Workspace |
| 3.2 | APEX History and Product Components |
| 3.3 | Oracle APEX Architecture in Detail |
| 3.4 | Previewing Out-of-the-Box Apps Provided by Oracle |
| 3.5 | Installing a Sample APEX Application |
| 4 | Module 3: SQL Workshop |
| 4.1 | Understand SQL Basics |
| 4.2 | Use SQL Commands and SQL Scripts |
| 4.3 | Generate SQL Using Quick SQL |
| 4.4 | SQL Web Developer |
| 4.5 | Build Sample Datasets |
| 5 | Module 4: Build First Application in APEX |
| 5.1 | App Builder Concepts |
| 5.2 | App Builder and the Create App Wizard |
| 5.3 | Application Based on Existing Tables |
| 5.4 | Create an Application from a File |
| 6 | Module 5: Managing Team Development |
| 6.1 | Managing Labels |
| 6.2 | Managing Templates |
| 6.3 | Managing Milestones |
| 6.4 | Managing Issues |
| 7 | Module 6: Developing Reports |
| 7.1 | Build Classic Report |
| 7.2 | Build Interactive Report |
| 7.3 | Build Interactive Grid Report |
| 7.4 | Build Faceted Search Report |
| 8 | Module 7: Developing Forms |
| 8.1 | Creating Forms |
| 8.2 | Making Interactive Grid Reports Editable |
| 8.3 | Creating Master-Detail Reports |
| 8.4 | Manage BLOB in Forms for Document Upload and Download |
| 8.5 | Create and Manage List of Values in Forms |
| 8.6 | Create and Customize Buttons in Forms |
| 9 | Module 8: Creating and Using Dynamic Actions |
| 9.1 | Understanding Dynamic Actions |
| 9.2 | Enabling and Disabling Items Using Dynamic Actions |
| 9.3 | Setting an Item Value Using Dynamic Actions |
| 9.4 | Filtering and Refreshing a Report Using Dynamic Actions |
| 10 | Module 9: Managing Application Components |
| 10.1 | Creating Calendars |
| 10.2 | Creating Charts |
| 10.3 | Creating Maps |
| 11 | Module 10: APEX Computations, Processes, and Validations |
| 11.1 | Understanding Page Rendering and Page Processing |
| 11.2 | Manage APEX Computations |
| 11.3 | Creating and Understanding Page Processes |
| 11.4 | Build and Manage Validations in APEX |
| 11.5 | Understand Validations and Branches |
| 12 | Module 11: Build Complex Point of Sale (POS) APEX App – Part 1 |
| 12.1 | Introduction to Point of Sale App Design |
| 12.2 | Design and Set Up Data Model for POS App |
| 12.3 | Build Complex APEX Application Page to Manage Purchasing |
| 12.4 | Add Administration in POS App Using Various APEX Components |
| 13 | Module 12: Build Complex Point of Sale (POS) APEX App – Part 2 |
| 13.1 | Build Complex APEX Application Page to Manage Sales |
| 13.2 | Build Complex APEX Page to Add and Manage Customers |
| 13.3 | Build Complex Dashboard Page to Display Stock and Other Details |
| 14 | Module 13: Build Expense Tracker in POS App – Part 3 |
| 14.1 | Introduction to Expense Tracker App Design |
| 14.2 | Design and Set Up Data Model for Expense Tracker App |
| 14.3 | Build Page to Add Various Expenses |
| 14.4 | Build Complex Page to Display Transactions |
| 14.5 | Build Complex APEX Bar Chart to Display Expenses by Category |
| 15 | Module 14: Build Expense Tracker App – Part 4 |
| 15.1 | Create Faceted Search Reports |
| 15.2 | Build and Manage Summary Report Cards |
| 15.3 | Manage Smart Filters to Display Expenses by Month and Year |
| 15.4 | Build Dashboard to Display Expense Totals and Graphs |
| 15.5 | Build Interactive Reports in APEX |
| 16 | Module 15: Implementing Security in Your Application |
| 16.1 | Understanding and Using Authorization Schemes |
| 16.2 | Creating and Using Access Control Administration Page |
| 16.3 | Build Login Page with Password Reset and Other Login Options |
| 16.4 | Understand User Authorization and Access Control |
| 17 | Module 16: REST API in Oracle APEX |
| 17.1 | Managing REST Enabled SQL References |
| 17.2 | Creating and Managing REST Data Sources |
| 17.3 | Creating a Report from REST Data Source |
| 17.4 | Using REST API in PL/SQL Code in Oracle APEX |
| 18 | Module 17: Page Integration in Oracle Fusion Application |
| 18.1 | Making Frame Changes in Oracle APEX App for Embedding |
| 18.2 | Creating Sandbox in Fusion Instance |
| 18.3 | Page Integration in Fusion Instance |
| 19 | Module 18: Oracle APEX Maintenance |
| 19.1 | Oracle APEX Application Backup |
| 19.2 | Migrating Oracle APEX from One Environment to Another |
| 19.3 | Migrating Database Objects Along with Application |
| 20 | Module 19: Miscellaneous |
| 20.1 | Understanding Themes |
| 20.2 | Understanding Theme Styles and Theme Roller |
| 20.3 | Understanding Templates |
| 20.4 | Managing Themes and Using Custom CSS |
| 20.5 | Creating and Using Lists |
| 20.6 | Creating and Using Navigation Menu and Navigation Bar Lists |
| 20.7 | Sending Emails |
| 20.8 | Adding Search to an Application |
| 20.9 | APEX Automation |
| 20.10 | Push Notifications |
| 21 | Module 20: Guidance on Certification |
| 21.1 | Comprehensive Guidance for Oracle APEX Certification |
If you have a paid account, login here.
(You are not logged in. You need to login to access the videos.)
- Login
Course Content
Meeting Invite
Meeting Invite – Oracle APEX – Live Training (Nov-26 to Jan-27)
You don't currently have access to this content