Oracle APEX Intro training course

Introducing Application Express

• What is Application Express(APEX)?
• Benefits of APEX
• History of APEX
• Architecture Overview – logical and physical
• APEX Repository Overview
• Out of the box development features
• SQL Developer and APEX
• Building integrated applications
• Integrating APEX & BI Publisher

Getting Started with Application Express

• What is a Workspace?
• Different types of APEX users
• Application Express Components
• What is a packaged application?
• Creating a workspace and a developer
• Install a packaged application

Working with the SQL Workshop

• What is SQL Workshop?
• Browsing, creating and modifying Objects
• Processing ad hoc SQL and PL/SQL statements
• Managing scripts
• Using Query Builder to build queries graphically

Creating an Application

• Components of an application
• Page Definition
• Application Builder Home Page
• An Application’s Home Page
• Creating an application from scratch

• Creating an application from a spreadsheet

 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 Reports (Part 1)

• Creating SQL Reports

• SQL Report Attributes

• SQL Report Column Attributes

Creating Reports (Part 2)

• Creating Interactive Reports

• Interactive Report Attributes

• Interactive 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 a 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

• Creating Tabs, Lists, Breadcrumbs, Navigation Bar, List of Values
• Understanding Different Attributes of Shared Components
• Using Shared Components in Pages

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

Page Zero, Themes & Templates

• What is Page Zero
• Creating Page Zero
• Understanding Themes
• Switching Themes
• Changing Theme Defaults
• Understanding Templates and viewing template definitions

Developer's Toolbar, Session State, Debugging & Troubleshooting

• Understanding Different Options on Developer's Toolbar
• Understanding Session State Management
• Understanding Sessions & Session IDs
• Referencing Session States in the Application Security
• 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.

Packaging & Deploying Application

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