Advanced Oracle Application Express

Advanced Oracle Application Express Courseware (APEX201)

Oracle

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.

Publisher: Webucator

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.

PowerPoint Presentation

This course includes a PowerPoint presentation that maps to the manual and to the labs:

Full Lab Environment Add-On

Enhance and simplify your classes by providing an unparalleled learning platform that requires no setup. Your trainers and students can dive straight into a fully-prepared lab environment with just a click. This seamless integration means no time wasted on installations or configurations, allowing trainers and students to focus solely on the task at hand. The lab comes pre-loaded with all the necessary tools and resources, ensuring a smooth, hassle-free learning experience.

Skillable Lab

Outline

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

Required Prerequisites

  • SQL
  • PL/SQL
  • Experience with APEX

Useful Prerequisites

  • HTML
  • CSS
  • JavaScript
  • jQuery
License

Length: 5 days | $250.00 per copy
Labs: Add-on available | $74.33 per lab
View Lab Details

LicenseRequest More InformationDownload Sample Copy
What is Included?
  • Student Manual
  • Student Class Files
  • PowerPoint Presentation
  • Labs (optional add-on)
    Courseware Tracks

    This course is included in the following tracks: