Home / Courses / Oracle Apex Online Training

Oracle APEX Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

Reviews 4.9 (4.6k+)
Rated 4.7 out of 5

Learners : 1080

Duration :  25 Days

About Course

The Oracle APEX training course equips learners with the skills to build and deploy low-code web applications quickly using Oracle’s Application Express platform. This course covers APEX architecture, workspace setup, application design, forms, reports, charts, themes, interactive grids, RESTful web services, and security. Participants gain hands-on experience in creating responsive applications, integrating with Oracle databases, and automating business processes. With real-world projects and labs, learners master application customization, PL/SQL integration, and deployment strategies. Designed for developers, DBAs, and business analysts, this program also prepares learners for Oracle APEX certification, advancing careers in low-code app development and database-driven solutions. Enrol today to earn your certification.

Oracle APEX Training Course Syllabus

Introduction To Oracle Application Express
  • Get started with the introduction of Oracle Apex, Understand the roles, and logging format of Oracle apex, and also about the Architecture.
  • What is Oracle Application Express (oracle apex)?
  • Oracle apex Architecture
  • Understanding Oracle apex Roles
  • Logging into Oracle apex
Apex Demonstration Application
  • This section describes how to create and log provided with Oracle Apex Workspace, Installation of Apex, and also about Running and analyzing how an application works in an effective way for better understanding.
  • Creating and logging onto apex workspace
  • Apex Installation and demonstration application
  • Running Apex demonstration application
Apex Application Builder Concepts
  • Learn basic conceptual information about Application Builder in this module.
  • Page processing and Rendering in Apex
  • Apex Session Management
  • Substitution strings & URL syntax in Apex
Using SQL Workshop In Apex
  • This module describes how to use Oracle Apex utilities to build SQL queries, Delete and run SQL & PL/SQL scripts in Apex, generate DDL and view object reports in Apex.
  • Using Object Browser to view in Apex
  • Create, edit and drop database objects in Apex
  • Using SQL Commands to interact with database in Apex
  • Using SQL Scripts to create, edit, Delete and run SQL & PL/SQL scripts in Apex
  • Using Query Builder to build queries graphically
Building An Application In Oracle Apex
  • Understand how to create an application from Spreadsheet, Scratch and Wizard in Apex.
  • Creating an application from wizard
  • Creating an application From Scratch in Apex
  • Creating an application From Spreadsheet in Apex
Understanding Pages And Regions In Apex
  • The focus in this module describes, what Page, Region is, Different Section and attributes in Apex Page and Apex Region respectively, and how to control Apex page.
  • What is a Page in APEX
  • Controls on an APEX Page
  • Different Sections of an APEX Page
  • Page Rendering
  • Apex Page Processing
  • Apex Shared Components
  • Attributes of an Apex Page
  • What is a Region
  • Different Attributes of an Apex Region
Creating Interactive Reports In Apex
  • Learn, How to create Interactive Reports, Attributes of it and also about Column Attributes in Apex..
  • Creating Interactive Reports in Apex
  • Interactive Apex Report Attributes
  • Interactive Report Column Attributes in Apex
Creating SQL Reports In Apex
  • Here, You’ll learn how to create SQL Reports, Attributes of it, and also about SQL report Column Attributes..
  • Creating SQL Reports
  • Apex SQL Report Attributes
  • Apex SQL Report Column Attributes
Creating Forms In Apex
  • This module explains, how to create different types of forms in Apex and also Understand Page Rendering & Page Processing Components Required for Form in Apex.
  • Creating Forms with Report in Apex
  • Creating Simple Forms in Apex
  • Creating Tabular Forms in Apex
  • Creating Master-Detail Forms in Apex
  • Creating Forms in Apex Using Wizards and
  • Manually Understanding Page Rendering & Page Processing Components Required for Form in Apex
Working With Items & Buttons In Oracle Apex
  • Learn, how to create Tabs, lists, Breadcrumbs, and different types of Items and also about Navigation of Apex.
  • Creating Different Types of Items in Apex (Text, Text Area, Checkbox, Select List, Radio Group, etc.)
  • Creating Buttons in Apex
  • Understanding Buttons in Apex
  • Apex Navigation
  • Creating Tabs, Lists, and Breadcrumbs in Apex
  • Apex Navigation Bar
  • List of Values
Oracle Apex Shared Components
  • Understand Different Attributes of Apex Shared Components and also the usage Shared Components in Apex Pages.
  • Understanding Different Attributes of Apex Shared Components
  • Using Shared Components in Apex Pages
Page Processing In Apex
  • By the end of this module, you’ll have a thorough understanding of Page Rendering, How to process it, and also about computation and validations in Apex.
  • Having a Thorough Understanding of the Following Sections of Page Rendering & Processing
  • Computations in Apex
  • Validations in Apex
  • Processes and Branches in Apex
Themes & Templates In Apex
  • Understand, What Theme is, Different types of Themes and also usage of Template and how to view Template in Apex..
  • Understanding Themes in Apex
  • Switching Themes
  • Changing Theme Defaults
  • Understanding Templates and viewing template definitions specific to Apex
Oracle Apex Security
  • This section describes how to implement security best practices for Oracle Apex, Creating an Custom Authenication, Creating Authorization Schemes and how to attach Authorization Schemes to pages, Regions, Tabs etc…
  • Managing Application Security in APEX
  • Understanding Different Authentication Options in APEX
  • Creating a Custom Authentication
  • Switching from One Authentication Method to Another
  • Understanding Authorization in APEX
  • Creating Authorization Schemes
  • Attaching Authorization Schemes to Pages, Regions, Tabs etc. in APEX
Packaging & Deploying Application
  • Learn, how to package an application built within Application Builder, Different Deployment Options, and how Deploy applications from one environment to another.
  • Understanding Different Deployment Options in APEX
  • Understanding the Packaging & Deployment Process
  • Packaging Application with Supporting Objects in APEX
  • Deploying Applications from One Environment to Another
Oracle APEX Course Key Features

Course completion certificate

Oracle APEX Training - Upcoming Batches

Coming Soon

AM IST

Weekday

Coming Soon

AM IST

Weekday

Coming Soon

PM IST

Weekend

Coming Soon

PM IST

Weekend

Don't find suitable time ?

Request More Information

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

PREFERRED

Self-Paced Learning

Corporate Training

FOR BUSINESS

Oracle APEX Online Training FAQ'S

What is Oracle APEX and why is it used?

Oracle APEX (Application Express) is a low-code development platform that enables developers to quickly build secure, scalable, database-driven web applications. It is widely used because it reduces development time and leverages the power of the Oracle Database.

What are the key features of Oracle APEX?

Some of the key features include low-code app development, responsive user interfaces, RESTful API integration, interactive grids, charts, reports, and robust security features. These make it suitable for enterprise-level application development.

How does Oracle APEX integrate with Oracle Database?

Oracle APEX applications run directly on the Oracle Database, using SQL and PL/SQL for queries, data manipulation, and business logic. This tight integration ensures high performance, scalability, and security for data-centric applications.

What are interactive grids in Oracle APEX and how are they useful?

Interactive grids provide a spreadsheet-like interface where users can view, search, edit, and manipulate data directly. They are useful for creating dynamic user experiences by allowing inline data editing and personalized views without complex coding.

What are the main benefits of using Oracle APEX for businesses?

Oracle APEX offers faster application delivery, reduced development cost, responsive design, and scalability. Businesses benefit from a low-code approach that reduces IT overhead while ensuring applications are secure, modern, and easy to maintain.

Reviews

More Courses You Might Like

No posts found!