Introduction to Oracle Application Express (APEX for Beginners)

Course Overview

Product Overview

• Intended for new developers or seasoned developers looking to fill in some of their knowledge gaps of APEX components.
• How to use the page designer and shortcuts it provides
• How to approach APEX application development
• APEX architecture and installation decisions
• How to manage workspaces and applications
• Efficiently navigating Application Express user interface
• How to find specific components in a large application
• Run and modify an application

SQL Workshop

• How to manage database objects using The Object Browser
• Build queries using the Query Builder
• Executing adhoc SQL and PL/SQL statements using SQL Commands
• Create scripts to execute multiple related commands

Utilities

• Import and export data in many formats(CSV, TEXT, XML)
• Understand the health of your instance by using Database Monitor
• Streamline deployment scripts by generating schema object DDL
• Extra reports and utilities for modifying components in bulk.

Application Builder

• Create an application based on a spreadsheet
• Create an application from scratch
• Review and edit application objects
• Quickly navigate the builder by using the Developer Toolbar
• How to report and chart SQL statements
• Page rendering and processing overview
• Create a form and associated report

Creating Pages

• Creating and modifying a page
• Assigning pages to groups
• The Page Definition screen and page designer
• Different page types ranging from reports, forms, and calendars
• How to perform an action using page processing

Regions and Items

• Create and modify a region
• Understanding the different region types
• Create and modify buttons
• Create and modify items
• Understand the different item types
• Conditionally display and run components
• Customize queries to provide search filters and change display attributes
• Download the report to a CSV file

Page Processing

• How to validate form input
• Use computations to intelligently modify input
• Control page flow with branches
• Gain understanding of APEX URL structure
• Understanding the relationship between items and session state
• Introduction to debugging an application

Shared Components

• Create a list of links for better quality of life for users
• Understand the relationship between breadcrumb component and breadcrumb region
• Save commonly used look up values using Lists of values(LOVs)
• How to organize user navigation using Tabs, navigation bar, breadcrumbs and lists
• Create processes that perform work for every page
• Create items for tracking global values suck as USER_ID or PREVIOUS_PAGE
• Avoid hard coding values by using shortcuts
• Discuss the possibility of web services

Other Page and Region Types

• Interactive reports
• Charts for visualizing many data elements
• Calendars for organizing data by day/week/month
• Understand the usefulness of the APEX Global Page(Page Zero) for displaying the same content on multiple pages

Utilities and Reporting

• Understand where to find the translation tool
• Exporting and importing

Advanced Development Techniques

• Identify users using Authentication schemes
• Define user roles with Authorization schemes
• Security concerns and how to prevent threats(Cross Site Scripting, SQL Injection)
• Prevent URL tampering with Session State Protection

Administration and Deploying An Application

• How to prepare applications for deployment
• Understand Application Express management tools(users, logs, preferences)
• Provision workspaces to organize applications
• Define application models for standardizing application creation

Prerequisites

 Knowledge of Structured Query Language (SQL) or some Web Development technology is a plus.

** Also, we strongly recommend using two monitors for this class. **