We can host this training at your preferred location. Contact us!
Upcoming Training
18 April 2021
3 Days
This course is for developers who wish to gain a practical understanding of how to use Oracle Application Express (APEX).
Delegates should have some experience with SQL and PL/SQL.
Introducing Application Express
What is Application Express(APEX)
Benefits of APEX
History of APEX
Architecture Overview - logical and physical
APEX Repository Overview
Out of the box development features
SQL Developer and APEX
Getting Started with Application Express
What is a Workspace?
Different types of APEX users
How to access APEX
Application Express Components
What is an Application?
What is a Packaged Application?
Working with the SQL Workshop
What is SQL Workshop?
Browsing, creating and modifying objects
Processing ad hoc SQL and PL/SQL statements
Managing scripts
Using the Utilities
Creating a Database Application
Types of Application
Components of an application
Application Builder Home Page
An Application's Home Page
Creating an application
Creating an application from a file
Creating Forms
List the different types of application forms that you can create in Application Express
Creating single entry Forms
Creating Editable Interactive Grids
Creating Master-Detail Forms
Modifying a Form
Creating Reports
List the type of reports that you can create in Application Express
Describe the different ways of creating reports in Application Express
Create an interactive report
Create an interactive grid
Create a classic report
Create a report with form
Create a faceted search page
Linking a Form and a Report
Modifying a Report
Understanding Pages and Regions
What is a Page in APEX?
Different Sections of a Page
Page Rendering
Page Processing
Shared Components
Page Attributes
What is a Region?
Lists, Breadcrumbs and Calendar Regions
Positioning Regions
Working with Items and Buttons
Types of page level Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
Create and use page-level items
Create and use buttons
Creating a Report Filter
Adding Computations, Processes, and Validations
Explain page rendering and page processing
Create computations
Create page processes
Create validations
Create branches
Understanding Session State
Understanding Sessions
Session IDs and APEX URLs
What is Session State?
Viewing Session State
Referencing Session State in your Application
In-built Substitution Variables
Working with Shared Components
What is a Shared Component?
Types of Shared Components
What are List of Values (LOVs)?
Creating Cascading LOVs
Uploading and Referencing Images
Application Items, Computations and Processing
Editing the Navigation Menu
Using Themes and Theme Styles
Describe themes and templates
Explain the key features of Universal Theme
Create and use a new theme
Describe Universal Theme, Theme Styles, Theme Roller, and Template Options
Use Theme Styles
Use Theme Roller, and Live Template Options
Upload and use a CSS
Oracle APEX Workspace Administration
Workspace Administration Topics
Manage Services
Manage Users and Groups
Monitor Activity
Dashboards
Workspace Utilization
APEX Security Features
Explain how to secure your application
Describe authentication and authorization
Create and use an authentication scheme for your application
Create and attach an authorization scheme to your application, page, or components
Introduction to Dynamic Actions
What are Dynamic Actions?
Create and use dynamic actions
Creating and Using Plug-ins
Describe Plug-ins
Implement Plug-ins in your application
Displaying other Content
Oracle JET Charts
Calendars
Trees
Data Loading
Create a data upload form for users
Transform the data upon upload
Validate and reject rows
Migrating an Application between Environments
Describe the steps involved in migrating an application between environments
Export the application definition, underlying database objects, and data from your development environment
Import the application definition, underlying database objects, and data in the target development environment
Upcoming Trainings
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.