Search
START TYPING AND PRESS ENTER TO SEARCH

    Have a Question About This Course?





    Image

    Introduction to Oracle Application Express

    Database Development - 5 Days
    This course is designed to teach students how to build efficient, database-driven applications using Oracle APEX (Application Express). It begins with an introduction to APEX—tracing its evolution and highlighting its growing importance in the tech industry as a powerful low-code platform for rapid application development.

    Students will explore APEX’s architecture, core components, and the key programming languages it relies on—primarily SQL and PL/SQL. They’ll gain a solid understanding of the different roles within the APEX ecosystem and examine various deployment options, preparing them for real-world collaboration and application delivery.

    The course is highly practical, with hands-on labs focused on creating queries, designing intuitive user interfaces, and building functional, scalable applications. This approach bridges theory and practice, ensuring students walk away with the experience needed to develop secure, enterprise-grade applications using APEX.

    By offering this course, you're equipping students with an in-demand skill set that is highly relevant in today’s job market. Graduates will be well-prepared to join development teams looking to leverage Oracle APEX for solving complex business problems with speed and efficiency.

    Introduction to Oracle Application Express Objectives

    • This course provides a comprehensive introduction to the fundamentals of Oracle Application Express (APEX) laying a strong foundation for building web-based applications.
    • Students will gain an understanding of APEX’s history and evolution offering valuable context for appreciating its role as a powerful low-code platform for rapid application development. The course explores APEX’s architecture and key components giving students the insight needed to understand how applications are designed built and deployed within the platform.
    • Learners will work with the core languages used in APEX—SQL and PL/SQL—to strengthen their data handling and programming capabilities. The course also defines the user roles within the APEX environment preparing students for effective teamwork and collaboration in real-world projects.
    • Students will explore deployment strategies learning how to transition applications from development to production environments. Throughout the course hands-on exercises reinforce key concepts by guiding students through writing queries designing user interfaces and building full-featured applications.
    • In addition students will learn best practices for application development—including data modeling performance optimization and security—ensuring they can create robust scalable and secure web applications.
    • By the end of the course students will have acquired a highly marketable skill set
    • positioning them for success in roles that leverage Oracle APEX to solve business challenges efficiently and effectively.

    Need Assistance Finding the Right Training Solution

    Our Consultants are here to assist you
    Arrange a consultation

    Key Point of Training Programs

    We have different work process to go step by step for complete our working process in effective way.
    • Introduction to Oracle Application Express Prerequisites

      Required Prerequisites
      SQL
      PL/SQL
      Useful Prerequisites
      HTML
      CSS
      JavaScript
      jQuery

    • Introduction to Oracle Application Express Format

      In-Person

      Online

    • Introduction to Oracle Application Express Outline

      Introduction to APEX
      What is Oracle Application Express (APEX)?
      History of APEX
      Why Use APEX?
      Architecture and Components
      Main Programming Languages in APEX
      User Roles in the APEX Ecosystem
      APEX Deployment Options
      The APEX Hierarchy
      Log in to the APEX Workspace (Exercise)
      SQL Workshop
      Components of SQL Workshop
      Query Builder
      Selecting Data from a Single Table
      Joining Tables
      Creating Queries in Query Builder from Graphical Representation (Exercise)
      Creating Queries in Query Builder from Report (Exercise)
      Applications
      App Builder Areas
      Creating An Application (Exercise)
      Options for Creating an Application
      Best Practice: Create the Oracle Data Model
      Pages
      Page Designer Overview
      Create An About Us Page (Exercise)
      Page Designer: Left Pane
      Page Designer: Right Pane
      Page Designer: Central Pane
      Breadcrumbs and Navigation
      Understanding Layout
      Designing the About Us Page (Exercise)
      Regions
      Working with Regions
      Creating Regions on a Page (Exercise)
      Classic Reports
      Classic Reports Overview
      Creating A Classic Report (Exercise)
      Classic Report Attributes
      Alternative for Creating a Classic Report Page
      Forms
      Basic Functionality of a Form
      Browsing Records in a Table
      Create a Form to Browse Employees (Exercise)
      Interactive Reports
      Features of Interactive Reports
      Create Departments Interactive Report (Exercise)
      Using Drill Downs (Exercise)
      Items
      The ABCs of Items
      Layout Properties
      Building a Dynamic Countries Form with APEX Items (Exercise)
      Dynamic Department Filtering with APEX Checkboxes (Exercise)
      Buttons and Sessions
      Button Actions
      Session State Management
      Exploring Session Management and Redirection in APEX (Exercise)
      Computations
      Application Computations vs. Page Computations
      Calculate Employee Benefits Contribution
      Create a Computation (Exercise)
      Validations
      Validations Overview
      The Sequence of Events During Page Submission
      Create Validations (Exercise)
      Processes
      Application Processes vs. Page Processes
      Page Processes
      Creating Insert and Delete Processes (Exercise)
      Branches
      Understanding Branches in Oracle APEX
      Create Departments in Country Branch (Exercise)
      Using Plug-ins
      Plug-in Basics
      Using a Plug-In (Exercise)
      Best Practice: Choose Your Plug-ins Wisely
      Calendars
      APEX Calendar Features
      Using a Calendar For Employee Hire Date (Exercise)
      Dynamic Actions
      Types of Dynamic Actions
      Creating and Using Dynamic Actions (Exercise)
      Adding Check and Uncheck All Buttons (Exercise)
      Security
      Session State Protection
      Understanding Authorization Schemes
      Hashing
      Creating Authentication and Authorization Schemes (Exercise)
      Best Practice: Build to be Secure
      Deployment
      What is Deployment?
      Deployment Strategies
      Exporting and Importing Applications
      Exporting and Importing an Application (Exercise)
      Team Development
      Team Development Overview
      Creating an Issue in Team Development (Exercise)