Oracle APEX 23 is a powerful platform for developing responsive, data-driven web applications. This course equips you with the essential knowledge and skills to create, manage and deploy applications within the APEX environment.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
6ea3313f-d77e-4711-9804-c036eca5b567
Oracle Application Express 23 (APEX)
Select your learning method
Learn essential skills
Course overview
Develop and deploy secure Oracle APEX apps
Learn how to use Oracle APEX 23 to create impressive web apps that are fast, secure and easy to maintain. Guided by our experienced trainers, you’ll understand how to transform database concepts into fully functional web applications with minimal coding.
Learning objectives
- Set up and build your first APEX app
- Use Page Designer
- Build reports, cards and grids
- Create forms for users
- Apply templates and styles
- Add dynamic actions
- Build navigation with menus, breadcrumbs and shortcuts
- Build in authentication and access rules
- Package and deploy your app
What you’ll learn
Build your confidence using Oracle APEX 23. This course will teach you how to build web applications, customise interfaces, add logic and security, and deploy your new app. You’ll also gain practical experience using the APEX development environment to manage database objects and application components effectively.
Mastering the SQL Workshop
Work seamlessly with your Oracle database through a web interface using SQL Workshop. Gain practical experience modifying database objects, creating and running queries, and managing scripts. By the end of the course, you’ll be able to perform essential database tasks efficiently without the need for external tools.
Working with the Object Browser
Learn how to use the Object Browser to create, modify and manage database objects such as tables, views, sequences and indexes, all within the APEX environment. Develop the skills to navigate and update these objects efficiently, making it easier to maintain database structures and ensure your applications remain accurate and up-to-date.
Build and customise shared components
Discover how to use shared components such as lists of values (LOVs), menus, shortcuts, and breadcrumbs to give your app a consistent and scalable structure. You’ll create dynamic and static LOVs, design cascading value lists, and convert local items to shared components, allowing you to save time by reusing functionality across pages.
Exploring sample applications and templates
Use APEX’s built-in gallery of sample applications to learn how to install and adapt them. Reuse their regions and layouts to understand how real-world applications are structured. You’ll also work with APEX themes and templates, including creating custom styles, to ensure your applications align with design requirements.
What’s included
- 4 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Ideal for
Web developers, IT teams, Oracle professionals, and anyone wanting to create web apps using a low-code platform.
Prerequisites
You should have first completed our Oracle SQL or Oracle PL/SQL course, or have an equivalent working knowledge.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Develop the skills to build interactive, data-driven web applications. Explore key features including SQL Workshop, form and report creation, dynamic actions, security controls, and application development.
Can I use APEX 23 to replace spreadsheets or manual workflows?
APEX 23 can transform spreadsheet-based or manual processes into secure, easy-to-manage web applications. You will learn how to import data, create forms and reports, and design solutions that streamline tasks while improving data security and accessibility.
How does APEX compare to Oracle Visual Builder?
While both are low-code tools, APEX is built directly into the Oracle database and is generally quicker to set up and simpler to manage. This course shows you how to use APEX’s built-in tools to create full apps without needing a separate development stack.
What kind of applications can I build with APEX?
APEX can be used to develop a wide variety of applications, including internal tools, administrative dashboards, public-facing websites and lightweight portals. This course focuses on providing the core skills needed to build secure, responsive and user-friendly applications that can be deployed immediately.
What new features are introduced in Oracle APEX 23?
Oracle APEX 23 introduces several enhancements, including template components for building reusable interface elements, support for Progressive Web App (PWA) push notifications, improved background process monitoring and execution chains, and a more streamlined developer interface. These updates make it faster and more flexible to design and manage applications.
What our customers say
“Always good courses from ILX. Tutor explained the course very well.”
Paul, Development Analyst, Application Support – Transport
“The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout. I would definitely consider returning for future sessions and highly recommend ILX to my colleagues.”
Kamila, Data Administrator - Retail / Hire
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our training
5,000+ businesses
A trusted partner to thousands of organisations worldwide
96% customer satisfaction
Our passionate team goes above and beyond to support customer needs
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!