Oracle Application Express 23 (APEX) - 4 days Online Classroom
3.450,00 EUR
- 4 days
Build modern, secure, and data-driven web applications with the Oracle Application Express 23 (APEX) course. This hands-on training teaches you how to develop responsive applications using Oracle's powerful low-code platform with minimal programming. You'll learn to create interactive reports, forms, dashboards, and navigation components, customise application themes, implement authentication and security, and deploy production-ready applications. Through practical labs, you'll gain the confidence to transform Oracle database objects into fully functional web applications quickly and efficiently
Key Features
Language
Course and materials are in English
Level
Intermediate level
4 days (8 hours / day) live classroom
with accredited trainers
50+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Create
Create and execute SQL queries, manage scripts, and modify database objects using browser-based tools, enabling you to perform everyday database administration and development tasks without requiring additional software.
Navigate
Develop the skills to create, edit, and maintain database objects. Efficiently navigate database structures, update objects, and keep your applications aligned with changing business and data requirements.
Discover
Discover how to build reusable application components. You'll create dynamic and cascading LOVs while learning how shared components can be reused across multiple pages to accelerate development and maintenance.
Customize
Customize built-in themes, templates, and layouts, adapt existing application components, and create user interfaces that deliver a consistent, professional experience.
Course timeline
Oracle APEX Fundamentals and Application Development
Day 1
- Understand Oracle APEX architecture, workspaces, applications, and the latest features introduced in Oracle APEX 23.
- Use SQL Workshop to create, edit, query, and manage database objects and SQL scripts through the APEX interface.
- Build new database applications from scratch, existing files, or working copies using APEX development tools.
- Create interactive reports, grids, cards, faceted search, and printer-friendly reports for effective data presentation.
- Manage application resources by uploading images, JavaScript files, CSS, and other static content.
- Design application pages and regions using Page Designer, including global pages, media regions, badges, avatars, and branding elements.
Forms, Navigation, and Application Logic
Day 2
- Build interactive forms based on tables or procedures, including editable grids and form customisation.
- Create dynamic, static, cascading, and shared Lists of Values (LOVs) to improve data entry and usability.
- Configure page items, application items, buttons, and JavaScript interactions to enhance user experience.
- Implement page processing with validations, computations, branching, background processes, and business logic.
- Manage shared components such as navigation menus, breadcrumbs, lists, shortcuts, and reusable application elements.
- Develop well-structured applications with consistent navigation and reusable functionality across multiple pages.
Dynamic Content, Debugging, and User Interface Design
Day 3
- Create dynamic visual components including charts, calendars, and hierarchical tree views.
- Manage session state, troubleshoot applications using Debug Mode, and review application feedback.
- Monitor and maintain application quality using built-in team development and feedback features.
- Apply and customise themes, templates, and theme styles to create consistent user interfaces.
- Integrate custom CSS and JavaScript to enhance application appearance and functionality.
- Build polished, responsive Oracle APEX applications with professional layouts and improved usability.
Advanced Features, Security, and Deployment
Day 4
- Create dynamic actions and extend application functionality using APEX plug-ins and template components.
- Configure authentication, authorization, and session state protection to secure applications.
- Package, export, import, and deploy Oracle APEX applications with supporting database objects.
- Learn best practices for moving applications between development, testing, and production environments.
- Explore Oracle APEX sample applications to understand practical development techniques and reusable designs.
- Apply deployment, security, and application management skills to deliver scalable, production-ready Oracle APEX solutions.
Who Should Enroll in this Program?
Oracle SQL and PL/SQL Developers
Web Application Developers
Database Developers
Oracle Database Administrators
Software Engineers building data-driven applications
IT professionals looking to develop applications using Oracle's low-code platform
Prerequisites
- Working knowledge of Oracle SQL
- Basic understanding of Oracle PL/SQL
- Experience equivalent to an Oracle SQL or Oracle PL/SQL course
- Familiarity with relational databases and database objects is recommended.
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.