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.

Your students will learn about the various roles within the APEX ecosystem and deployment options, preparing them for real-world application development and teamwork. The course emphasizes practical exercises, including creating queries, designing user interfaces, and developing applications, to apply theoretical knowledge in realistic scenarios. This hands-on approach ensures that students gain valuable experience in building scalable, secure applications with APEX.

By offering this course, you're not just enhancing your training portfolio but also providing your students with a skill set that is highly valued in today's job market. Students taking this course will learn to use APEX to tackle complex business challenges, making them strong candidates for development teams seeking to leverage Oracle's powerful application development platform.

Benefits to you:

• Introduces the fundamentals of Oracle Application Express (APEX), setting a solid foundation for web-based application development.
• Explains the history and evolution of APEX, providing context and appreciation for its current capabilities.
• Highlights the significance of APEX in the tech industry for its low-code, rapid application development environment.
• Offers an in-depth look at APEX's architecture and components, enabling a better understanding of how applications are built and run.
• Covers the main programming languages used in APEX, primarily SQL and PL/SQL, enhancing data manipulation skills.
• Defines the various user roles within the APEX ecosystem, preparing students for team collaboration in real-world projects.
• Discusses APEX deployment options, equipping students with knowledge for moving applications from development to production.
• Includes hands-on exercises, such as creating queries, designing user interfaces, and developing full applications, for practical learning.
• Teaches best practices in application development, from data model creation to security, ensuring students build efficient and secure applications.
• Prepares students for the job market by providing them with a sought-after skill set in developing scalable and secure web applications.

What is Included?

• Student Manual
• Student Class Files
• PowerPoint Presentation
• Labs (optional add-on)

1. 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)

2. 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)

 3. Applications

• App Builder Areas
• Creating An Application (Exercise)
• Options for Creating an Application
• Best Practice: Create the Oracle Data Model

4. 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)

4. Regions

• Working with Regions
• Creating Regions on a Page (Exercise)

5. Classic Reports

• Classic Reports Overview
• Creating A Classic Report (Exercise)
• Classic Report Attributes
• Alternative for Creating a Classic Report Page

6. Forms

• Basic Functionality of a Form
• Browsing Records in a Table
• Create a Form to Browse Employees (Exercise)

7. Interactive Reports

• Features of Interactive Reports
• Create Departments Interactive Report (Exercise)
• Using Drill Downs (Exercise)

8. Items

• The ABCs of Items
• Layout Properties
• Building a Dynamic Countries Form with APEX Items (Exercise)
• Dynamic Department Filtering with APEX Checkboxes (Exercise)

9. Buttons and Sessions

• Button Actions
• Session State Management
• Exploring Session Management and Redirection in APEX (Exercise)

11. Computations

• Application Computations vs. Page Computations
• Calculate Employee Benefits Contribution
• Create a Computation (Exercise)

12. Validations

• Validations Overview
• The Sequence of Events During Page Submission
• Create Validations (Exercise)

13. Processes

• Application Processes vs. Page Processes
• Page Processes
• Creating Insert and Delete Processes (Exercise)

14. Branches

• Understanding Branches in Oracle APEX
• Create Departments in Country Branch (Exercise)

15. Using Plug-ins

• Plug-in Basics
• Using a Plug-In (Exercise)
• Best Practice: Choose Your Plug-ins Wisely

16. Calendars

• APEX Calendar Features
• Using a Calendar For Employee Hire Date (Exercise)

17. Dynamic Actions

• Types of Dynamic Actions
• Creating and Using Dynamic Actions (Exercise)
• Adding Check and Uncheck All Buttons (Exercise)

18. Security

• Session State Protection
• Understanding Authorization Schemes
• Hashing
• Creating Authentication and Authorization Schemes (Exercise)
• Best Practice: Build to be Secure

19. Deployment

• What is Deployment?
• Deployment Strategies
• Exporting and Importing Applications
• Exporting and Importing an Application (Exercise)

20. Team Development

• Team Development Overview
• Creating an Issue in Team Development (Exercise)

Required Prerequisites

• SQL
• PL/SQL

Useful Prerequisites

• HTML
• CSS
• JavaScript
• jQuery