For Working Professionals, For Corporates, Programming

Oracle Application Express Workshop I

Course Duration: 40 hours

Course Level: Intermediate

About Course

Language: English

Duration: 40Hrs

Awarding Body: Oracle

Technology: Application Development

Exam: 1Z0-771

Course Description

Oracle Application Express allows you to create web and database applications using desktop and mobile interfaces. You’ll also learn how to enhance your application by adding various components like reports, forms, items, dynamic actions, calendars, charts, plug-ins and other shared components required in an application.

Pre-Requisite

Working Knowledge of SQL and PL/SQL.

Course Objectives

After taking this course, you should be able to:

Log in to an Oracle Application Express Workspace
Create and Run Database Applications using desktop and mobile interfaces
Create Reports and Forms in an application
Create Pages and Regions in an Application
Create Page and Application Items and Buttons
Create Page Processes and Validations
Implement Security
Manage Application Navigation
Extend an application
Create Themes and Templates
Create Shared Components such as Tabs, Lists, and Breadcrumbs
Add Dynamic Actions
Import and Use Plug-Ins
Create and Use Calendars and Trees
Utilize Application Express Printing methods
Manage Application feedback

Course Content

Course Overview
Oracle Application Express: Introduction
Creating a Database Application
Working with Reports
Working with Interactive Reports
Working with Interactive Grids
Working with Pages and Regions
Managing Forms
Adding Items and Buttons
Understanding Session State
Including Page Processing
Using Dynamic Actions and Plug-Ins
Validating and Debugging Your Application
Adding Shared Components That Aid Navigation
Working with Themes, Templates, and Files
Implementing Security
Managing Application Navigation
Extending Your Application
Creating and Editing Charts
Adding Calendars and Trees
Managing Application Feedback

Benefits of the course

The course provides foundational skills in developing database-centric web applications using Oracle APEX, covering both desktop and mobile interfaces.
Participants learn to create and manage various application components, including pages, regions, forms, reports, and shared components like tabs and breadcrumbs.
The workshop emphasizes implementing security measures, managing session states, and utilizing dynamic actions to enhance application functionality.
The course prepares professionals for roles such as application developers, database administrators, and system analysts by equipping them with practical APEX development skills.
Learners gain proficiency in customizing application themes and templates, integrating plug-ins, and adding features like calendars and charts.