Oracle Apex Training

Curriculum:

Introduction To Oracle Application Express:

• What is Oracle Application Express (oracle apex)?
• Oracle apex Architecture
• Understanding Oracle apex Roles
• Logging into Oracle apex

Apex Demonstration Application:

• Creating and logging onto apex workspace
• Apex Installation and demonstration application
• Running Apex demonstration application

Apex Application Builder Concepts:

• Page processing and Rendering in Apex
• Apex Session Management
• Substitution strings & URL syntax in Apex

Using SQL Workshop In Apex:

• Using Object Browser to view in Apex
• Create, edit and drop database objects in Apex
• Using SQL Commands to interact with the database in Apex
• Using SQL Scripts to create, edit, Delete and run SQL & PL/SQL scripts in Apex
• Using Query Builder to build queries graphically

Building An Application In Oracle Apex:

• Creating an application from the wizard
• Creating an application From Scratch in Apex
• Creating an application From Spreadsheet in Apex

Understanding Pages And Regions In Apex:

• What is a Page in APEX
• Controls on an APEX Page
• Different Sections of an APEX Page
• Page Rendering
• Apex Page Processing
• Apex Shared Components
• Attributes of an Apex Page
• What is a Region
• Different Attributes of an Apex Region

Creating Interactive Reports In Apex:

• Creating Interactive Reports in Apex
• Interactive Apex Report Attributes
• Interactive Report Column Attributes in Apex

Creating SQL Reports In Apex:

• Creating SQL Reports
• Apex SQL Report Attributes
• Apex SQL Report Column Attributes

Creating Forms In Apex:

• Creating Forms with Report in Apex
• Creating Simple Forms in Apex
• Creating Tabular Forms in Apex
• Creating Master-Detail Forms in Apex
• Creating Forms in Apex Using Wizards 
• Manually Understanding Page Rendering & Page Processing Components Required for Form in Apex

Working With Items & Buttons In Oracle Apex:

• Creating Different Types of Items in Apex (Text, Text Area, Checkbox, Select List, Radio Group etc.)
• Creating Buttons in Apex
• Understanding Buttons in Apex
• Apex Navigation
• Creating Tabs, Lists and Breadcrumbs in Apex
• Apex Navigation Bar
• List of Values

Oracle Apex Shared Components:

• Understanding Different Attributes of Apex Shared Components
• Using Shared Components in Apex Pages

Page Processing In Apex:

• Having a Thorough Understanding of Following Sections of Page Rendering & Processing
• Computations in Apex
• Validations in Apex
• Processes and Branches in Apex

Themes & Templates In Apex:

• Understanding Themes in Apex
• Switching Themes
• Changing Theme Defaults
• Understanding Templates and viewing template definitions specific to Apex

Oracle Apex Security:

• Managing Application Security in APEX
• Understanding Different Authentication Options in APEX
• Creating a Custom Authentication
• Switching from One Authentication Method to Another
• Understanding Authorization in APEX
• Creating Authorization Schemes
• Attaching Authorization Schemes to Pages, Regions, Tabs etc. in APEX

Packaging & Deploying Application:

• Understanding Different Deployment Options in APEX
• Understanding the Packaging & Deployment Process
• Packaging Application with Supporting Objects in APEX
• Deploying Application from One Environment to Another