
Oracle Apex is an enterprise low-code platform tightly integrated with the Oracle database, offering data visualization components, reports, and workflows suitable for developers and non developers, accessible in a browser.
Explore why Oracle apex is a leading low-code platform, how to start with a free apex workspace, and build a hello world app using app builder and classic reports.
Learn to install Oracle Apex sample data sets via SQL Workshop utilities, use the default schema, and validate installed tables like emp and dpt with SQL queries.
Create a form in Oracle APEX by selecting form, choosing a data source (table or SQL), setting the primary key, and deploying the page to enter or update data.
Create a blank page in Oracle APEX, add a static content region with user id, user name, and email fields, and a button that alerts entered data.
Explore creating and using page items and application items in Oracle APEX, including components like text fields and date pickers, lists of values, and dynamic show/hide behavior.
Master detail form in Oracle APEX demonstrates stacked, side-by-side, and drill-down layouts, using master and child tables with DML operations and interactive grids.
Explore Oracle APEX page modes: normal, modal dialog, and non modal dialog. Learn how modal dialog grays out the parent page while non modal keeps it active.
Explore interactive reports in Oracle APEX, including aggregation, compute, highlight, and pivot. Learn to create an interactive report from a table or query, customize layout, and save reports.
Master interactive grid in Oracle APEX by performing CRUD operations, applying control break, and building charts, guided by setup steps from login to selecting a table or SQL source.
Discover how to display multiple charts on a page in Oracle APEX by building a dashboard with a static content region and configuring the faceted search region to show charts.
Explore dialog pages in Oracle APEX, including modal and non modal dialogs, their design steps, testing, and how to set targets and page modes within a typical APEX hierarchy.
Learn to create an Oracle APEX calendar page from a table or SQL query with start and end dates. Enable drag‑and‑drop and CSS classes to reflect status, and reuse forms.
Learn how to view and run the advisor in Oracle Apex from application utilities or page designer, perform checks, and interpret warnings across your app for security and quality.
Learn how to create an Apex workspace in Autonomous DB, navigate manage workspaces, set up a new workspace with a database username and password, and launch a Hello World app.
Learn how breadcrumbs guide users in oracle apex, then create them automatically with the page wizard or manually via shared components or page designer, including parent entities and multiple levels.
Load data into Oracle APEX tables using the data loader wizard, supporting CSV, XLS, XML, and JSON formats with source-to-target mapping, error handling, and append, merge, or replace options.
Explore the Apex data parser API to load csv, xml, json, and xls/x data from blob content, discover file profiles, and parse dynamic columns for temp table loading.
Master dynamic action functionality in Oracle APEX by applying client-side validations, enabling and disabling elements, hiding and showing regions, and setting values with PL/SQL.
Explore sending emails in Oracle APEX using the apex_mail.send API or the send email process, including from address, to address, cc, subject, body, HTML content, and attachments.
Learn how to implement file upload and download in Oracle APEX, using blob columns, mime types, display image and download blob in classic reports, and file browse upload.
Learn how to use navigation list, navigation menu, and navigation bar in Oracle APEX, configure them under application shared components, and create and organize entries for custom pages.
Learn to enable and implement the feedback feature in Oracle APEX, create a feedback page, configure navigation and administration preferences, view user responses, and remove the feature when needed.
Learn to implement Oracle APEX print reports with generic and named column layouts, define report queries, and generate pdf attachments, including templates designed with the by publisher plugin.
Learn to create a wizard page in Oracle APEX, building a multi-step, interactive flow with steps, navigation, and content regions like interactive grids and forms.
Explore how the SIS.HTTP.P package enables dynamic HTML generation in Oracle APEX using PL/SQL, generating tables, text areas, inputs, and other HTML content at runtime.
Create files from sql queries in Oracle APEX using the Apex data export package to generate csv and zip outputs, including blob handling and download steps.
Learn to run long-running PL/SQL in Oracle APEX using an execution chain with run in background, and monitor status via process history and execution IDs.
Learn how to upload files to OCI object storage from Oracle APEX. List buckets and objects, configure OCI credentials, and use REST data sources and PL/SQL APIs for uploading.
Configure a Cohere LLM in Oracle APEX via workspace utilities, then create apps and SQL queries using JNI and the generative AI assistant to generate and refine pages.
Explore how to show an ai assistant and generate text with generative ai in oracle apex, configuring ai services and wiring inputs, outputs, and dynamic actions.
Oracle APEX (Application Express) is a powerful low-code development platform designed for rapid application development. The online training courses available for APEX cater to a wide range of skill levels, from beginners to experienced developers. These courses focus on key areas such as application building, SQL and PL/SQL integration, and user interface design.
Key Topics Include:
Introduction to Oracle APEX: Overview of its architecture, features, and benefits.
Setting Up the APEX Environment: Installation and configuration of Oracle APEX and related components.
Application Development: Creating user-friendly web applications using APEX components, including forms, reports, and dashboards.
Data Management: Understanding how to manage and manipulate data using SQL and PL/SQL within APEX.
User Interface Design: Employing templates, themes, and custom styles to enhance application usability and aesthetics.
Security Best Practices: Implementing security measures to protect applications and sensitive data.
Deployment and Maintenance: Strategies for deploying applications and performing routine maintenance tasks.
Learning Outcomes: By the end of this course, participants will be able to:
Develop and deploy web applications using Oracle APEX.
Utilize SQL and PL/SQL within APEX applications.
Implement security best practices to safeguard applications.
Design intuitive user interfaces that enhance user experience.
Target Audience: This course is intended for software developers, database administrators, and IT professionals who are looking to leverage Oracle APEX for rapid application development.