Skip to main content
Request a Training Proposal

Instructor-led training

Introduction to Oracle Application Express Training in Kitchener, Canada

Oracle training from Hartmann Software Group, delivered onsite in Kitchener, Canada or live online.

Request a Training Proposal View Course Outline

What you'll learn

The course provides a thorough introduction to Oracle APEX, designed to equip your students with the knowledge to develop web-based database applications efficiently. It starts by introducing APEX, outlining its evolution and highlighting its significance in the tech industry for its low-code, rapid application development environment. This foundation sets the stage for a deeper exploration into APEX's architecture, components, and the main programming languages used, primarily SQL and PL/SQL.

Prerequisites

HTML, CSS, JavaScript, jQuery

Course Outline

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

Training locations

Introduction to Oracle Application Express training across the U.S. and beyond.

We provide Introduction to Oracle Application Express training onsite and live online for organizations throughout the United States and internationally.

View all Introduction to Oracle Application Express training locations

Train your team with HSG

Private, instructor-led training customized for your organization.

  • Onsite or live online delivery
  • Customized curriculum
  • Training for groups of 3 or more
  • Flexible scheduling
  • Experienced instructors
Request a Training Proposal

Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com

Browse all Oracle courses →

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176