Oracle Application Express Level 1

Duration: 
3 days
Codes: 
QAORAPEX1
Versions: 
1

Overview

This level 1 course is for anyone who wants to learn the basics of Application Express (APEX)

Skills Gained

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
  • How to access APEX
  • Application Express Components
  • What is an Application?
  • What is 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 the Utilities

Creating a Database Application

  • Types of Application
  • Components of an application
  • Application Builder Home Page
  • An Application's Home Page
  • Page Definition
  • Creating an application from scratch
  • Creating an application from a spreadsheet

Creating Forms

  • Different Types of Forms
  • Creating Forms based on a Table or a View
  • Running the Page and the Developer Toolbar
  • Creating Tabular Forms
  • Creating Master-Detail Forms

Creating Reports

  • Types of Reports
  • Creating Wizard Reports
  • Linking a Report to a Form
  • Creating SQL or Classic Reports
  • Creating Interactive Reports

Understanding Pages and Regions

  • What is a Page in APEX?
  • Different Sections of a Page
  • Page Rendering
  • Page Processing
  • Shared Components
  • Page Attributes
  • What is a Region?
  • Lists, Breadcrumbs and Calendar Regions
  • Positioning Regions

Working with Items & Buttons

  • Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
  • Types of Buttons
  • Creating a Report Filter
  • Types of Page Processing
  • Types of Computations
  • Types of Processes
  • Types of Validations
  • Types of Branches

Understanding Session State

  • Understanding Sessions
  • Session IDs and APEX URLs
  • What is Session State?
  • Viewing Session State
  • Referencing Session State in your Application
  • In-built Substitution Variables
  • f?p syntax example

Working with Shared Components

  • What is a Shared Component?
  • Types of Shared Components
  • What are List of Values (LOVs)?
  • Creating Cascading LOVs
  • Uploading and Referencing Images
  • Application Items, Computations and Processing
  • Creating Tabs

Themes and Templates

  • Understanding Themes
  • Switching Themes
  • Changing Theme Defaults
  • Understanding Templates in APEX
  • Understanding CSS in APEX
  • How to incorporate your own look and feel by customizing themes, templates & CSS

Oracle APEX Workspace Administration

  • Workspace Administration Topics
  • Manage Services
  • Manage Users and Groups
  • Monitor Activity
  • Dashboards
  • Workspace Utilization
  • Feedback Form
  • Team Development

APEX Security Features

  • Understanding the Security Options in APEX
  • Creating Custom Authentication
  • Understanding Authorization - Access Control Page
  • Session State Protection.

Packaging & Deploying Applications

  • Understanding Different Deployment Options
  • Exporting an Application
  • Including Supporting Objects
  • Importing and Installing an Application

Prerequisites

We recommend a basic knowledge of SQL and PL/SQL or attendance of the following courses prior to attending this course:

Course Outline

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
  • How to access APEX
  • Application Express Components
  • What is an Application?
  • What is 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 the Utilities

Creating a Database Application

  • Types of Application
  • Components of an application
  • Application Builder Home Page
  • An Application's Home Page
  • Page Definition
  • Creating an application from scratch
  • Creating an application from a spreadsheet

Creating Forms

  • Different Types of Forms
  • Creating Forms based on a Table or a View
  • Running the Page and the Developer Toolbar
  • Creating Tabular Forms
  • Creating Master-Detail Forms

Creating Reports

  • Types of Reports
  • Creating Wizard Reports
  • Linking a Report to a Form
  • Creating SQL or Classic Reports
  • Creating Interactive Reports

Understanding Pages and Regions

  • What is a Page in APEX?
  • Different Sections of a Page
  • Page Rendering
  • Page Processing
  • Shared Components
  • Page Attributes
  • What is a Region?
  • Lists, Breadcrumbs and Calendar Regions
  • Positioning Regions

Working with Items & Buttons

  • Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
  • Types of Buttons
  • Creating a Report Filter
  • Types of Page Processing
  • Types of Computations
  • Types of Processes
  • Types of Validations
  • Types of Branches

Understanding Session State

  • Understanding Sessions
  • Session IDs and APEX URLs
  • What is Session State?
  • Viewing Session State
  • Referencing Session State in your Application
  • In-built Substitution Variables
  • f?p syntax example

Working with Shared Components

  • What is a Shared Component?
  • Types of Shared Components
  • What are List of Values (LOVs)?
  • Creating Cascading LOVs
  • Uploading and Referencing Images
  • Application Items, Computations and Processing
  • Creating Tabs

Themes and Templates

  • Understanding Themes
  • Switching Themes
  • Changing Theme Defaults
  • Understanding Templates in APEX
  • Understanding CSS in APEX
  • How to incorporate your own look and feel by customizing themes, templates & CSS

Oracle APEX Workspace Administration

  • Workspace Administration Topics
  • Manage Services
  • Manage Users and Groups
  • Monitor Activity
  • Dashboards
  • Workspace Utilization
  • Feedback Form
  • Team Development

APEX Security Features

  • Understanding the Security Options in APEX
  • Creating Custom Authentication
  • Understanding Authorization - Access Control Page
  • Session State Protection.

Packaging & Deploying Applications

  • Understanding Different Deployment Options
  • Exporting an Application
  • Including Supporting Objects
  • Importing and Installing an Application

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London3 1597 £1597 2020-01-13
London London3 1597 £1597 2020-01-13