Course Code: apex51
Duration: 21 hours
Prerequisites:

None

Overview:

This instructor-led, live training (online or onsite) is aimed at providing the student with an overview of the existing version of the APEX platform used by the division.  The core elements of the features and functionality.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request customized training for this course, please contact us to arrange.
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
  • Building integrated applications

Getting Started with Application Express

  • What is a Workspace?
  • Different types of APEX users
  • How to access APEX
  • Application Express Components
  • Creating a workspace
  • 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 Designer
  • 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
  • Linking a Report to a Form
  • Creating SQL or Classic Reports
  • Creating Interactive Reports
  • Querying using Interactive Grids

Understanding Pages and Regions

  • Working with Pages
  • Overview of the Page Designer
  • Page Designer Toolbar
  • The Tree Pane
  • The Central Pane
  • The Grid Layout
  • The Gallery
  • The Property Editor
  • Runtime Developer Toolbar
  • Working with Pages and Page Designer
  • Working with Regions
  • Region Layouts

Working with Items & Buttons

  • Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
  • Creating and Editing Buttons
  • Creating a Report Filter 

 Page Processing

  • 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
  • ftp 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 a Navigation Menu