This course provides an introduction to Oracle APEX 23 and its latest features. Learn how to confidently develop, customise and deploy fully functional web applications that integrate with your Oracle database.
Oracle Application Express 23 (APEX)
Build powerful web apps using Oracle APEX 23
Discover how to build secure, interactive, database-driven web apps using Oracle APEX 23. Through our live labs, you’ll get hands-on experience using the tools and features that make APEX a powerful platform for developers.
Learning objectives
- Build complete web apps
- Use the APEX page designer
- Create reports and interactive grids
- Add forms and user inputs
- Customise layouts and templates
- Work with shared components
- Add charts and dynamic content
- Manage users and control access
- Deploy apps safely and easily
What you’ll learn
This course offers practical, immersive training to help you develop modern, secure, data-driven applications using Oracle Application Express 23. Develop an advanced knowledge, exploring real-world features and workflows used by professional developers.
Building APEX applications
Learn how to create a complete APEX application, starting with a basic structure and enhancing the design using forms, pages, menus, and shared components. You’ll use Page Designer to add and arrange content, then style your app using themes, templates and branding options. We’ll also show you how to work with database objects, manage app logic, and use shared features to save time and maintain consistency.
Add dynamic and interactive elements
Discover how to create reports, cards, grids and forms that not only display data but also respond to user actions. Learn how to set up editable grids, use lists of values (LOVs), add dynamic actions, and process background logic. The course also places a strong emphasis on building interactive functionality, including data validation, conditional logic, and application branching.
Customise your app
You’ll work with new template components in APEX 23 and create flexible layouts using loops and conditionals. We’ll also cover how to enhance your app with CSS and JavaScript, and add elements such as avatars, media lists and charts to improve the user experience.
Implementing security
Protect your Oracle APEX applications by applying robust security measures. You’ll learn how to configure authentication and authorisation schemes, safeguard session data, and control user access effectively. The course also covers techniques for preventing unauthorised actions and maintaining data integrity, ensuring your applications remain secure.
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
Developers, Oracle Forms users, technical teams, and others who want to build web-based apps with limited coding knowledge.
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
This course covers everything you need to know to start building and launching applications with Oracle APEX 23. From data entry to security and deployment, it’s a full end-to-end guide for modern app development.
What is Oracle Application Express (APEX) 23?
Oracle Application Express (APEX) 23 is the latest version of Oracle’s low-code development platform for creating data-driven web applications. It enables developers to design, build and deploy secure, responsive applications that run in any modern web browser, all while integrating seamlessly with Oracle databases.
What are template components in APEX 23 and why are they useful?
Introduced in APEX 23, template components are reusable building blocks for application pages, such as cards, timelines, media lists and avatars. They can be placed wherever needed and support conditional display and looping, allowing content to be shown, hidden or repeated based on data. This makes it easier to create consistent, efficient layouts with reduced development effort.
Can I connect my app to existing Oracle database objects?
APEX integrates directly with your existing Oracle database, allowing you to build forms, reports and pages that use current tables, views or PL/SQL procedures without redevelopment. This enables you to create functional web applications from existing data and processes, making it particularly valuable for replacing spreadsheets or modernising legacy systems such as Oracle Forms.
How does the SQL Workshop in APEX help manage databases?
The SQL Workshop in APEX provides a browser-based interface for interacting with Oracle databases. It allows you to browse and edit database objects, run and save SQL queries, create and manage scripts, and review query results, making it easier to develop and maintain applications without requiring external database tools.
What our customers say
“This is now my second course with John at StayAhead and once again the delivery was simply excellent. I would very highly recommend the course to anyone who's taking on more PL/SQL work in their job. Hoping to come back for more in the future!”
Ashley, AppOps Engineer (Jr DBA) - Government
"John is an exceptional teacher. His teaching style, clarity, and support have made a lasting impact on my learning journey."
Mihai, Junior Developer - Outsourcing
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs