Description

Description

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.

Training 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.

Course Outline

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