Introduction to Oracle APEX Training

Introduction to Oracle APEX Training (APEX101)

Course Length: 5 days
Delivery Methods: Multiple delivery options
Course Overview

This course offers a comprehensive introduction to Oracle Application Express (APEX), a low-code development platform that enables the creation of scalable, secure web applications. It is ideal for developers, database administrators, and IT professionals who want to leverage APEX to build robust applications with minimal coding.

The course begins with an introduction to APEX, covering its history, architecture, and the main programming languages involved. You'll learn about the different user roles within the APEX ecosystem and explore various deployment options. Practical exercises will help you navigate the APEX Workspace and understand its hierarchical structure.

Next, the course delves into SQL Workshop, where you'll get hands-on experience with the components of SQL Workshop, including Query Builder. You'll learn how to select data from single and joined tables and create queries using both graphical representation and reports.

The Applications module guides you through the App Builder, showing you how to create an application and understand the best practices for designing the Oracle Data Model. The Pages section introduces the Page Designer tool, helping you to create and design web pages effectively, with exercises focused on creating an "About Us" page.

You will also explore working with Regions, Classic Reports, and Forms. These sections include practical exercises on creating regions on a page, generating classic reports, and building forms to browse table records.

The course covers Interactive Reports, focusing on their features and how to use drill-downs effectively. You will learn about Items, Buttons, and Sessions, with exercises that guide you through building dynamic forms and managing session states in APEX.

Advanced topics such as Computations, Validations, Processes, and Branches are covered in detail, providing you with the skills to manage complex application logic and workflows. You will also learn how to use Plug-ins and Calendars to enhance your applications' functionality and user experience.

Dynamic Actions and Security are key components of the course, where you'll explore how to create interactive user interfaces and implement strong security measures, including session state protection and authorization schemes.

The course concludes with modules on Deployment and Team Development. You'll learn how to deploy APEX applications effectively, export and import applications, and manage team collaboration using APEX's built-in tools.

By the end of this course, you'll be equipped with the knowledge and skills to develop, deploy, and manage applications using Oracle APEX, ensuring they are secure, scalable, and meet your organization's needs.

Course Benefits
  • Gain a solid understanding of Oracle Application Express (APEX) and its architecture.
  • Learn to build and deploy web applications quickly and efficiently using APEX.
  • Acquire practical experience through hands-on exercises and real-world scenarios.
  • Understand the use of SQL Workshop for data manipulation and query building.
  • Master the design and development of application pages and user interfaces.
  • Explore dynamic actions and interactive reports to enhance application functionality.
  • Develop skills in managing security, session states, and user authentication in APEX applications.
  • Learn best practices for application development, deployment, and team collaboration.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
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)
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Oracle Application Express (APEX) class:

  • SQL
  • PL/SQL

Experience in the following would be useful for this Oracle Application Express (APEX) class:

  • Some Web Development experience with:
    • HTML
    • CSS
    • JavaScript and jQuery
Prerequisite Courses

Courses that can help you meet these prerequisites:

Follow-on Courses
Live Public Class
$2,795.00 / student
Please select a class.
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal