
Oracle APEX https://apex.oracle.com/
What is Oracle APEX?
Oracle APEX is the world's most popular enterprise low-code application platform that enables you to build scalable, secure web and mobile apps, with world-class features, that can be deployed anywhere – cloud or on premises.
Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You don't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.
Source: Oracle APEX https://apex.oracle.com/
Log in to Oracle APEX, open your workspace, and install a sample application from the gallery. Explore the available charts, including the area chart.
Explore the oracle apex sql workshop to create, modify, view, and run database objects with object browser, sql command, sql scripts, and utilities, plus restful services via ords.
Navigate the Oracle APEX object browser to create category, subcategory, and product tables, define primary and foreign keys, and load data from Excel into each table.
Explore APEX pages as building blocks of Oracle APEX applications, covering normal and modal dialog modes, and learn how regions organize content and trigger a page via a login button.
Learn to build an Oracle APEX app by creating regions, adding images, and wiring a login model page using page designer, static files, and CSS customization.
Create the movie table by running the SQL script from the resources tab, then insert data with a script named movie data and verify 18 rows in the object browser.
Create an interactive grid in Oracle APEX with the page wizard and app builder, connect to a local table, enable editing for adding and deleting rows, then run the report.
Create two tables for this pre-lab: categories and food items, with fields for category name, image, and for food items: name, image, category ID, description, and price.
Learn to build two forms to add categories with images, save them to the database, and link pages, then manage categories by updating or deleting them in the admin panel.
Log into the oracle apex workspace, load an excel file into a table card_movie_table through sql workshop, insert 17 rows, drop the default key, and set id as primary key.
Build a cards-based Oracle APEX application by creating a movies page, applying advanced formatting, and linking poster images from a movie poster column stored as static files.
Learn how single sign-on enables access to three Oracle APEX apps (F1, F2, F3) with one login by configuring shared authentication, session sharing, and navigation links across the workspace.
Oracle APEX (Application Express) is the world’s leading enterprise low-code platform, enabling developers to build scalable, secure web and mobile apps rapidly—deployed in the cloud or on-premises.
Why Choose Oracle APEX?
Build Apps 20x Faster – Develop with 100x less code than traditional methods
No Complex Tech Stack Needed – Just basic SQL knowledge is enough to start
Enterprise-Ready – Scalable, secure, and production-ready applications
Cloud & On-Premises – Deploy anywhere with Oracle’s robust infrastructure
What Will You Learn in This Oracle APEX Course?
This 4-hour beginner-friendly course covers:
Creating an APEX Workspace
Building & Managing Database Objects (SQL Workshop)
Designing Reports, Forms, and Interactive Pages
Implementing Security (Authentication & Authorization)
Course Outline:
Introduction to Oracle APEX
What is Oracle APEX?
Workspace Setup
LAB: Install a Sample App
SQL Workshop
Object Browser, SQL Commands, Scripts
Hands-on LABs
Building Pages
Reports (Classic, Interactive, Faceted Search)
Forms & Cards
Step-by-step LABs
Security in APEX
Single Sign-On (SSO)
Social Sign-In
Authorization Controls
By the End of This Course, You Will:
Build Simple Apps from scratch
Master APEX Basics for advanced learning
Confidently Use SQL Workshop for database tasks
Ready to Start?
Enroll Now and build your first Oracle APEX app in just hours!
Ready to Start?
Enroll Now and build your first Oracle APEX app in just hours!