Oracle APEX 4.2 Online Training Course Contents +91 - 9246 333 245
·
Introduction to
Oracle Application Express
o
What is Oracle
Application Express?
o
Oracle Application
Express Architecture
o
Understanding Oracle
Application Express Roles
o
Logging into Oracle
Application Express
·
Demonstration
Application
o
Creating and logging
onto workspace
o
Installing
demonstration application
o
Running demonstration
application
·
Application Builder
Concepts
o
Page processing and
Rendering
o
Session Management
o
Substitution strings
& URL syntax
·
Using SQL Workshop
o
Using Object Browser
to view, create, edit, drop database objects
o
Using SQL Commands to
interact with database
o
Using SQL Scripts to
create, edit, delete and run SQL & PL/SQL scripts
o
Using Query Builder
to build queries graphically
·
Building an
Application
o
Creating an
application from wizard
o
Creating an
application From Scratch
o
Creating an
application From Spreadsheet
·
Understanding Pages
and Regions
o
What is a Page in
APEX
o
Controls on a Page
o
Different Sections of
a Page
o
Page Rendering
o
Page Processing
o
Shared Components
o
Attributes of a Page
o
What is a Region
o
Different Attributes
of a Region
·
Creating Interactive Reports
o
Creating Interactive
Reports
o
Interactive Report
Attributes
o
Interactive Report
Column Attributes
·
Creating SQL Reports
o
Creating SQL Reports
o
SQL Report Attributes
o
SQL Report Column
Attributes
·
Creating Forms
o
Creating Forms with
Report
o
Creating Simple Forms
o
Creating Tabular
Forms
o
Creating
Master-Detail Forms
o
Creating Forms Using
Wizards and Manually
o
Understanding Page
Rendering & Page Processing Components Required for Form
·
Working with Items
& Buttons
o
Creating Different
Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
o
Creating Buttons
o
Understanding Buttons
o
Navigation
o
Creating Tabs, Lists,
Breadcrumbs, Navigation Bar, List of Values
·
Shared Components
o
Understanding
Different Attributes of Shared Components
o
Using Shared
Components in Pages
·
Page Processing
o
Having a Thorough
Understanding of Following Sections of Page Rendering & Processing
o
Computations
o
Validations
o
Processes
o
Branches
·
Themes &
Templates
o
Understanding Themes
o
Switching Themes
o
Changing Theme
Defaults
o
Understanding Templates
and viewing template definitions
·
Security
o
Managing Application
Security
o
Understanding
Different Authentication Options in APEX
o
Creating a Custom
Authentication
o
Switching from One
Authentication Method to Another
o
Understanding
Authorization in APEX
o
Creating
Authorization Schemes
o
Attaching
Authorization Schemes to Pages, Regions, Tabs etc.
·
Packaging &
Deploying Application
o
Understanding
Different Deployment Options
o
Understanding the
Packaging & Deployment Process
o
Packaging Application
with Supporting Objects
o
Deploying Application
from One Environment to Another
