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
