This course provides a complete, hands-on introduction to Oracle APEX 4.2.5, a premier rapid application development tool. It allows developers to efficiently create complex web-based applications to run on any operating system environment, including smart phones. Interactive reports can be created and customized by:
- Searching and sorting,
- Creating control break reports,
- Performing highlighting to focus on specific rows or values,
- Adding custom computations including aggregations,
- Charting and custom dashboards.
In this class, students will learn by building a fully functioning application from the ground up.
Audience: This course is appropriate for any database user wanting to explore rapid application development, including end users, business analysts, application developers, database administrators and IT management.
Course Duration: 5 days
Prerequisites:
Students attending this course should have completed our five-day Oracle 11g or 12c SQL course or have equivalent experience.
Course Outline:
- Introduction to APEX
- Overview of the Class
- History of APEX
- APEX Instance Options
- Tools
- Web Browser Selection
- SQL*Plus
- SQL Developer
- APEX Installation
- Removing the Old Version
- Installing the New Version
- APEX ADMIN Setup
- Configuring RESTful Services
- Configuring the Embedded PL/SQL Gateway
- Creating a Workspace
- The APEX Workspace
- Roles for APEX Users
- Anatomy of an Application
- Overview of APEX Modules
- Application Builder
- SQL Workshop Interface
- SQL Commands Interface
- SQL Scripts Interface
- Utilities Interface
- Team Development / Administration
- Our Real-World Problem
- Needed Database Objects
- Designing For APEX
- APEX And PLSQL
- The “Parse As” Schema
- Initial Object Design
- Needed Database Objects
- Tables
- Views
- Triggers
- Sequences
- Comments
- Generating Application Documentation
- Object Design II
- Loading Data
- Creating Lookup Tables
- Loading and Running Scripts
- User Interface Defaults
- Creating and Navigating Apps
- Using the Create Application Wizard
- Understanding Websheets
- Creating Applications from Spreadsheets
- Creating Applications from Scratch
- Regions
- Public Pages / Global Pages
- Navigation Bar Entries
- Breadcrumbs / Lists / LOVs
- Basic Forms and Reports
- Forms on Tables
- Forms on Procedures
- Master-Detail Forms and Reports
- Creating Searchable Reports
- Using Declarative BLOBs
- Advanced Forms and Reports
- Creating Tabular Forms
- Interactive Reports
- User Help for Interactive Reports
- Subscribing to Reports
- Creating Calendars
- Creating Charts
- Programmatic Components
- Using Conditions
- Using Required Values
- Using Validations
- Creating Computations
- Creating Processes
- Using PL/SQL Regions
- Using Dynamic SQL
- Dynamic Actions
- Understanding Dynamic Actions
- Implementing Dynamic Actions
- Using Multiple Triggering Elements
- Using PL/SQL
- Using JavaScript
- APEX Security
- Integrating User Security
- Creating Needed Database Objects
- Security Model Implementation
- Authentication
- Conditional Security
- Controlling Data Access
- Protecting Session State
- Websheets
- The Structure of a Websheet
- Navigating Websheets
- Websheet Help
- Markup Syntax
- Authenticating and Authorizing Users
- Sections in Websheets
- Using Annotations
- Creating a Websheet Application
- Creating the Database Objects
- Websheet Creation and Configuration
- Creating Websheet Content
- Bundling and Deployment
- Application Component Identification
- Including Supporting Objects
- Importing an Application
- Additional Developer Tools
- Understanding Page Locks
- Application Groups / Page Groups
- The APEX Data Dictionary
- Monitoring APEX Applications
- The APEX Advisor
- APEX Build Options
- Using Page-Specific Utilities
- Workspace Management
- The APEX Administration Interface
- Service Management
- Metadata Management
- User / Group Management
- Monitoring Activity and Dashboards
- APEX Team Development
- The Team Development Interface
- Features
- Milestones
- To-Do Items
- Bugs
- Feedback
- Team Actions
- Available User Roles
- Introduction to APEX
- Overview of the Class
- History of APEX
- APEX Instance Options
- Tools
- Web Browser Selection
- SQL*Plus
- SQL Developer
- APEX Installation
- Removing the Old Version
- Installing the New Version
- APEX ADMIN Setup
- Configuring RESTful Services
- Configuring the Embedded PL/SQL Gateway
- Creating a Workspace
- The APEX Workspace
- Roles for APEX Users
- Anatomy of an Application
- Overview of APEX Modules
- Application Builder
- SQL Workshop Interface
- SQL Commands Interface
- SQL Scripts Interface
- Utilities Interface
- Team Development / Administration
- Our Real-World Problem
- Needed Database Objects
- Designing For APEX
- APEX And PLSQL
- The “Parse As” Schema
- Initial Object Design
- Needed Database Objects
- Tables
- Views
- Triggers
- Sequences
- Comments
- Generating Application Documentation
- Object Design II
- Loading Data
- Creating Lookup Tables
- Loading and Running Scripts
- User Interface Defaults
- Creating and Navigating Apps
- Using the Create Application Wizard
- Understanding Websheets
- Creating Applications from Spreadsheets
- Creating Applications from Scratch
- Regions
- Public Pages / Global Pages
- Navigation Bar Entries
- Breadcrumbs / Lists / LOVs
- Basic Forms and Reports
- Forms on Tables
- Forms on Procedures
- Master-Detail Forms and Reports
- Creating Searchable Reports
- Using Declarative BLOBs
- Advanced Forms and Reports
- Creating Tabular Forms
- Interactive Reports
- User Help for Interactive Reports
- Subscribing to Reports
- Creating Calendars
- Creating Charts
- Programmatic Components
- Using Conditions
- Using Required Values
- Using Validations
- Creating Computations
- Creating Processes
- Using PL/SQL Regions
- Using Dynamic SQL
- Dynamic Actions
- Understanding Dynamic Actions
- Implementing Dynamic Actions
- Using Multiple Triggering Elements
- Using PL/SQL
- Using JavaScript
- APEX Security
- Integrating User Security
- Creating Needed Database Objects
- Security Model Implementation
- Authentication
- Conditional Security
- Controlling Data Access
- Protecting Session State
- Websheets
- The Structure of a Websheet
- Navigating Websheets
- Websheet Help
- Markup Syntax
- Authenticating and Authorizing Users
- Sections in Websheets
- Using Annotations
- Creating a Websheet Application
- Creating the Database Objects
- Websheet Creation and Configuration
- Creating Websheet Content
- Bundling and Deployment
- Application Component Identification
- Including Supporting Objects
- Importing an Application
- Additional Developer Tools
- Understanding Page Locks
- Application Groups / Page Groups
- The APEX Data Dictionary
- Monitoring APEX Applications
- The APEX Advisor
- APEX Build Options
- Using Page-Specific Utilities
- Workspace Management
- The APEX Administration Interface
- Service Management
- Metadata Management
- User / Group Management
- Monitoring Activity and Dashboards
- APEX Team Development
- The Team Development Interface
- Features
- Milestones
- To-Do Items
- Bugs
- Feedback
- Team Actions
- Available User Roles