Training Mode: Live Instructor-led (online) | Corporate Training | Job Support
Course Duration: 30-35 hours
Trainer: Certified and expert instructors

This Oracle Application Express 18 (APEX) course introduces the delegate to Oracle’s Application Express version 18 software. It is designed to give delegates practical experience in using Application Express version 5, also known as Apex, for building web-based applications for an Oracle database and websheets for managing structured and unstructured data. In version 18 there are enhancements to the Create Application wizard, Page Wizard, Page Designer, Universal Theme, Oracle JET and jQuery upgrades and other miscellaneous improvements.

• Training by Realtime Expert trainer
• Live Online Classes
• Free study material
• Online virtual Classes available in morning, evening and weekend

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

We guarantee learning at your convenience & pace.

• Instant Access:
  Get instant access to self-paced training after signup.
• Streaming video recording:
  Watch lessons any time at your schedule, free recording.
• Exercises:
  Practical exercises help you test what you are learning as you go.
• Free Demo:
  Sign up for free demo to check whether the course is right for you and interact with the faculty live.
• Experienced Trainers:
  We only hire the industry’s best trainers
• Live free interactive web sessions:
  Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
• Structured Curriculum Schedule:
  Progress with your complete daily interactive lessons and assignments.
• Faculty Mentoring:
  Turn in daily and weekly homework for personalized feedback from faculty.
• Virtual Office Hours:
  Live interaction with the faculty and other students around the world.
• Hands on Live Projects:
  Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

INTRODUCTION TO ORACLE APPLICATION EXPRESS

• APEX Concepts
• APEX Main Components
• Workspaces, Database Applications and Websheet Applications
• Creating a Workspace
• The Workspace Administrator
• Upgrading APEX
• Logging into APEX
• Running an Application

SQL WORKSHOP

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

BUILD A DATABASE APPLICATION

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

CREATE REPORTS

• Creating Interactive Grids
• Create Reports Using Wizards
• Edit Report Attributes in Page Designer
• Add Links to Reports
• Create a Link to a Printer-Friendly version of a Report
• Save and Print Reports in Different Formats

USING FILES

• Uploading Images
• Creating Cascading Stylesheet Files
• Uploading Static Files
• Adding an Image as an Application Logo
• Adding a Reference to a Javascript File

PAGES AND REGIONS

• View Page Attributes in Page Designer
• Edit Page Attributes in Page Designer
• Create a Global Page
• Create a New Region
• View Region Attributes
• Add Comments
• Add a Title

• Add a logo

CREATE FORMS

• Web Form Behaviour in APEX
• Create a Form Based on a Table
• Create a Form Based on a Procedure
• Create a Form with a Report
• Create a Tabular Form
• Create an Editable Interactive Grid
• Format a Form
• Locking in APEX Forms

CREATING LISTS OF VALUES

• Overview of Application Express Shared Components
• Dynamic and Static Lists of Values
• Create a Dynamic List of Values
• Create a Static List of Values
• Use a List of Values to Control Data in a Report
• Create a Cascading List of Values

ITEMS AND BUTTONS

• Understand the Different Types of Items
• Create Page Items
• Create Application Items
• Understand and Edit Item Attributes in Page Designer
• Use Javascript with Item
• Create and Edit Buttons

PAGE PROCESSING

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

SHARED COMPONENTS

• Overview of Application Express Navigation Components
• Manage the Navigation Menu
• Create Navigation Bar Entries
• Manage Breadcrumbs
• Create and Use Lists and List Items
• Creating and using Shortcuts

DISPLAY DYNAMIC CONTENT

• Create Hierarchical Trees
• Creating and editing Charts
• Creating and editing Calendars

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
• Enabling Feedback
• Managing Feedback and Team Development

THEMES AND TEMPLATES

• Switch to a Different Theme
• View Existing Templates
• Understand and Manage Templates
• Create a new Template
• Add References to Cascading Stylesheet and Javascript Files

DYNAMIC ACTIONS AND PLUG-IN COMPONENTS

• Identify Plug-in Components and their Types
• Plug In a Component
• Create Dynamic Actions
• Use a Plug-in in a Dynamic Action

BUILDING WEBSHEET APPLICATIONS

• Websheet Applications and their Components
• Create a Websheet Application
• Enable SQL and PL/SQL in a Websheet Application
• Add Links on a Websheet Page
• Add a Data Grid to a Websheet Application
• Create SQL Reports ion Websheet Applications
• Add Annotations to a Websheet Application

IMPLEMENTING 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