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.
  • Used Oracle APEX 4.0 for designing application structure.
  • Formulated oracle process, data retrieval methods and SQL code blocks.
  • Designed and evaluated applications, and provided architectural input apps.
  • Coded, tested and troubleshot software applications.
  • Conducted unit testing and maintained data extractions and object models.
  • Supported QA activities, test plans and performance enhancement techniques.