Designing Database-Driven Applications with Oracle APEX

This workshop introduces participants to the techniques and tools required to develop database driven web applications. The workshop teaches participants how to design, develop and deploy beautiful, responsive, database-driven web applications using Oracle Application Express. Oracle Application Express is utilized to provide practical, hands-on, engaging activities. Leveraging project-based learning techniques, participants will create and work with projects that challenge them to design, implement, and demonstrate a database-driven web application solution for a business or organization.

CONTENT

Introduction

• • • Course Overview
    • Getting Started with Oracle Application Express

Create a Basic Database Application

• • • Using SQL Workshop
    • Creating a Database Application

Pages, Reports, and Grids

• • • Managing Pages in Page Designer
    • Developing Reports
    • Managing and Customizing Interactive Reports
    • Managing and Customizing Interactive Grids

Forms and Page Controls

• • • Creating and Using Forms
    • Creating Application Page Controls
    • Adding Computations, Processes, and Validations

Navigation, Themes, and Security

• • • Implementing Navigation in your Application
    • Using Themes and Theme Styles
    • Implementing Security in your Application

Adding to and Migrating an Application

• • • Adding Additional Pages to your Application
    • Creating and Using Dynamic Actions and Plug-ins
    • Migrating Application Development between Environments

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.