Oracle APEX Professional (2023)

Description

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 Overview

   • Describe SQL Workshop and list its components

   • What is SQL Workshop?

   • Object Browser

   • SQL Commands

   • 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.

   • RESTful Services

   • Browse through database objects using the Object Browser

   • Create and modify database objects

   • Create a lookup table

   • Run SQL commands and SQL scripts

   • 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 Overview

   • 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. Reports Development

   • 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

   • Perform a Flashback query

   • 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

   • URL Types in Oracle APEX

   • Redirect to other pages in APEX

   • APEX_UTIL.PREPARE_URL Utility

   • Call Saved Reports & Apply Filters Runtime

8. Creating and Using Data Forms in Oracle APEX

   • 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

9. 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

10. 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

11. 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.

12. Themes and Theme Styles Implementation

    • 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

13. Security Implementation

    • How to secure an APEX application?

    • How to implement Authentication in APEX?

    • Open Door Credentials

    • Application Express Accounts

    • Database Accounts

    • LDAP Directory

    • Oracle Application Server Single Sign-On

    • Custom

    • HTTP Header Variable

    • Providing Security through Authorization

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

    • How to implement Authorization.

    • Creating an Authorization scheme from Scratch.

    • 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.

14. Creating and Using Dynamic Actions and 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

    • Enabling and Disabling Items

    • Setting Value of Page Items.

    • Refresh a 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

15. Calendar Component

    • Creating Calendars

    • Editing Calendar Attributes in Property editor

16. Tree Component

    • Creating and modifying Tress in APEX

    • Enabling dragging and dropping of Data

17. Migrating Application Development Between Environments

    • 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

18. Oracle APEX 23.1 - New Features

    • Template Components

    • PWA Push notifications

    • Modernized Object Browser

    • Partials for Report Columns

    • Page Processing Improvements

    • New Process and API

    • Improvements to APEX Administration

    • REST Data Source Enhancements

    • SQL Developer Web Integration

    • Capture ECID in Webservice Log

    • New APEX_APPLICATION_ADMIN API

    • Approvals Component Enhancements

    • Old JET Color Picker Replaced with New Color Picker

19. Oracle APEX 23.2 - New Features

    • Combobox 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

Who this course is for:

• Beginners and Professional Developers, who are curious to learn Oracle APEX.