Course Outline for Oracle APEX Web App Development.

Course Outline for Oracle APEX Web App Development.

Oracle Application Express is the low code web application development tool for the Oracle database. It enables delegates or users to design, develop, and deploy, responsive, the database-driven application either in cloud or on-premises. This course is designed to provide knowledge of how to build web-based applications for an Oracle database and websheets for managing structured and unstructured data.

This course teaches delegates how to develop an Apex web application, create reports, create interactive grids, and create forms. They will also gain an understanding of how to use a page designer to manage web pages and regions in the apex application. Delegates will acquire knowledge of how to use cascading style sheets and JavaScript in Apex applications.

They will also learn how to add graphs and charts to an apex application. This course teaches delegates how to add dynamic actions to the Apex application, add page processes to the Apex application, and manage database objects from within Apex. They will also acquire knowledge of how to build queries of database objects and deploy an Apex application as a packaged application.

This 3-day course explains how to manage apex users and groups, load and unload data, deploy an Apex application, develop an Apex websheet and create data grids and links in an Apex websheet.

This course has been updated with RESTful API integration which is the heart of all modern web development.

Prerequisites:

• Ability to use the internet.
• Familiarity with either Windows, Mac or Linux systems.
• Understanding of file systems in the computer.

Module 1: Introduction to Oracle Application Express

• APEX Concepts
• APEX Main Components
• Workspaces, Database Applications and Web sheet Applications
• Creating a Workspace
• The Workspace Administrator
• Upgrading APEX
• Logging into APEX
• Running an Application

Module 2: SQL Workshop

• Use APEX to Browse, Create and Modify Objects
• Process Ad Hoc SQL Statements
• Manage Scripts in APEX
• Create, Run and Save SQL Queries

Module 3: Build a Database Application

• Application Components
• Create an Application
• Create an Application from a Spreadsheet

Module 4: Create Reports

• Creating Interactive Grids
• Create Reports Using Wizards
• Edit Report Attributes in Page Designer
• Add Links to Reports
• Create a Link to a Printer-Friendly version of a Report
• Save and Print Reports in Different Formats

Module 5: Using Files

• Uploading Images
• Creating Cascading Stylesheet Files
• Uploading Static Files
• Adding an Image as an Application Logo
• Adding a Reference to a Java Script File

Module 6: Pages and Regions

• View Page Attributes in Page Designer
• Edit Page Attributes in Page Designer
• Create a Global Page
• Create a New Region
• View Region Attributes
• Add Comments
• Add a Title and a Logo

Module 7: Create Forms

• Web Form Behaviour in APEX
• Create a Form-Based on a Table
• Create a Form-Based on a Procedure
• Create a Form with a Report
• Create a Tabular Form
• Create an Editable Interactive Grid
• Format a Form
• Locking in APEX Forms

Module 8: Creating Lists of Values

• Overview of Application Express Shared Components
• Dynamic and Static Lists of Values
• Create a Dynamic List of Values
• Create a Static List of Values
• Use a List of Values to Control Data in a Report
• Create a Cascading List of Values

Module 9: Items and Buttons

• Understand the Different Types of Items
• Create Page Items
• Create Application Items
• Understand and Edit Item Attributes in Page Designer
• Use Java Script with Item
• Create and Edit Buttons

Module 10: Page Processing

• Page Rendering and Page Processing
• Create Computations
• Validate Input Data
• Process Data
• Understand Application Branching
• Create Conditional Branches

Module 11: Shared Components

• Overview of Application Express Navigation Components
• Manage the Navigation Menu
• Create Navigation Bar Entries
• Manage Breadcrumbs
• Create and Use Lists and List Items
• Creating and Using Shortcuts

Module 12: Display Dynamic Content

• Create Hierarchical Trees
• Creating and Editing Charts
• Creating and Editing Calendars

Module 13: State and Debugging

• Understand Session State
• Set a Session State Value
• Clear the Session State
• Review the Session State
• Review the Messages in Debug Mode
• Enabling Feedback
• Managing Feedback and Team Development

Module 14: Themes and Templates

• Switch to a Different Theme
• View Existing Templates
• Understand and Manage Templates
• Create a new Template
• Add References to Cascading Stylesheet and JavaScript Files

Module 15: Dynamic Actions and Plug-In Components

• Identify Plug-in Components and their Types
• Plug in a Component
• Create Dynamic Actions
• Use a Plug-in in a Dynamic Action

Module 16: Building Websheet Applications

• Websheet Applications and their Components
• Create a Websheet Application
• Enable SQL and PL/SQL in a Websheet Application
• Add Sections and Pages to a Websheet Application
• Add Links on a Websheet Page
• Add a Data Grid to a Websheet Application
• Create SQL Reports ion Websheet Applications
• Add Annotations to a Websheet Application

Module 17: Implementing Security

• Authentication and Authorisation
• Provide an Authentication Scheme
• Create an Authorisation Scheme Using Access Control
• Enable and Configure Session State Protection

Module 18: Deploy an Application

• Define Supporting Objects
• Package an Application
• Export and Import an Application
• Install Supporting Objects

Module 19: ORDS

• ORDS
• Templates
• Parameters
• Handlers

Module 20: Security

• OAUTH 2.0
• OAUTH PL/SQL
• Roles and access control
• ACL / SSL / SASL

Module 21: RESTful API

• Concepts
• Structure
• JSON
• Postman