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.