HOME > Development > Oracle APEX Professional (2024)

Oracle APEX Professional (2024)

Development
Jan 05, 2025

SynopsisOracle APEX Professional (2024 , available at $79.99, has an...

Oracle APEX Professional (2024), available at $79.99, has an average rating of 4.1, with 98 lectures, based on 126 reviews, and has 668 subscribers.

You will learn about The course provides the entire toolbox you need to become an Oracle APEX Professional Developer Impress interviewers by showing an understanding of the complete Oracle APEX framework Unfold the power of Oracle APEX low code platform Learn how to build a new web application from scratch Using Oracle APEX Build, use and customize different types of charts in your application Customize the look and feel of your application using theme roller Implement security in your application, Authentication and Authorization Migrate your application between environments, DEV, UAT and Production Oracle APEX 23.1 and 23.2 – New Features This course is ideal for individuals who are Beginners and Professional Developers, who are curious to learn Oracle APEX. It is particularly useful for Beginners and Professional Developers, who are curious to learn Oracle APEX.

Enroll now: Oracle APEX Professional (2024)

Summary

Title: Oracle APEX Professional (2024)

Price: $79.99

Average Rating: 4.1

Number of Lectures: 98

Number of Published Lectures: 97

Number of Curriculum Items: 98

Number of Published Curriculum Objects: 97

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

The course provides the entire toolbox you need to become an Oracle APEX Professional Developer

Impress interviewers by showing an understanding of the complete Oracle APEX framework

Unfold the power of Oracle APEX low code platform

Learn how to build a new web application from scratch Using Oracle APEX

Build, use and customize different types of charts in your application

Customize the look and feel of your application using theme roller

Implement security in your application, Authentication and Authorization

Migrate your application between environments, DEV, UAT and Production

Oracle APEX 23.1 and 23.2 – New Features

Who Should Attend

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

Target Audiences

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

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

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
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
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
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
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
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
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
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
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
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
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
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.
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
Creating Maps
Create map using latitude & longitude
Create map using Geometry
Get latitude & longitude Dynamically
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.
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
Calendar Component
Creating Calendars
Editing Calendar Attributes in Property editor
Tree Component
Creating and modifying Tress in APEX
Enabling dragging and dropping of Data
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
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
Oracle APEX 24 – New Features
Comping Soon

Course Curriculum

Chapter 1: Oracle APEX Overview and Architecture

Lecture 1: Instructor Introduction

Lecture 2: What is Oracle APEX?

Lecture 3: Oracle APEX Architecture

Lecture 4: Create Workspace in Oracle APEX

Lecture 5: Internal Workspace and Schema Assignment

Lecture 6: Oracle APEX Major Components

Chapter 2: SQL Workshop

Lecture 1: SQL Workshop Major Components

Lecture 2: Create Lookup Table

Lecture 3: SQL Commands and SQL Scripts

Lecture 4: Load CSV,XLSX,XML and JSON data into Database Table

Lecture 5: Unloading Table data into Text or XML File

Lecture 6: Query Builder Utility – Declarative way

Lecture 7: Installing Datasets in Oracle APEX

Lecture 8: Methods on Tables Utility – Create Package and procedures

Lecture 9: Generate DDL

Lecture 10: Quick SQL Utility to create SQL

Chapter 3: Creating Database Applications

Lecture 1: Create Database Application in Oracle APEX

Lecture 2: Edit Database Application Properties

Lecture 3: Create Applications from Files

Chapter 4: Oracle APEX Page Designer

Lecture 1: Page Designer Major Comonents

Lecture 2: Page Components

Chapter 5: Developing Reports

Lecture 1: Different Types of Reports

Lecture 2: Create Reports in APEX

Lecture 3: Integrative Grid in Oracle APEX

Lecture 4: Create Report with Form

Chapter 6: Managing and Customizing Interactive Reports

Lecture 1: Customize Interactive Grid as a Developer- Pagination

Lecture 2: Customize Search Bar & Action Menu

Lecture 3: Interactive Reports Download Formats

Lecture 4: Column Headers & Linking Columns

Lecture 5: Create Classic Report & Customization

Lecture 6: Classic Report as Cards

Lecture 7: Classic Report as Value Attribute Pairs

Lecture 8: Classic Report with Download and Printing Options

Lecture 9: Faceted Search in Oracle APEX

Lecture 10: Cards in Oracle Apex

Lecture 11: Master Detail Forms in APEX

Chapter 7: Managing and Customizing Interactive Grids

Lecture 1: Customize Reports as End User

Lecture 2: Interactive Report Row or Column Highlight

Lecture 3: Download Reports as PDF & Excel

Chapter 8: Interactive Reports Advance Topics

Lecture 1: Interactive Report Detail View

Lecture 2: Add CSS to Detail View

Lecture 3: URL Types & Redirect to Other Pages

Lecture 4: Drill Down Interactive Reports

Lecture 5: Call Saved Reports & Apply Filters Runtime

Chapter 9: Creating and Using Data Forms

Lecture 1: Form Types and Item Types

Lecture 2: Form as a Region

Lecture 3: Custom Form and Page Item Properties

Lecture 4: Custom Form and Page Item Properties Part2

Chapter 10: Creating Application Page Items

Lecture 1: Select List in Oracle APEX

Lecture 2: Cascading Select Lists in Oracle Apex

Lecture 3: Popup LOV with Additional Output

Lecture 4: Date Picker, Radio Buttons and Checkboxes

Lecture 5: Auto Complete and Rich Text Editor

Lecture 6: Radio Buttons and Check Boxes

Lecture 7: Dynamic Content with Static Content

Lecture 8: Dynamic Content with database Data

Lecture 9: Dynamic Content apex version 18 or lower

Chapter 11: Computations, Validations, Processes and Branching

Lecture 1: Page Rendering and Processing Process

Lecture 2: Computation Types and Page Level Computation

Lecture 3: Application Level Computation

Lecture 4: Page Level Process- Rendering & Submission Process

Lecture 5: Application Level Process – Download Image from Blob Column

Lecture 6: Validations and Branching

Chapter 12: Shared Components & Global Navigations

Lecture 1: Shared Components & Static Navigation List

Lecture 2: Shared Components & Dynamic Navigation List

Lecture 3: Breadcrumbs

Lecture 4: Navigation Bar List

Lecture 5: List As Navigation Menu

Chapter 13: Themes and Theme Styles

Lecture 1: Describe Themes, Templates and Theme Types

Lecture 2: Create, Edit and Switching Active Theme

Lecture 3: Enable end users to Select Theme

Chapter 14: Creating Maps

Lecture 1: Create Maps using latitude, longitude & Geometry

Chapter 15: Security Implementation

Lecture 1: Custom Authentication

Lecture 2: Database Authentication Scheme

Lecture 3: Social Sign-in | OAUTH2 | Google Authentication

Lecture 4: Single Sign On Using Azure Active Directory

Chapter 16: Creating and Using Dynamic Actions & plug-ins

Lecture 1: Enable & Disable, Hide and Show Page Items

Lecture 2: Enable & Disable using javascript

Lecture 3: Validation Errors, Add & Remove CSS

Lecture 4: Highlight Page Items on Focus

Lecture 5: Execute Server Side Code By Dynamic Action

Lecture 6: Setting Value of Page Item

Lecture 7: Set Page Item Value Using PL/SQL Function

Lecture 8: Filter Data and Refresh Region

Instructors

Muhammad Arshad
Senior Oracle APEX Developer

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!

Random Picks
Popular
Hot Reviews

Prev：PCB Design with KICAD from Basic to Advanced Next：Blender 3.0- Product Animation MasterClass