Oracle APEX Professional (2024)

This is a very comprehensive course, specially designed for students, beginners and professionals. We will start from oracle Apex foundations and move towards advance topics gradually. Course content is

1. Oracle APEX Overview and Architecture

   • Describe Oracle Application Express (APEX)

   • Explain the key features of Oracle Application Express

   • Describe Oracle Application Express architecture

   • Oracle APEX Workspaces and Applications

   • Create Workspace (Local, Cloud and Autonomous Database)

   • Internal Workspace in Oracle APEX

   • Multiple Schema Assignment

   • List and describe the components of Oracle Application Express

   • Major components of Oracle APEX

   • Log into Oracle Application Express

   • Browser as IDE for Oracle APEX development

   • Install and run a packaged applications

2. SQL Workshop

   • Describe SQL Workshop and list its components

   • What is SQL Workshop?

   • SQL Scripts

   • Execute SQL Commands

   • Creating, Executing, Saving, Importing and Export SQL Scripts between Workspaces

   • Oracle APEX Utilities

   • Load CSV,XLSX,XML and JSON data into Database Table

   • Unload Data into Text or XML

   • Query Builder Utility – Declarative way

   • Methods on Tables Utility – Create Package and procedures

   • Quick SQL Utility to create SQL.

   • Browse through database objects using the Object Browser

   • Create and modify database objects

   • Create a lookup table

   • Generate DDL statements

3. Creating Database Applications

   • Explain App Builder concepts

   • Describe the types of applications you can build using Application Express

   • Create database application in Oracle APEX

   • Edit database application properties

   • Create applications from JSON,XLSX,XML and text files

   • List the components of a database application

   • Determine your application user interface

   • Create a database application from scratch

   • Create a database application from a spreadsheet

   • Create a mobile web application

4. Oracle APEX Page Designer

   • Explain application page components

   • Create an application page and view its definition

   • Manage pages in page designer

   • Describe page designer UI elements

   • Add page components

5. Developing Reports

   • List the type of reports that you can create in Apex

   • Describe the different ways of creating reports in Application Express

   • Create an interactive report

   • Create an interactive grid

   • Create a classic report

   • Create a report with form

6. Managing and Customizing Interactive Reports

   • Describe interactive report components

   • Searching for information in an interactive report

   • Searching for information within a specific column

   • Show or Hide columns in interactive report

   • Adding a filter in an interactive report

   • Describe types of filters

   • Adding column filter and row filter

   • Selecting column sort order in interactive report

   • Creating aggregation in interactive report

   • Adding a computed column

   • Performing a Flashback query in interactive report

   • Creating a control break

   • Adding highlighting a row in interactive report

   • Creating a group by in interactive report

   • Specifying a group by Sort order

   • Saving an Interactive report

   • Resetting a report

   • Downloading a reports

   • Using Column Heading Menu

   • Customizing an interactive report as a developers

   • Editing Interactive Report Region Attributes

   • Modifying an interactive Report Source Query

   • Editing interactive report attributes

   • Customizing the search bar

   • Customizing the Actions Menu

   • Specifying the download formats

   • Managing Link Columns

   • Use and customize an interactive report as an end user

   • Manage interactive report attributes

   • Configure the display of interactive report controls as a developer

   • Column Headers & Linking Columns

   • Single Row View of Interactive Reports

7. Managing and Customizing Interactive Grids

   • Customizing an Interactive Grid as a Developer

   • Making an interactive Grid Editable

   • Adding column group headers

   • Manage interactive grid attributes

   • Control Interactive Grid Pagination

   • Create error messages

   • Configure the Search bar, Action menu, and download options

   • Control if and how users save the report

   • Configure supported views.

   • Customize the Interactive Grid Toolbar

   • Enable Users to Save Public Interactive Grid

   • Modifying SQL Source of an Interactive Grid

   • Customize interactive grid as an end user

   • Rearranging and Resizing Grid Columns

   • Changing column display width in interactive grid

   • Adjusting column display order

   • Toggling columns button

   • Creating filter, highlight row or Column

   • Downloading or Emailing an Interactive grid

   • Refresh an interactive Grid

   • Interactive grid Flashback, Reversing an interactive Grid to a Previous State

   • Classic Reports Overview

   • Customization of Classic Reports

   • Using Different Templates for Classic Reports

   • Using Classic Reports as Cards

   • Using Classic Reports as Media List

   • Using Classic Reports as Timeline

   • Using Classic Reports as Value Attribute Pairs

   • Classic Report with Download and Printing Options

   • Faceted Search in Oracle Apex

   • Design Cards in oracle Apex

8. Interactive Reports Advance Topics

   • URL Types in Oracle APEX

   • Redirect to other pages in APEX

   • APEX_UTIL.PREPARE_URL Utility

   • Call Saved Reports & Apply Filters Runtime

9. Creating and Using Data Forms

   • Describe an application form in Application Express

   • Understanding form types

   • Understanding Item Types

   • List the different types of application forms that you can create

   • List the different wizards you use to create forms

   • Create a form on a table and link a report to a form

   • Create an editable interactive grid

   • Creating a master detail form

   • Different types of master detail forms and reports in APEX

   • Editing a form using Quick Edit option

   • Modifying Display Type of a Page Item

   • Altering Display order of page items

10. Creating Application Page Items

    • Identifying different types of Items

    • Different types of page items

    • Create and use page level items and edit Item attributes

    • Create and use application level items

    • Referencing items values in SQL, PL/SQL and static text

    • Creating a Quick Pick Selection

    • Adding Help Text along with Page Items.

    • What is a List of Values (LOV)? And Types of LOVs

    • Usage of Select List, Popup LOV, Radio Group, Checkbox and Shuttle component in APEX

    • Popup LOV with Additional Outputs

    • Creating a Static and Dynamic LOVs

    • Creating shared LOVs to use on Multiple pages within application

    • Associating a Named LOV (Shared Component) with an Item

    • Creating a Cascading LOV

    • Create and use buttons

    • Auto Complete Text Field and Rich Text Editor

    • Date Picker, Checkboxes and Radio Buttons

