Description

Description

The Advanced Oracle APEX course is designed to elevate your students’ proficiency in APEX by focusing on advanced development techniques and features. It builds on foundational knowledge to explore more complex concepts such as session state management, robust security practices, and the nuances of data loading, transformation, and custom authentication workflows.

Structured around real-world, hands-on exercises, this course challenges students to apply their skills in practical scenarios—like securing applications, managing intricate data relationships, and enhancing performance. Each module is designed to reinforce critical thinking and problem-solving in a modern application development context.

Students will delve into advanced UI/UX techniques, improving application usability through sophisticated navigation, interface customization, and responsive design. They’ll also harness the full power of APEX’s data visualization tools and learn how to extend the platform using themes, templates, and plug-ins.

A key component of the course is working with RESTful Web Services. Students will learn how to consume external APIs, integrate third-party services, and publish their own RESTful endpoints to create more interactive and connected applications.

By completing this course, students will be equipped to build secure, scalable, and highly interactive applications that meet enterprise-grade standards. It enhances their readiness for more advanced development roles and makes them strong candidates for organizations seeking to maximize their investment in Oracle APEX.

Offering this course will expand your advanced training portfolio while giving your students a competitive edge in tackling complex projects and excelling in modern application development environments.

Training Objectives

• This course strengthens students’ expertise in Oracle APEX by exploring its advanced capabilities and development practices. It emphasizes practical hands-on learning through real-world scenarios that reinforce key concepts and skills.
• Students will advance their proficiency in session state management data loading and data transformation while gaining critical knowledge in application security including custom authentication strategies and SQL injection prevention.
• The course also focuses on enhancing user experience through advanced navigation techniques and refined interface design. Learners will unlock the full potential of APEX’s data visualization features creating impactful charts and interactive reports.
• To foster innovation the course encourages customization through themes templates and plug-ins allowing students to tailor applications to specific needs. Additionally they will learn how to integrate external APIs and publish RESTful services expanding application functionality and connectivity.
• By sharpening their problem-solving and development skills students will be well-prepared for advanced roles in application development. The course equips them with highly sought-after skills that boost their competitiveness in today’s job market and position them to excel in dynamic full-featured APEX environments.

Course Outline

• Understanding Session State<br />
• What is Session State?<br />
• Persisted vs. In-Memory Session State<br />
• Session State Illustrated<br />
• Data Loading<br />
• Creating Our Application (Exercise)<br />
• Shared Components: Lists of Values (Exercise)<br />
• The HR Schema: Employees<br />
• Data Load Definition<br />
• Creating the Data Load Definition (Exercise)<br />
• Loading New Employees from a CSV (Exercise)<br />
• Transforming Data on Import<br />
• Error Handling Options<br />
• Working with Collections<br />
• The Invoke API Process<br />
• Working with Packages<br />
• Introduction to Wizards (Exercise)<br />
• Creating a Data Load Wizard: The Data Load (Exercise)<br />
• Creating a Data Load Wizard: The Package (Exercise)<br />
• Creating a Data Load Wizard: The Template (Exercise)<br />
• Creating a Data Load Wizard: File Upload Form (Exercise)<br />
• Font Awesome and Universal Theme Color Classes<br />
• Creating a Data Load Wizard: Data Validation (Exercise)<br />
• Creating a Data Load Wizard: Data Loading (Exercise)<br />
• Advanced Security<br />
• Custom Authentication and Authorization<br />
• Allowing Employees to Log In (Exercise)<br />
• Form Processing<br />
• Change Password Page (Exercise)<br />
• Setting Up Strong Password Validation (Exercise)<br />
• Adding Password Validation (Exercise)<br />
• Password Reset Strategies<br />
• Forcing a Password Reset (Exercise)<br />
• Checking Password Expiry on Every Page Load<br />
• Implementing LDAP<br />
• Using Virtual Private Database (VPD)<br />
• Session State Protection<br />
• Preventing SQL Injection<br />
• Preventing Cross-Site Scripting (Exercise)<br />
• Changing the ADMIN Password for the Internal Workspace<br />
• Custom Authorization (Exercise)<br />
• Navigation<br />
• Shared Components: Navigation and Search<br />
• Add Page to Navigation Bar List (Exercise)<br />
• The APEX_PAGE.GET_URL Function<br />
• Creating and Understanding Dynamic Lists<br />
• Navigating Department Employees (Exercise)<br />
• Navigation Menu Settings<br />
• Breadcrumbs and Drill Downs (Exercise)<br />
• Breadcrumbs and Drill Downs: Continued (Exercise)<br />
• Charts<br />
• Chart Types<br />
• Creating a Page with a Bar Chart (Exercise)<br />
• Dynamically Changing Chart Settings (Exercise)<br />
• Creating a Pie Chart (Exercise)<br />
• Interactive Grids<br />
• Improving the Data Load Wizard (Exercise)<br />
• Data Load Wizard: Adding the Interactive Grid (Exercise)<br />
• Data Load Wizard: Saving the Grid (Exercise)<br />
• Themes and Templates<br />
• Themes and Templates<br />
• Creating a New Theme (Exercise)<br />
• Best Practice: Create Templates for Applications<br />
• Build a Plug-in<br />
• Overview of APEX Plug-ins<br />
• Creating and Using a Plug-in (Exercise)<br />
• Advanced Dynamic Actions<br />
• Dynamic Actions with True and False Actions<br />
• Dynamic Actions that Execute Client-Side Code (Exercise)<br />
• Dynamic Actions that Execute Server-Side Code (Exercise)<br />
• Text with Autocomplete (Exercise)<br />
• Working with Files<br />
• Working With Files in APEX<br />
• Adding a Profile Picture (Exercise)<br />
• Using CSS Files in APEX (Exercise)<br />
• APEX Office Print<br />
• APEX Office Print Overview<br />
• Configuring APEX for AOP (Exercise)<br />
• AOP Template Tags<br />
• The Template Files (Exercise)<br />
• Creating Word and Excel Files (Exercise)<br />
• RESTful Services<br />
• REST Data Sources<br />
• Making API Requests<br />
• HTTP Request Methods<br />
• Publishing RESTful Services<br />
• Creating a RESTful Data Service (Exercise)<br />
• The emp_post_example Resource Template<br />
• Creating a RESTful PUT Data Service (Exercise)<br />
• Creating a REST Data Source (Exercise)<br />
• Creating an Interactive Report from the REST Data Source (Exercise)<br />
• Application Change Management<br />
• Working Copies<br />
• Create a Working Copy (Exercise)<br />
• Editing a Working Copy (Exercise)<br />
• Comparing Working Copy to Main Application (Exercise)<br />
• Merging Changes from Working Copy into Main Application (Exercise)<br />
• Refreshing a Working Copy with Changes from Main (Exercise)<br />
• Troubleshooting and Debugging<br />
• Best Practice: Logging and Debugging<br />
• Enabling Debugging<br />
• The apex_debug_messages View<br />
• Writing Messages to the Debug Log<br />
• Debugging PL/SQL with APEX_DEBUG (Exercise)<br />
• Viewing Error Information (Exercise)