The advanced APEX course is designed to deepen your students' understanding of Oracle APEX, focusing on advanced features and development techniques. It covers complex topics such as session state management, advanced security measures, and the intricacies of data loading and transformation. This course is structured around practical, hands-on exercises that challenge students to apply what they've learned in real-world scenarios, such as implementing custom authentication, navigating complex data relationships, and optimizing application security.

Key areas of focus include enhancing application usability through advanced navigation and interface design, utilizing APEX's powerful data visualization tools, and extending APEX functionality with themes, templates, and plug-ins. Students will also explore RESTful services, learning how to integrate external APIs and publish their own services to enhance application interactivity and functionality.

By participating in this course, your students will refine their skills in building sophisticated, secure, and highly interactive web applications with Oracle APEX. This not only complements their foundational knowledge but also prepares them for more challenging development roles. Offering this advanced course will not only expand your training offerings but also equip your students with advanced skills that are in demand, making them competitive in the job market and capable of tackling complex projects with Oracle APEX.

Benefits

• Deepens understanding of Oracle APEX's advanced features and development techniques.
• Focuses on real-world application through hands-on exercises and practical scenarios.
• Enhances skills in session state management, data loading, and transformation.
• Teaches advanced security measures, including custom authentication and prevention of SQL injection.
• Improves application usability with advanced navigation and interface design.
• Explores the power of APEX for data visualization with charts and interactive reports.
• Encourages creativity and customization through the use of themes, templates, and plug-ins.
• Integrates external APIs and publishes RESTful services to extend application functionality.
• Prepares students for challenging development roles by refining problem-solving skills.
• Increases competitiveness in the job market with in-demand skills in a powerful development platform.

What is Included?

• Student Manual
• Student Class Files
• PowerPoint Presentation
• Labs (optional add-on)

Outline

1. Understanding Session State

• What is Session State?
• Persisted vs. In-Memory Session State
• Session State Illustrated

2. Data Loading

• Creating Our Application (Exercise)
• Shared Components: Lists of Values (Exercise)
• The HR Schema: Employees
• Data Load Definition
• Creating the Data Load Definition (Exercise)
• Loading New Employees from a CSV (Exercise)
• Transforming Data on Import
• Error Handling Options
• Working with Collections
• The Invoke API Process
• Working with Packages
• Introduction to Wizards (Exercise)
• Creating a Data Load Wizard: The Data Load (Exercise)
• Creating a Data Load Wizard: The Package (Exercise)
• Creating a Data Load Wizard: The Template (Exercise)
• Creating a Data Load Wizard: File Upload Form (Exercise)
• Font Awesome and Universal Theme Color Classes
• Creating a Data Load Wizard: Data Validation (Exercise)
• Creating a Data Load Wizard: Data Loading (Exercise)

3. Advanced Security

• Custom Authentication and Authorization
• Allowing Employees to Log In (Exercise)
• Form Processing
• Change Password Page (Exercise)
• Setting Up Strong Password Validation (Exercise)
• Adding Password Validation (Exercise)
• Password Reset Strategies
• Forcing a Password Reset (Exercise)
• Checking Password Expiry on Every Page Load
• Implementing LDAP
• Using Virtual Private Database (VPD)
• Session State Protection
• Preventing SQL Injection
• Preventing Cross-Site Scripting (Exercise)
• Changing the ADMIN Password for the Internal Workspace
• Custom Authorization (Exercise)

4. Navigation

• Shared Components: Navigation and Search
• Add Page to Navigation Bar List (Exercise)
• The APEX_PAGE.GET_URL Function
• Creating and Understanding Dynamic Lists
• Navigating Department Employees (Exercise)
• Navigation Menu Settings
• Breadcrumbs and Drill Downs (Exercise)
• Breadcrumbs and Drill Downs: Continued (Exercise)

5. Charts

• Chart Types
• Creating a Page with a Bar Chart (Exercise)
• Dynamically Changing Chart Settings (Exercise)
• Creating a Pie Chart (Exercise)

6. Interactive Grids

• Improving the Data Load Wizard (Exercise)
• Data Load Wizard: Adding the Interactive Grid (Exercise)
• Data Load Wizard: Saving the Grid (Exercise)

7. Themes and Templates

• Themes and Templates
• Creating a New Theme (Exercise)
• Best Practice: Create Templates for Applications

8. Build a Plug-in

• Overview of APEX Plug-ins
• Creating and Using a Plug-in (Exercise)

9. Advanced Dynamic Actions

• Dynamic Actions with True and False Actions
• Dynamic Actions that Execute Client-Side Code (Exercise)
• Dynamic Actions that Execute Server-Side Code (Exercise)
• Text with Autocomplete (Exercise)

10. Working with Files

• Working With Files in APEX
• Adding a Profile Picture (Exercise)
• Using CSS Files in APEX (Exercise)

11. APEX Office Print

• APEX Office Print Overview
• Configuring APEX for AOP (Exercise)
• AOP Template Tags
• The Template Files (Exercise)
• Creating Word and Excel Files (Exercise)

12. RESTful Services

• REST Data Sources
• Making API Requests
• HTTP Request Methods
• Publishing RESTful Services
• Creating a RESTful Data Service (Exercise)
• The emp_post_example Resource Template
• Creating a RESTful PUT Data Service (Exercise)
• Creating a REST Data Source (Exercise)
• Creating an Interactive Report from the REST Data Source (Exercise)

13. Application Change Management

• Working Copies
• Create a Working Copy (Exercise)
• Editing a Working Copy (Exercise)
• Comparing Working Copy to Main Application (Exercise)
• Merging Changes from Working Copy into Main Application (Exercise)
• Refreshing a Working Copy with Changes from Main (Exercise)

14. Troubleshooting and Debugging

• Best Practice: Logging and Debugging
• Enabling Debugging
• The apex_debug_messages View
• Writing Messages to the Debug Log
• Debugging PL/SQL with APEX_DEBUG (Exercise)
• Viewing Error Information (Exercise)

Required Prerequisites

• SQL
• PL/SQL
• Experience with APEX

Useful Prerequisites

• HTML
• CSS
• JavaScript
• jQuery

Miran Kirn