Oracle Application Express - Level 1

Displaying courses for Great Britain [Change]

Overview

This level 1 course is for anyone who wants to learn the basics of Application Express (APEX)

Objectives

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
  • SQL Developer and APEX
  • Building integrated applications
  • Integrating APEX & BI Publisher

Getting Started with Application Express

  • What is a Workspace?
  • Different types of APEX users
  • How to access APEX
  • Application Express Components
  • 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 Definition
  • 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
  • Page Definition
  • Creating Tabular Forms
  • Creating Master-Detail Forms

Creating Reports

  • Types of Reports
  • Creating Wizard Reports
  • Linking a Report to a Form
  • Creating SQL or Classic Reports
  • Creating Interactive Reports

Understanding Pages and Regions

  • What is a Page in APEX?
  • Different Sections of a Page
  • Page Rendering
  • Page Processing
  • Shared Components
  • Page Attributes
  • What is a Region?
  • Lists, Breadcrumbs and Calendar Regions
  • Positioning Regions

Working with Items & Buttons

  • Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
  • Types of 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
  • f?p 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 Tabs

Themes and Templates

  • Understanding Themes
  • Switching Themes
  • Changing Theme Defaults
  • Understanding Templates in APEX
  • Understanding CSS in APEX
  • How to incorporate your own look and feel by customizing themes, templates & CSS

Oracle APEX Workspace Administration

  • Workspace Administration Topics
  • Manage Services
  • Manage Users and Groups
  • Monitor Activity
  • Dashboards
  • Workspace Utilization
  • Feedback Form
  • Team Development

APEX Security Features

  • Understanding the Security Options in APEX
  • Creating Custom Authentication
  • Understanding Authorization - Access Control Page
  • Session State Protection.

Packaging & Deploying Applications

  • Understanding Different Deployment Options
  • Exporting an Application
  • Including Supporting Objects
  • Importing and Installing an Application

Prerequisites

We recommend a basic knowledge of SQL and PL/SQL or attendance of the following courses prior to attending this course:

http://qa.com/training-courses/technical-it-training/oracle/database/database-application-development/oracle-database-sql-and-plsql-fundamentals/

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Oracle Database
Great Britain
This skill has an average salary of
£52,212
and is mentioned in
0.51%
of job ads in this area.
Cascading Style Sheets (CSS)
Great Britain
This skill has an average salary of
£46,803
and is mentioned in
1.37%
of job ads in this area.
Database
Great Britain
This skill has an average salary of
£43,107
and is mentioned in
4.85%
of job ads in this area.
SQL
Great Britain
This skill has an average salary of
£50,365
and is mentioned in
2.11%
of job ads in this area.