This course provides students with product knowledge and skills needed to Develop Basic Database Driven Web Applications.

At the end of the course, students will be able to:

• Install and configure Oracle Application Express;
• Develop a database-centric Web application;
• Utilize and manage Shared Components in an application;
• Build queries of database objects and incorporate them in an application;
• Manage users and groups;
• Manage Access Control by authorizing and authenticating users;
• Administer Oracle Application Express Workspaces;
• Load and unload data or application com

Schedule

Intended for

This course is intended for Web Application Developers who have experience with Microsoft Access, Oracle Developer Suite and PL/SQL.

Background

Before attending this course, students must have a basic knowledge of the Microsoft Windows operating system and its core functionality, a working knowledge of relational databases and SQL (see SQL and relational databases fundamentals), and some experience with PL/SQL (see PL/SQL database programming). In addition, it is recommended, but not required, that students have basic knowledge of HTML and CSS (see HTML5).

Main topics

• Introducing APEX
• Architecture
• Basics of Oracle Web Applications
• Managing Workspaces
• User Roles
• Starting with Oracle APEX
• Language issues
• Building an Application
• From scratch
• From Spreadsheet
• Import and Export
• Creating Reports
• Creating reports from scratch
• Interactive reports
• Report headers
• Report templates
• Break formatting
• Column formatting
• Creating Forms
• Creating a form on a table with report
• Creating a tabular form
• Creating a master detail form
• Editing form attributes
• Pages and Regions
• Pages
• Page Definition
• Page rendering and Page processing
• Page manipulations
• Page Zero
• Regions
• Region Definition
• Items and Buttons
• Items
• Buttons
• Button names
• Shared components
• List of Values
• Types of LOV's
• Themes and Templates
• Definitions
• Themes and Applications
• Templates
• Template type and Classes
• Template Files
• Template Subscriptions
• Navigation and Layout
• Tabs
• Navigation Bars
• Breadcrumbs
• Lists
• Trees
• Implementing Security
• Pre-configured authentication schemes
• Creating an authentication scheme
• Application Express account credentials
• Custom authentication
• Session State Protection (SSP)

Training method

Class training alternated with exercises. Each student disposes of a workstation.

Duration

2 days.

Course leader

Kris Van Thillo.