Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
OR2345 Oracle APEX fundamentals on your request on your request Contact Us

Oracle APEX fundamentals

Oracle APEX fundamentals

Overview

Course code: 
OR2345
Duration: 
3
Time Unit: 
Day(s)
Overview: 

APEX is a tool to create rapidly web applications based on an Oracle database. This course provides an introduction to the overall architecture and to all its building blocks. During this course you will create your own application making use of the most important APEX features.

Topics

Topics: 

INTRODUCTION TO APPLICATION EXPRESS
• HISTORY
• ARCHITECTURE
• APEX ON THE FIELD
• KEY FEATURES
• ADVANTAGES AND DISADVANTAGES

PREPARING THE APEX ENVIRONMENT
• INSTALLATION
• GLOBALIZATION
• FILES (IMAGES, CSS)
• EXPORT/IMPORT
• LOG IN
• CREATE WORKSPACES
• CREATE USERS

APPLICATION BUILDER
• WEBSHEETS
• DATABASE APPLICATIONS
• APEX URL
• PAGE RENDERING
• PAGE PROCESSING
• SHARED COMPONENTS

CREATE REPORTS
• CLASSIC REPORTS
• INTERACTIVE REPORTS
• CUSTOMIZE REPORTS
• MANUAL REPORTS (APEX_ITEM)

CREATE FORMS
• FORMS ON A TABLE WITH REPORTS
• MASTER_DETAIL FORMS
• TABULAR FORMS
• CUSTOMIZE FORMS

ADD ITEMS AND BUTTONS
• ITEM TYPES
• LIST OF VALUES
• BUTTON TYPES

CREATE OTHER REGION TYPES
• TREES
• CHARTS
• CALENDARS
• MAPS
• BREADCRUMBS

CREATE PROCESSES ON RENDERING
• COMPUTATIONS
• PROCESSES (PL/SQL, AUTOMATIC FETCH)
• DYNAMIC ACTIONS

CREATE PROCESSES ON SUBMIT
• COMPUTATIONS
• VALIDATIONS
• PROCESSES (PL/SQL, AUTOMATIC DML)
• SESSION STATE MANAGEMENT
• BRANCHING

ADD NAVIGATION
• TABS
• LISTS
• BREADCRUMBS
• NAVIGATION BAR ENTRIES

ADD SHARED LOGIC
• APPLICATION ITEMS
• APPLICATION PROCESSES

MANAGE SECURITY
• AUTHENTICATION
• AUTHORIZATION

APPLICATION UTILITIES
• APEX VIEWS
• ADVISOR
• SEARCH AND FINDER

INTERACTION WITH THE DATABASE (SQL WORKSHOP)
• OBJECT BROWSER
• SQL COMMANDS
• SQL SCRIPTS
• UTILITIES

Prerequisites

Prerequisites: 

• Knowledge of SQL and PL/SQL
• Course OR2069 : Oracle : SQL Basics or equivalent knowledge
• Course OR2071 : Oracle : PL/SQL Fundamentals or equivalent knowledge

Audience

Audience: 

Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
• Application designers and developers
• Business users