Oracle Application Express

Level
Total time

Oracle Application Express

Perpetual Solutions
Logo Perpetual Solutions
Provider rating: starstarstarstarstar 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle.

Description

Prerequisites:

A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.

Course Description:

This course introduces the delegate to Oracle's Application Express software.It is designed to give delegates practical experience in using this tool for building user applications for the Web. By the end of the course delegates will be able to use the Oracle Application Express development environment for functional application development for the Web. They will gain practical experience in building and deploying applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

Prerequisites:

A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.

Course Description:

This course introduces the delegate to Oracle's Application Express software.It is designed to give delegates practical experience in using this tool for building user applications for the Web. By the end of the course delegates will be able to use the Oracle Application Express development environment for functional application development for the Web. They will gain practical experience in building and deploying applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express environment.

Apex version 4 includes all the features of Apex version 3.This course covers all the features of Apex version 3 and the new features introduced in version 4.The course is suitable for both Oracle Application Express version 4 and Oracle Application Express version 3 users.The course will be delivered using Apex version 4 software.

The delegate will practice:

  • Developing a Web Application
  • Creating Reports
  • Creating Forms
  • Managing Pages and Regions
  • Using and Managing Shared Components in an Application
  • Adding Page Processing Components
  • Managing Database Objects
  • Building Queries of Database Objects
  • Deploying an Application as a Packaged Application
  • Managing Users and Groups
  • Authorising and Authenticating Users
  • Administering APEX Workspaces
  • Loading and Unloading Data or Application Components
  • Deploying an Application

This course includes the following modules:

Introduction to Oracle Application Express

  • APEX Concepts
  • APEX Main Components
  • Create a Workspace
  • Workspace Administrator
  • Log into APEX
  • Run an Application

SQL Workshop

  • Browse, Create and Modify Objects
  • Process Ad Hoc SQL Statements
  • Manage Scripts
  • Create, Run and Save SQL Queries

Build an Application

  • Application Components
  • Create an Application
  • Create an Application from a Spreadsheet

Create Reports

  • Create Reports Using Wizards
  • Edit Report Attributes
  • Add Links to Reports
  • Save Reports in Different Formats
  • Print Reports in Different Formats

Pages and Regions

  • View Page Definitions
  • Edit Page Definitions
  • Create a New Region
  • View Region Attributes
  • Add Comments
  • Add a Title
  • Add a logo

Create Forms

  • Create a Form on a Table with Report
  • Create Forms of Different Types
  • Add a List of Values to a Form

Items and Buttons

  • Create Items
  • Edit Item Attributes
  • Create Buttons
  • Edit Button Attributes

Page Processing

  • Page Rendering and Page Processing
  • Create Computations
  • Validate Input Data
  • Process Data
  • Create Application Branching

Add Shared Navigation Components

  • Shared Components Overview
  • Parent and Standard Tabs
  • Navigation Bars
  • Lists
  • Breadcrumbs

Other Shared Components

  • Lists of Values
  • Trees
  • Shared Component Reports
  • User Interface Defaults

Display Dynamic Content

  • Filter Reports with Dynamic Queries
  • Create Charts with a Wizard
  • Create a Calendar

Dynamic Actions and Plug-In Components

  • Understand Dynamic Actions
  • Understand Plug-in Components
  • Plug In a Component
  • Create a Dynamic Action
  • Use a Plug-in in a Dynamic Action

State and Debugging

  • Understand Session State
  • Set a Session State Value
  • Clear the Session State
  • Review the Session State
  • Review the Messages in Debug Mode

Themes and Templates

  • Switch to a Different Theme
  • View Existing Templates
  • Manage Templates
  • Create a new Template
  • Template subscription
  • Add a Reference to a Cascading Style Sheet
  • Add a reference to a Javascript file

Build a Websheet Application

  • Websheet Components
  • Create a Websheet Application
  • Run a Websheet
  • Add a Section to a Websheet
  • Add a Page to a Websheet

Websheet Data Grids and Links

  • Add a Data Grid to a Websheet using Copy & Paste
  • Add a Data Grid from Scratch
  • Link a Data Grid to a Websheet Page
  • Link a File to a Websheet Page

Administer Apex Workspaces

  • Manage Users
  • Request a Schema or Storage
  • Purge Session State
  • Monitor Developer Activity Log
  • Monitor Workspace Activity
  • View Activity reports
  • Import a Workspace

Implement Security

  • Authentication and Authorization
  • Provide an Authentication Scheme
  • Create an Authorization Scheme Using Access Control
  • Enable and Configure Session State Protection

Deploy an Application

  • Define Supporting Objects
  • Package an Application
  • Export an Application
  • Import an Application
  • Install Supporting Objects

Utility Programs

  • Import and Export Data
  • Generate DDL Statements
  • View Objects Reports
  • Monitor the Database

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet.
  • View related products with reviews: Oracle.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.