Search
START TYPING AND PRESS ENTER TO SEARCH

    Have a Question About This Course?





    Image

    Advanced Oracle Application Express

    Database Development - 5 Days
    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.

    Advanced Oracle Application Express 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.

    Need Assistance Finding the Right Training Solution

    Our Consultants are here to assist you
    Arrange a consultation

    Key Point of Training Programs

    We have different work process to go step by step for complete our working process in effective way.
    • Advanced Oracle Application Express Prerequisites

      Required Prerequisites
      SQL
      PL/SQL
      Experience with APEX
      Useful Prerequisites
      HTML
      CSS
      JavaScript
      jQuery

    • Advanced Oracle Application Express Format

      In-Person

      Online

    • Advanced Oracle Application Express Outline

      Understanding Session State
      What is Session State?
      Persisted vs. In-Memory Session State
      Session State Illustrated
      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)
      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)
      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)
      Charts
      Chart Types
      Creating a Page with a Bar Chart (Exercise)
      Dynamically Changing Chart Settings (Exercise)
      Creating a Pie Chart (Exercise)
      Interactive Grids
      Improving the Data Load Wizard (Exercise)
      Data Load Wizard: Adding the Interactive Grid (Exercise)
      Data Load Wizard: Saving the Grid (Exercise)
      Themes and Templates
      Themes and Templates
      Creating a New Theme (Exercise)
      Best Practice: Create Templates for Applications
      Build a Plug-in
      Overview of APEX Plug-ins
      Creating and Using a Plug-in (Exercise)
      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)
      Working with Files
      Working With Files in APEX
      Adding a Profile Picture (Exercise)
      Using CSS Files in APEX (Exercise)
      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)
      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)
      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)
      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)