Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle Application Express - Developing Web Applications

( Duration: 5 Days )

In Oracle Application Express - Developing Web Applications training course, you will learn to rapidly develop a Web application and then deploy using Oracle Application Express. This course also explains dynamic actions, plug-ins, shared components, and how to use and modify the available themes and templates. You will also learn about the creation and management of database objects. Explore two types of applications, database and websheet, along with the various types of page wizards.

By attending Oracle Application Express - Developing Web Applications workshop, delegates will learn to:

  • Develop database and websheet applications
  • Deploy the Application as a Packaged Application
  • Debug your application
  • Utilize dynamic components such as dynamic actions and plugins
  • Manage Access Control by authorizing and authenticating users
  • Utilize Team Development to drive the application development process
  • Utilize and Manage Shared Components in an Application
  • Add Page Processing components
  • Manage database objects
  • Administer Oracle Application Express Workspaces
  • Load and Unload data or application components
  • Manage users and groups
  • Build queries of database objects and incorporate in an application
  • Use and manipulate reports and forms in Oracle Application Express

COURSE AGENDA

1

Maintaining Database Objects Using SQL Workshop

  • Browse, create and modify database objects using Object browser
  • Execute SQL scripts using SQL Command and SQL Scripts
  • Build and save SQL queries using Query Builder
  • Import and export data using Utilities
2

Building Database Applications

  • Discuss the difference between a Database Application and a Websheet Application
  • Identify the components of a database application
  • Create a database application from scratch
  • Create a database application from a spreadsheet
3

Creating Reports

  • Identify the types of reports you can create
  • Create, manipulate and customize interactive reports
  • Create and modify classic and wizard reports
4

Creating Forms

  • Identify the types of forms you can create
  • Create and modify various types of forms
5

Working with Pages and Regions

  • View and edit page definitions and attributes
  • Create and modify a region and subregion
  • Create a Page Zero
  • Add page groups and comments
6

Adding Items and Buttons

  • Identify different types of items
  • Create items and edit item attributes
  • Create and use List of Values
  • Create buttons and edit button attributes
7

Understanding Session State and Debugging

  • Explain how APEX uses session state
  • View, reference and clear session state values
  • Review messages in debug mode
8

Including Page Processing

  • Explain the difference between page rendering and page processing
  • Create computations in application pages
  • Create page processes
  • Create validations to verify user input
  • Create branches within a application
9

Building a Websheet Application

  • Create a Websheet Application
  • Add a Page to a Websheet Application
  • Add and manipulate a Data Grid and Report
  • Add Annotations to a Data Grid
  • Create a Saved Report of a Data Grid
  • Add Sections to a Page
  • Share Websheets using an Access Control List
10

Using Application and Page Utilities

  • Use the Advisor to verify your application
  • Manage defaults using the Attribute Dictionary
11

Adding Shared Components that Aid Navigation

  • Explain the use of shared components in an application
  • Create and edit tabs, navigation bar entries, lists and breadcrumbs
12

Displaying Dynamic Content

  • Create and use a dynamic action
  • Import and use a plugin
  • Create and modify a chart
  • Create a calendar
  • Create a tree
13

Working with Themes, Templates, and Files

  • Explain what themes and templates are
  • Create a new theme from the repository and switch to the theme to make current
  • Create and edit a template
  • Upload and use a Cascading Style Sheet and an image
14

Administering Application Express Workspaces

  • Create a developer and a workspace administrator user
  • Request a schema or a storage
  • Monitor the developer activity log
15

Implementing Security

  • List the different ways to secure your application
  • Differentiate between authentication and authorization
  • Create an authentication scheme for your application
16

Deploying Your Application

  • Identify the supporting objects for your application
  • Export an application and its supporting objects
17

Managing and Maintaining the Application Development Process

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X