Oracle Application Express (APEX) Training

Oracle APEX Training in Chennai

Oracle APEX Training: Introduction to Oracle Application Express 4 We are the Leading Oracle APEX training Institute in Chennai. We offer best oracle APEX training with real-time project scenarios. An impeccable Oracle Application Express Developing Web Applications course that is exclusively designed with Basics through Advanced Concepts. Oracle Application Express Developer Certified Expert 1Z0-450 certification and Interview Guidance are provided during the course. All our training sessions are Completely Practical and Real Time. Rated as Best Oracle APEX training center in Chennai.

Oracle APEX Training Objectives

Understand the Oracle APEX architecture
Use SQL Workshop to interface with and manipulate your data
Build database-centric Web applications using Application Builder
Create web-based forms and reports
Secure your web applications
Deploy your web applications
Build a Websheet application
Explore the new features in the latest release of Oracle APEX

The Oracle Application Express (APEX) Developer learning path outlines a course sequence for you to gain the essential, advanced and administration knowledge to create, deploy, and maintain web applications built using Oracle Application Express. Note, APEX is formerly known as HTML DB

Oracle APEX Training Course Syllabus

Oracle Application Express: Developing Web Applications

This Developing Web Applications training will help you rapidly develop and deploy a web application using Oracle Application Express. Learn about access control, manage shared components and use the debugger to resolve issues.

Introduction to Oracle Application Express
- What is Oracle APEX?
- Benefits
- Architecture and Installation
- Capabilities
- Typical APEX Applications
- Major Components
- APEX Resources
From the Developer's Perspective
- Workspace Concepts
- Workspace Login
- APEX Components
- Application Builder Overview
- Demonstration Applications
- SQL Workshop Overview
Application Design Requirements
- Identify system requirements
- APEX specific design issues
- From ERD to Tables
Using SQL Workshop
- Accessing SQL Workshop
- Using Object Browser
- Executing SQL Commands
- Working with SQL Scripts
- Using Query Builder
- Accessing Utilities submenu
- Using Data Workshop
- Generating DDL
- Establishing User Interface Defaults
- Managing the Recycle Bin
- Using Schema Comparison
- Using About Database
Application Builder Basics
- Understand the Basics of Application Builder
- Application Builder Terms
- Methods of Creating an Application
- Editing Application Properties
Basic Forms and Reports
- Creating a Form
- Creating a Report
- Understanding Session State
- Declarative BLOBs
Advanced Forms and Reports
- Pages
- Developer Toolbar
- Tabular Forms
- Interactive Reports
- Calendar Reports
- Chart Reports
Page Controls
- Items
- Buttons
- Validations
- Computations
- Processes
- Branching
- Dynamic Actions
Security
- Overview of Security
- Authentication
- Creating a Authentication Scheme
- Authorization
- Creating an Authorization Scheme
- Access Control
- Session State Protection
Application Deployment
- APEX Application Lifecycle
- Deploying Application
- Exporting Application
- Importing Application
- Cross Application Report
Additional Developer Tools
- Application and Page Management
- APEX Views and APEX Dictionary
- Searching in APEX
- Monitoring APEX
- APEX Advisor
- Build Options
- SQL Developer and APEX
- PL/SQL Refactoring and DML Packages
APEX Plug-ins
- Types of APEX Plug-ins
- Using Plug-ins to enhance the user experience
- Extensions with authorization and authentication
APEX Features
- End User data uploads
- Improvements in Error Handling
- Tabular Form Improvements
- Mobile App Templates
- Calendar Improvements
- Client-side Dynamic Action Support
Websheets
- Websheet Page Structure
- Navigation
- Help
- Markup Syntax
- User Authentication
- User Authorization
- Sections
- Administration
- Websheet Example
APEX Workspace Administration
- Environmental Information
- Manage Service
- Managing Users and Groups
- APEX Instance Administrator
Team Development
- Team Development Overview
- Team Development Interface
- Features
- Milestones
- To Do Items
- Bugs
- Feedback
- News
Conclusion

Oracle Application Express (APEX) 4: Developing Web Applications 1Z0-450

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

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

Creating Reports

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

Creating Forms

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

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

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

Understanding Session State and Debugging

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

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

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

Using Application and Page Utilities

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

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

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

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

Administering Application Express Workspaces

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

Implementing Security

List the different ways to secure your application
Differentiate between authentication and authorization
Create an authentication scheme for your application
Create an authorization scheme using Access Control
Enable and configure Session State Protection

Deploying Your Application

Identify the supporting objects for your application
Export an application and its supporting objects
Import an application
Install the supporting objects

Managing and Maintaining the Application Development Process

Track Features, Milestones, Bugs and To Dos
Manage Feedback

Formulated SQL queries, functions and processes as per customization requirement for APEX.
Supported APEX applications and conducted performance tuning for PLSQL.
Contributed with database designs and assisted in increasing response time for APEX reports.
Designed application framework and developed Oracle APEX Application.
Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
Reviewed peer codes and documented proof of concepts and database schemas.