Oracle Application Express (APEX) Training
What is Oracle APEX?
Oracle Application Express (APEX) is a web-based application development tool for rapidly developing, deploying and managing business-critical web applications. It is a low-code development platform that includes rapid web application development and automated database management. It is used by developers to create web applications that are secure, robust, and feature-rich.
Who is this course for?
This course will help citizen developers, web developers, and everyone who would like to learn the low code platform and help organization to quickly meet the frequently changing requirements.
What you’ll learn in this APEX Training?
• How to start with APEX and create your own workspace to build application.
• Application designing, page creation, form processing, dynamic and interactive components creation.
• How to interact with external application using REST and SOAP APIs
• Provide support in Resume and Interview Preparation
What can you do after this Training?
• You will have enough skills and knowledge to quickly build and deploy powerful database-driven web applications with Oracle Application Express
• How to extend your application by adding reports, collections, plugins, and more through hands-on exercises and projects
• Oracle APEX cloud developer professional (1ZO-770) exam
REQUEST TO ENROL
Training Course Structure
• Why Oracle APEX
• The APEX architecture
• Use-cases of Oracle APEX
• On-premises and Oracle Cloud options for Oracle APEX
• Pre-requisites for Oracle APEX setup and installation
• Setup Oracle APEX as a service
• Provisioning an Oracle APEX workspace
• How to create workspace users
• Instance Administration Tasks
• Types of Oracle APEX applications
• Understanding of Regions
• Understanding of Forms, Reports, Charts
• Understanding of dynamic actions
• How tables are getting created from the excel files
• How to add and modify filters
• App builder Overview
• Page Designer Overview
• How to use SQL commands and SQL scripts
• Build and save SQL queries using Query Builder
• Import and export data using Utilities
• Generate SQL by using quick SQL
• Exploring page structure and components
• Understanding of regions
• Create and modify a region and subregion
• Add page groups and comments
• Learn how to create various type of reports
• Create faceted search, cards, and smart filters
• Create, manipulate and customize interactive reports
• Create and modify classic and wizard reports
• Customize an Interactive Grid as a developer
• Customize an Interactive Grid as an end-user
• How to work with List of Values
• How to create dependent List of Values
• Identify different type of items
• Create items and edit item attributes
• Creating and understanding of page computations
• Creating and understanding of page validations
• How to create various branches
• Working with Dynamic Actions
• Enabling and disabling components using dynamic actions
• Filtering and Refreshing the regions
• Filtering and Refreshing the reports
• Understanding of Smart Search
• Creating and modifying Faceted Search
• Creating and modifying Smart Search
• Working with Cards
• Creating different type of Navigations
• Working with dialog boxes
• How to navigate from one page to another
• Working with pagination
• Understanding of different Templates
• Managing themes using CSS
• Understanding theme style and theme roller
• Create a new theme from the repository and switch to the theme to make current
• How to REST data sources
• REST Data Synchonization
• Create, edit and manage automations
• Introducing the approval in Oracle APEX
• How to create and manage approvals
• How to send email notifications
• Understanding of Authorization scheme
• Create an authentication scheme for your application
• Create an authorization scheme using Access Control
• Implementing security in the APEX application
• Importing application to target environments
• Migration of database objects between environments
• One-click remote deployment
• Understanding of various recommendations of APEX application
• How to optimize the APEX application
• Social Media App
• Online Shopping Cart Application
Training Details
Training Schedule
Timings: 03:00 to 06:00 PM IST
Day: Saturday and Sunday
Date: 17-Mar-2024
Total Duration: 30 hours
Mode: Online
REQUEST TO ENROL