|
Provided by: Mercury Innovations-ApexDevelop Online Oracle Application Express training courseComputer |
![]() |
Training
Provided by Mercury Innovations-ApexDevelop
An excellent course for anyone who wants to develop, deploy and maintain web based applications.
Oracle Application Express developer's guide course describes how to use the Oracle Application Express development environment to build and deploy database-centric Web applications.
Related Software Programs or Products: Oracle Application Express
|
|
||||||||||
Online Oracle Application Express training course
Course Contents
* 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
* 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
About The Training Provider: Mercury Innovations-ApexDevelop
Mercury Innovations-ApexDevelop - ApexDevelop. com is dedicated to provide the best training solution, learning material, Apex related groups, blogs and forums for Oracle Application Express that help organizations achieve their business goals, such as increasing productivity, efficiency, increase revenue and help in reducing costs.
ApexDevelop. com provides customer-focused training course in Oracle Application Express,...

