Skip to Content

Oracle APEX Full Stack 

Oracle APEX empowers you to build modern, responsive, and powerful applications—fast and without unnecessary complexity.

Even with just basic SQL knowledge, you can turn spreadsheets or data models into fully functional web apps in minutes.

With its tight integration with Oracle Database, APEX eliminates heavy coding, middle-tier overhead, and remote API complexity—so you focus on delivering value, not fighting technology.

  • 40 Training hours
  • 10 Sessions
  • 2 Sessions / week (Sunday / Wednesday)
  • Session Duration: 4 Hours

Current Registrations are for October Cycle that starts on Wednesday 1/10/2025

Wednesday / Sunday - 7:00 PM - 11:00 PM

What will you learn?

Database Design Concepts​

Learn the principles of structuring databases to ensure accuracy, consistency, and efficiency in data management.

Understand normalization, relationships, and keys to build scalable, reliable, and high-performance database systems.

Oracle APEX Development Environment

Discover a low-code, browser-based platform that simplifies building modern, data-driven web applications.

Leverage its intuitive interface, built-in tools, and seamless Oracle Database integration to accelerate development.

SQL

Master the industry-standard language for querying, managing, and manipulating data in relational databases.

Learn to retrieve insights, update records, and design efficient queries to power real-world applications.

PL/SQL Programing

Gain the skills to write powerful stored procedures, functions, and triggers inside Oracle Database.

Combine SQL with procedural logic to build secure, efficient, and scalable database applications.

CSS

Learn how to style and design web pages with cascading style sheets for modern, responsive layouts.

Master colors, fonts, positioning, and animations to create visually engaging user experiences.

Javascript

Unlock the power of interactivity by learning the most popular programming language for the web.

Build dynamic features, control user actions, and enhance applications with responsive, real-time functionality.

Course Outlines

Oracle APEX Professional Full Stack Sessions

( 1  ) Introduction to the course (4 Hours)

  • Oracle APEX
  • apex.oracle.com  - Oracle Cloud Autonomous Database - Third Party Hosting Companies
  • Introduction to Oracle APEX Platform

( 2 ) SQL Workshop (4 Hours)

  • Tables - Lookups
  • SQL Commands
  • SQL Scripts
  • Data Workshop
  • Query Builder
  • Quick SQL

( 3 ) APP Builder ( 4 Hours)

  • Create / Delete applications
  • Page Designer
  • Regions
    • Static Content
    • Classic Report
    • Charts
    • Interactive reports
    • Interactive Grids
    • Forms
    • Master / Details

( 4 ) Page Items / Buttons (4 Hours)

  •  Text Field
  • Number Field
  • Checkbox Field
  • Color Picker
  • Popup LOV
  • Display Only
  • Radio Group
  • Buttons

( 5 ) DA / Processes / Branches (4 Hours)

  • Dynamic Actions
  • Processes
  • Branches

( 6 ) Navigation / Computation / Validation (4 Hours)

  • Navigation
  • Computation
  • Validation

( 7 ) Shared Components / Security (4 Hours)

  • LOV
  • Static Application Files
  • Plugins
  • Send Email
  • Authentication
  • Authorization

( 8 ) Globalization / APIs (4 Hours)

  • Globalization Techniques
  • Translation Process
  • APIs

( 9 ) CSS / JavaScript (4 Hours)

  • CSS
  • JavaScript
  • How to implement CSS & JavaScript inside Oracle APEX

( 10 ) PL/SQL (4 Hours)

  • Functions
  • Procedures
  • Packages
  • Cursors
  • Triggers

6000 EGP 3000 EGP

Register