Duration 5 days – 35 hrs
Overview
This course provides a comprehensive introduction to Oracle Application Express (APEX), Oracle’s low-code development platform for building scalable, secure, and responsive web applications. Participants will learn how to use APEX to rapidly develop applications that leverage Oracle Database features without extensive programming. Through a combination of lectures, demonstrations, and hands-on labs, learners will gain the skills needed to create interactive reports, forms, dashboards, and workflows — all within a browser-based development environment.
Objectives
- Understand Oracle APEX architecture and components.
- Navigate the APEX workspace and development environment.
- Create and manage database objects within APEX.
- Develop interactive reports, charts, and dashboards.
- Build data entry forms with validations and dynamic actions.
- Apply security, authentication, and authorization in APEX applications.
- Deploy and maintain APEX applications for end-users.
Audience
- Application Developers and Database Developers.
- Oracle Database Administrators interested in app development.
- Business Analysts and IT Professionals seeking to create business applications quickly.
- Anyone interested in low-code application development.
Pre- requisites
- Basic understanding of databases and SQL.
- Familiarity with Oracle Database concepts is an advantage but not mandatory.
- Basic knowledge of web technologies (HTML, CSS) is helpful.
Course Content
Day 1 Introduction to Oracle APEX
- What is Oracle APEX and Its Benefits
- APEX Architecture and Components
- Understanding the Workspace and Development Environment
- Creating and Managing Workspaces
- Overview of APEX Application Types
- Hands-On: Setting up Your First APEX Workspace
Day 2 Working with Database Objects
- Understanding Schemas in APEX
- Creating Tables, Views, and Sequences
- Importing and Managing Data in APEX
- Using SQL Workshop for Database Tasks
- Hands-On: Creating Database Objects for an Application
Day 3 Building Applications
- Creating Applications from Scratch and Using Wizards
- Page Designer Overview
- Interactive Reports and Interactive Grids
- Creating Charts and Dashboards
- Adding Forms and Validations
- Hands-On: Building a Simple Data Entry and Reporting Application
Day 4 Enhancing Applications
- Dynamic Actions and Client-Side Interactivity
- Navigation Menus and Breadcrumbs
- Working with Themes and Templates
- Adding Plug-ins and Reusable Components
- Security: Authentication and Authorization Schemes
- Hands-On: Adding Interactivity and Security to the Application
Day 5 Deploying and Maintaining Applications
- Managing Application Settings and Preferences
- Debugging and Performance Tuning in APEX
- Exporting and Importing Applications
- Deploying APEX Applications to Other Environments
- Best Practices for APEX Development
Final Project:
- Develop and present a small, functional APEX application.
- Q&A and Course Wrap-Up
