1. Getting Started with Oracle APEX on ADB
·
Introducing Oracle APEX and its Components
·
APEX on Oracle ADB
·
Practice 1-1: Provisioning an APEX Service on Oracle Cloud Free Tier
·
Practice 1-2: Accessing the APEX Environment and Creating a Workspace
2. Creating and Managing Database Objects Using SQL Workshop
·
Using SQL Workshop
·
Running SQL Commands and SQL Scripts
·
Using Oracle APEX Utilites
·
Practice 2-1: Loading the Tables and Data
·
Practice 2-2: Creating a Lookup Table
3. Overview of App Builder
·
Overview of App Builder
·
Creating a Database Application Based on Tables
·
Creating a Database Application from a File
·
Creating a Mobile Web Application
·
Practice 3-1: Creating a Database Application from Scratch
·
Practice 3-2: Creating a Database Application from a Spreadsheet
·
4. Creating an Application Page
·
Creating an Application Page
·
Using Page Designer
·
Practice 4-1: Manging Pages in Page Designer
5. Overview of Reports in Oracle APEX
·
Overview of Reports in Oracle APEX
·
Creating an Interactive Report
·
Creating an Interactive Grid
·
Creating a Classic Report
·
Creating a Report with a Form
·
Creating a Faceted Search Page
·
Practice 5-1: Creating a Classic Report
·
Practice 5-2: Creating an Interactive Report
·
Practice 5-3: Creating an Interactive Grid
·
Practice 5-4: Creating a Faceted Search Page
6. Customizing an Interactive Report as an End User
·
Customizing an Interactive Report as an End User
·
Customizing an Interactive Report as a Developer
·
Practice 6-1: Using an Interactive Report
·
Practice 6-2: Customizing an Interactive Report as a Developer
·
Practice 6-3: Saving the Team Members Interactive Report
·
Practice 6-4: Customizing the Projects Interactive Report
·
Practice 6-5: Customizing the Milestones Interactive Report
·
Practice 6-6: Customizing the Tasks Interactive Report
7. Customizing an Interactive Grid as a Developer
·
Customizing an Interactive Grid as a Developer
·
Practice 7-1: Customizing an Interactive Grid as a Developer
·
Customizing an Interactive Grid as an End User
·
Practice 7-2: Customizing an Interactive Grid as an End User
8. Creating a Form in Oracle APEX
·
Creating a Form in Oracle APEX
·
Creating an Editable Interactive Grid
·
Creating Master Detail Forms
·
Modifying a Form
·
Practice 8-1: Updating the Form Pages in the Demo Projects Application
·
Practice 8-2: Creating a Form on a Table and Linking a Report.
9. Creating Application Page Controls
·
Creating Application Page Controls
·
Creating and Using Buttons
·
Practice 9-1: Updating the Team Members Pages
·
Practice 9-2: Updating the Projects Pages
·
Practice 9-3: Updating the Milestones Pages
·
Practice 9-4: Updating the Tasks Pages
10. Adding Computations, Processes and Validations
·
Adding Computations, Processes and Validations
·
Creating Page Processes
·
Creating Validations
·
Creating Branches
·
Practice 10-1: Implementing Validations on the Maintain Project Page
·
Practice 10-2: Creating and Using a Computation
·
Practice 10-3: Creating and Using a Process
·
Practice 10-3: Creating and Using a Process
·
Practice 10-4: Creating and Using Validations
11. Implementing Navigation in
your Application
·
Implementing Navigation in your Application
·
Navigation Menus
·
Breadcrumbs
·
Navigation Bar Entries
·
Manage REST Enabled SQL References
·
Manage REST Data Sources
·
Practice 11-1: Implementing Navigation in your Application
·
Practice 11-2: Integrating Application Data from Remote Data Sources
12. Using Themes and Theme Styles
·
Use Themes Styles
·
Using Themes and Theme Styles
·
Use Theme Roller, Live Template Options, and CSS
·
Practice 12-1: Updating the Team Member Pages
·
Practice 12-2: Using Themes and Theme Styles
13.Implementing Security in your
Application
·
Create and Use an Authentication Scheme for your Application
·
Create and Apply an Authentication Application Scheme
·
Using Session State Protection
·
Practice 13-1: Creating and Using an Authorization Scheme
·
Practice 13-2: Creating and Using an Authentication Scheme
·
Practice 13-3: Controlling User Access by Using the Access Control
Administration
14. Adding Additional Pages to
your Application
·
Oracle JET Charts
·
Calendars
·
Trees
·
Maps
·
Practice 14-1: Creating and Customizing a Calendar
·
Practice 14-2: Modifying the Dashboard Page
·
Practice 14-3: Updating the Project Tasks Chart
·
Practice 14-4: Adding the Project Milestones Chart
·
Practice 14-5: Adding the Project Status Chart .
·
Practice 14-6: Adding the Project Tree
·
Practice 14-7: Creating Maps
15.Create and Use Dynamic Actions
in your Application
·
Create and Use Dynamic Actions in your Application
·
Import and Install Plug-ins in your Application
·
Implement Plug-ins in your Application
·
Practice 15-1: Creating and Using a Dynamic Action on the Maintain
Project Page
·
Practice 15-2: Creating and Using a Dynamic Action on the Maintain Task
Page
·
Practice 15-3: Creating and Using Dynamic Actions on the Project Tree
Page
·
Practice 15-4: Creating and Using a Plug-in
·
Practice 15-5: Adding Additional Reports
·
Practice 15-6: Updating the Reports Page
·
HOL 15-7: Updating the Dashboard Page
·
Practice 15-8: Updating the Home Page
·
HOL 15-9: Making the Music Video Report Searchable
16.Collections
·
Collections
·
Creating a Collection
·
Practice 16-1: Creating a Collection
17.Migrating Application
Development between Environments
·
Migrating Application Development Between Environments
·
Migrate Database Objects and Data
·
Practice 17-1: Importing an Application
·
Practice 17-2: Migrating Your Application Development Between
Environments
18.Project: Creating a Shopping
Cart Application Using APEX
·
Install a Sample Dataset 5
min
·
Add Columns to the Products Table 10
min
·
Create Database Objects 5
min
·
Create the Application 15
min
·
Create the Order Page 15
min
·
Create the Shopping Cart Page 20
min
·
Create the Add to Cart Page 20
min
·
Improve the Products Page 20
min
· Improve the Application 10 min