11. Computations, Validations, Processes and Branching

    • Explain page rendering and page processing

    • Show page (page rendering) and Accept Page (Page Processing) processes

    • What is a computation?

    • Creating a page-rendering computation.

    • Creating a page-processing Computation.

    • What is a process?

    • Create form wizard automatic data manipulation Processes

    • Automatic Row Fetch Process

    • Automatic Row Processing process

    • Create a page level process

    • Creating on submit process

    • Create on Load Process

    • Application Level Process

    • Page Rendering Process

    • Understanding Validations

    • Creating a Validation for a Page Item

    • Creating a SQL Validation Type

    • Creating a PL/SQL Validation Type

    • Creating a Regular Expression Validation Type

    • Creating a Row Validation in an Interactive Grid

    • Understanding Branching

    • Create a branch within an Application

12. Shared Components & Global Navigations

    • Describe the use of shared components in an application

    • Understanding Navigational Shared Components

    • Create, edit, and use the following shared components that aid navigation in an application:

      1. Lists

      2. Navigation Menus

      3. Breadcrumbs

      4. Navigation bar entries

    • What are Lists?

    • APEX Support for Lists

    • What are Static and Dynamic Lists?

    • Creating Static List.

    • Adding Entries to a List.

    • Creating a Dynamic List

    • Adding a list to a page.

    • What is a Navigation Menu?

    • Creating a Navigation Menu Entry.

    • What is Breadcrumb?

    • Creating a Breadcrumb.

    • Adding Breadcrumb Entries.

    • Adding a Breadcrumb Region in a Page.

    • What is a Navigation Bar Entry?

    • Accessing a Navigation bar List.

    • Creating a Navigation bar List.

13. Themes and Theme Styles

    • Describe themes and templates

    • Types of Themes supported in APEX.

    • Standard themes and custom themes

    • Accessing Themes Page in Shared Components

    • Editing APEX Universal Theme

    • Creating a new theme from the Repository.

    • Creating a Copy of an Existing Theme.

    • Switching an Active Theme

    • Understanding Universal theme

    • Using theme Styles

    • Creating a Theme Style

    • Enabling Users to select a theme style as per their choice.

    • Using Theme Roller, Declarative way to style your applications

    • Understanding Templates and Template Options

    • Creating Template Options

    • Using Live Template Options

    • Using Custom Cascading Style Sheets.

    • Uploading CSS, JavaScript, icons and images to static files

14. Creating Maps

    • Create map using latitude & longitude

    • Create map using Geometry

    • Get latitude & longitude Dynamically

15. Security Implementation

    • How to secure an APEX application?

    • How to implement Authentication in APEX?

    • Custom Authentication Scheme

    • How to Change Current Authentication Scheme?

    • Create Global or Application Level Page Items

    • Show Signed-in Username in Navigation Bar

    • Database Accounts Authentication Scheme

    • No Authentication Scheme

    • Open Door Credentials Authentication Scheme

    • Application Express Accounts Authentication Scheme

    • Social Sign-in | OAUTH2 | Google Authenticator

    • Providing Security through Authorization

    • Create and attach an authorization scheme to your entire application, page, region & Other components

    • Creating Access Control Administration Page.

    • Creating an Authorization Scheme to an Application.

    • Attaching an Authorization Scheme to a Page.

    • Attaching an Authorization Scheme to a Control or components.

    • Enable and configure Session State Protection.

16. Creating and Using Dynamic Actions & plug-ins

    • Describe Dynamic Actions

    • Create and use Dynamic Actions

    • Understanding Dynamic action Events

    • Categories of Events

    • Browser Events

    • Framework Events

    • Component Events

    • Custom Events

    • Enable & Disable, Hide and Show Page Items

    • Enable & Disable using javascript

    • Validation Errors, Add & Remove CSS

    • Highlight Page Items on Focus

    • Execute Server Side Code By Dynamic Action

    • Setting Value of Page Items.

    • Set Page Item Value Using PL/SQL Function

    • Filter Data and Refresh Region

    • Describe, import and use Plug-ins

    • Implement Plug-ins in your application

    • Viewing Plug-in Repository

    • Importing and installing a Plug-in

    • Viewing a plug-in Definition

17. Calendar Component

    • Creating Calendars

    • Editing Calendar Attributes in Property editor

18. Tree Component

    • Creating and modifying Tress in APEX

    • Enabling dragging and dropping of Data

19. Migrating Applications, DB Objects & Plugins Between Environments[DEV,QA,UAT,PROD]

    • Export entire application and its supporting objects

    • Importing application into target Environment

    • Migrating database objects – tables, triggers etc.

    • Migrating data from one application to other

    • Recreating database objects in target Environment.

    • Identifying the supporting objects for your application

    • Migrate Plugins from Dev Environment to  Prod Environment

20. Oracle APEX 23.2 – New Features

    • Combo box Page Item

    • Image Upload Page Item

    • Generate QR Code & Bar Code

    • Application Working Copies

    • Integrated Diff

    • Simple Merge

    • Workflow

    • Custom Map Backgrounds

    • Support for Fusion Apps Extensions

    • Workflow and Approvals Enhancements

21. Oracle APEX 24 – New Features

    • Comping Soon

Rating Distribution

• 1 stars: 9 votes
• 2 stars: 4 votes
• 3 stars: 15 votes
• 4 stars: 31 votes
• 5 stars: 67 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!