OVERVIEW
This 3-day course covers all of the fundamentals of APEX by using an intensive hands-on approach. Students will build a functioning application as they explore the basic navigational, logic, and UI concepts of APEX application development. This course starts out with a review of the architecture of APEX, how it works, and some example projects that have been built with APEX. It then describes the Utilities and SQL Workshop facilities of APEX.
The bulk of the class is spent on the application builder. Most of the core components are covered in Intro to APEX, with hands-on exercises used to reinforce the concepts. Intro to APEX concludes with a discussion on configuration management and best practices.
DURATION: 3 Days
PREREQUISITES: Basic knowledge of HTML, SQL and PL/SQL
AUDIENCE
Introduction to Oracle Application Express is designed for those who have little to no interaction with APEX or for those looking to formalize their understanding of APEX.
COURSE TOPICS
|
Import Spreadsheet Data
- Import data from a spreadsheet
- Create tables, sequences and triggers with APEX
Import & Run SQL Scripts
- Import and Run a SQL Script
- Inspect the results for errors
UI Defaults
- Set UI Defaults for Forms and Reports
Reports & Forms
- Create a Form on a Table
- Modify Form Items
- Customize Form Layout
Master Detail Report & Form
- Create a Master-Detail Report and Form
- Add a filter to the Report
Interactive Reports
- Create an Interactive Report
- Customize Interactive Report options
Tabular Forms
Calendars
- Create a Calendar Report
- Link the Calendar Report to a Form
Charts
- Create a Flash-based Chart
- Link the Chart to a filter item
PDF Printing
- Enable a Report to print in PDF
- Alter PDF report settings
Validations
- Create an item-level validation
- Create a page-level validation
Computations
- Create a Computation
Processes
- Create a PL/SQL process
- Create APEX-specific processes
Dynamic SQL
- Create a Dynamic SQL report
- Understand new Oracle 10g Syntax
JavaScript & Ajax
- Create a JavaScript validation
- Create an Ajax component
Templates
- Add a custom logo
- Create a new Theme
- Switch Themes
- Create a new Report Template
Security
- Create an Authorization Scheme
- Create an Authentication Scheme
- Implement Access Control
- Enable Session State Protection
|