This course teaches you how to build fully functional, secure web apps using Oracle Application Express 21. Explore its enhanced development environment, intuitive design tools, and built-in features, gaining the skills to design, build and deploy professional, data-driven applications.
Oracle Application Express 21 (APEX)
Build impressive web applications with low-code tools
Over four days, you’ll gain practical experience with APEX — Oracle’s powerful, low-code platform for building data-driven web apps. Develop the technical expertise to design, secure and deploy professional solutions, boosting your confidence as a developer.
Learning objectives
- Use APEX SQL Workshop
- Create reports and interactive grids
- Build forms and dynamic pages
- Work with shared components
- Add charts, maps and images
- Apply security and authentication
- Use JavaScript and CSS
- Deploy and manage applications
What you’ll learn
Our expert trainers will teach you how to turn an Oracle database into a fully functional web application. You’ll learn to design pages, create interactive forms and reports, apply styling, configure user authentication, and deploy secure, professional solutions.
Working with SQL Workshop
Learn to use APEX’s built-in SQL Workshop to explore, manage and update your database directly from your browser. You’ll run and refine SQL queries, create and modify database objects, and organise scripts for future use, giving you the skills to manage data efficiently without leaving the development environment.
Creating reports and charts
Discover how to present your data clearly and interactively in Oracle APEX. You’ll create a range of report types, from interactive grids and faceted searches to cards and column toggle views. You’ll also build charts and visual dashboards, tailoring layouts and features so users can explore, filter, and understand information quickly and effectively.
Adding interactivity and dynamic features
Make your applications more engaging and responsive using dynamic actions and plug-ins. You’ll learn how to implement features that react instantly to user input, configure secure login and access controls, and apply session state protection. By combining interactivity with strong security, you’ll ensure your APEX applications deliver a smooth user experience while safeguarding sensitive data.
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, tech support teams, or others looking to build smart, data-driven web applications using Oracle APEX.
Prerequisites
You should first have completed our Oracle SQL or Oracle PL/SQL course, or have the 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 gives you the hands-on skills to build web apps using Oracle APEX 21. It’s ideal for developers who want an efficient, low-code way to build secure, data-driven applications.
What is Oracle Application Express (APEX)?
Oracle APEX is a low-code tool that lets you build fully functional web apps using just your browser and an Oracle database. It’s quick, powerful, and ideal for developers who want to build apps quickly and efficiently.
Will I learn how to secure my APEX applications?
The course covers APEX’s built-in security features, including authentication, authorisation schemes, and session state protection. You’ll learn how to configure secure logins, control access to specific areas, and protect data against unauthorised changes.
Can I customise my application with CSS and JavaScript in APEX?
You’ll discover how to apply custom styling with CSS, upload static files such as logos and spreadsheets, and use JavaScript to extend functionality, allowing you to match branding requirements and improve the user experience.
What types of projects can I create after completing the APEX 21 course?
After the course, you’ll be able to design and deploy professional, data-driven web applications. These could include dashboards, reporting tools, interactive forms, business process apps, and secure portals for internal and customer use.
What our customers say
"Stuart was a fantastic instructor. The contents of the course were really interesting and at no point did it feel like a chore. Pacing was in my opinion the most impressive aspect. I think it's really hard to get this exactly right, especially when there is a mix of previous exposure to what is being taught.”
Joseph, Systems Developer - Government
“John made the subject matter interesting. The pacing was spot on and he clearly knew what he was talking about and was able to communicate that easily. Very pleased and would highly recommend.”
Gavin - Government
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