Oracle Application Express
I offer one of the most exhaustive training programs on Oracle Application Express. This training program consists of following three training modules. Click on the links below to review the topics covered in each module.
- Developing Application with Oracle Application Express
- Advanced Oracle Application Express
- Administering Oracle Application Express
Other than this, if you have any customized training requirement on Oracle Application Express, please contact me to discuss further.
Course Contents – Developing Applications with Oracle Application Express
- Introduction to Oracle Application Express
- What is APEX ?
- Apex Architecture
- Key Features of APEX
- Usage of APEX
- Benefits of APEX
- Getting Started with Oracle Application Express
- Creating Workspace & Users
- Logging on to Workspace
- Running & Exploring Sample Application
- Working with SQL Workshop
- Using Object Browser to view, create, edit, drop database objects
- Using SQL Commands to interact with database
- Using SQL Scripts to create, edit, delete and run SQL & PL/SQL scripts
- Using Query Builder to build queries graphically
- Building Application in Application Express
- Building Application From Scratch
- Building Application From Spreadsheet
- Understanding Behind-The-Scene Activities
- Understanding Application Builder
- Application Builder Defaults
- Developer’s Preferences
- User Interface Defaults
- Application Groups
- Workspace Themes
- Managing export repository
- Understanding Pages and Regions
- What is a Page in APEX
- Controls on a Page
- Different Sections of a Page
- Page Rendering
- Page Processing
- Shared Components
- Attributes of a Page
- What is a Region
- Different Attributes of a Region
- Creating Interactive Reports
- Creating Interactive Reports
- Interactive Report Attributes
- Interactive Report Column Attributes
- Creating SQL Reports
- Creating SQL Reports
- SQL Report Attributes
- SQL Report Column Attributes
Creating Forms
- Creating Forms with Report
- Creating Simple Forms
- Creating Tabular Forms
- Creating Master-Detail Forms
- Creating Forms Using Wizards and Manually
- Understanding Page Rendering & Page Processing Components Required for Form
- Working with Items & Buttons
- Creating Different Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
- Creating Buttons
- Understanding Different Attributes of an Item and Button to Control its Look & Feel, Positioning and Functionality
- Working with Shared Components
- Uploading & Using Images in an APEX Application
- Creating Tabs, Lists, Breadcrumbs, Navigation Bar, List of Values, Trees
- Understanding Different Attributes of Shared Components
- Using Shared Components in Pages
- Understanding & Using Build Options
- Understanding & Using Shortcuts
- Using Application Items, Application Computations & Application Processes
- Having a Thorough Understanding of Following Sections of Page Rendering & Processing
- Computations
- Validations
- Processes
- Branches
- Creating Calendars
- Easy Calendar
- SQL Calendar
- Understanding Different Attributes of a Calendar
- Creating Charts
- Understanding Different Types of Charts
- Creating Charts
- Understanding Different Attributes of a Chart
- Miscellaneous
- Understand & Use Page Zero
- Understanding Different Options on Developer’s Toolbar
- Understanding Session State Management
- Understanding Sessions & Session IDs
- Referencing Session States in the Application
- Tools, Tips & Tricks for Debugging & Troubleshooting
- Maintaining an APEX Application
- Understand the URL of an APEX Application its different components
- Changing Home Page of an APEX Application
- Using Logos
- Using Substitution Strings
- Taking an application down for upgrade or maintenance
- Preventing direct modifications to an application in production environment
- Security
- Understanding Authorization in APEX
- Creating & Using Authorization Schemes
- Packaging & Deploying Application
- Understanding Different Deployment Options
- Understanding the Packaging & Deployment Process
- Packaging Application with Supporting Objects
- Deploying Application from One Environment to Another
Course Contents – Advanced Oracle Application Express
- Adding Features to Your Application
- Upload and Download Files
- Send E-Mail Notifications
- Incorporate SOAP & REST Web Services
- Incorporate JavaScript, AJAX & Dynamic Actions
- Incorporate JavaScript in APEX Application
- Incorporate AJAX in APEX Application
- Using Dynamic Actions
- Using Plug-Ins
- Creating Plug-Ins
- Exporting / Importing Plug-Ins
- Using Plug-Ins in application
- Reporting & Printing in APEX
- Configuring Print Server in Oracle Application Express
- Using Oracle BI Publisher as a Print Server
- Enable Printing for Interactive Report & SQL Report
- Customize Page Header, Footer & Appearance of Interactive Report & SQL Report
- Create a Simple PDF Report
- Create Master Detail PDF Report
- Create a PDF Report with Multiple Queries
- Send Report as an E-mail Attachment
- Create Drill Down Reports & Charts
- Customizing Themes, Templates & CSS
- Understanding Themes
- Switching Themes
- Changing Theme Defaults
- Understand Templates in APEX
- Understand CSS in APEX
- How to incorporate your own look and feel by customizing themes, templates & CSS
- Using Advanced Programming Features
- Creating Tabular Forms Manually
- Understanding & Using Collections
- Advanced Security
- Understanding Different Authentication Options in APEX
- Creating a Custom Authentication
- Switching from One Authentication Method to Another
- Building Access Control Page
- Using Session State Protection
- Globalization
- Setup & Access APEX Development Environment in Different Languages
- Translating an APEX Application in different languages
- Websheets
- What are websheets and its advantages
- Creating websheets
- Websheet wizard
- Managing websheet objects
- Websheet annotations
- Websheet authentication
- Websheet data grids
- Websheet pages
Course Contents – Administering Oracle Application Express
- Installing Oracle Application Express
- Installing Oracle Application Express
- Upgrading Oracle Application Express to the latest version
- Configuring Oracle Application Express with embedded PL/SQL Gateway
- Configuring Oracle APEX with HTTP Server
- Installing APEX in Multiple Languages
- Installing APEX in runtime mode
- Workspaces in APEX
- Concepts of Workspace in APEX
- Creating/Editing/ Deleting Workspaces
- Managing Workspace Schema Assignments
- Creating/Editing/Removing Workspace Administrators/Developers/Users
- Export / Import Workspace
- Managing Build Status of Applications
- Oracle APEX Administration Services
- Configuring SQL Workshop Options
- Configure Print Server
- Review mail log files
- Adding Themes to Repository
- Using SQL Developer to administer APEX
- Configure Security Options
- Specify workspace password policy
- Configure IP Filtering
- Restrict domain access from URL
- Enable / Disable logins to APEX Workspace
- Configure E-Mail in Oracle APEX
- Configure SMTP Server on Linux
- Configure SMTP Server with Oracle Application Express
- Oracle APEX Workspace Administration
- Load/Unload Data from tables
- Create DDL
- APEX Views
- Compare Schema
- Using APIs to manage APEX
- APEX_UTIL
- APEX_INSTANCE_ADMIN
- APEX_UI_DEFAULT_UPDATE
- APEX_CUSTOM_AUTH
- Administrative Reports & Monitoring
- Monitor Developer’s Activity
- Monitor Users Activity
- Monitor Application Changes
- Monitor Workspace Activity
- Monitor Application & Workspace Logons