Prerequisites
To apply for the Oracle Apex Training, you need to either:
- There are no prerequisites to start with the Oracle Apex Training. If you want to learn Oracle Apex, you can take up this course.
- But if you have a basic understanding of the skills below, it will benefit your learning.
- Basic skills in SQL/PL SQL programming.
Course Curriculum
Module 1: Introduction to oracle Apex
- basics of oracle Apex fundamentals
- oracle application express
- oracle apex architecture
- logging into Oracle apex
- creating and logging into Oracle apex workspace
- apex installation
- demonstration application
- running apex demonstration application
- etc.
Module 2: Apex application builder and SQL in apex
- application builder
- page
- processing
- rendering in apex
- apex session management
- URL syntax in apex
- Oracle SQL utilities to build SQL queries
- delete and run SQL an dPL/SQL
- scripts in apex
- viewing objects in apex
- creating
- editing and dropping database objects in apex
- etc.
Module 3: Application building, pages, creating reports in apex
- how to create an application from a spreadsheet in apex
- wizard
- pages
- rendering
- apex page processing
- apex shared components
- attributes of apex page
- how to create interactive reportshow to create interactive reports
- interactive apex report attributes
- interactive report column attributes in apex
- creating SQL reports
- forms in apex
- Manipulate the Reports
- Customize the interactive Reports
- Build and Alter Classic reports
- Build and Change Wizard reports
- Identify multiple Form types
- Build and modify the forms
- Create Tabular Forms
- Tabular Forms validationManipulate the Reports
- Customize the interactive Reports
- Build and Alter Classic reports
- Build and Change Wizard reports
- Identify multiple Form types
- Build and modify the forms
- Create Tabular Forms
- Tabular Forms validation
Module 4: Components, page processing, themes, security and templates
- different attributes of apex shared components
- shared components in apex pages
- computations and validations in apex
- page processing
- processes and branches in apex
- themes
- changing themes defaults
- templates
- managing application security in apex
- creating custom authentication
- authorization schemes and authorization in apex
- Build and add Page Groups
- and Page Zero
- Define Region
- Alter a region
- and sub-region
- Configure (Setup) the session state protection (SSP).
Module 5: Deploying and Packaging Application
- different deployment options in apex
- packaging and deployment processes
- packaging applications with supporting objects in apex
- deploying applications from one environment to another.
- Find the application supporting objects
- Export application
- including its supporting objects
- Supporting objects Installation
- Application Import
Module 6: Items and Buttons in Oracle Apex
- creation of items
- buttons and types of items and buttons
- apex navigation
- creating tabs
- apex navigation bar and list of values.
- Edit Items and Edit Button Attributes
Module-7 Apex Workspaces
- Build a Developer
- Create an Apex Workspace admin user
- Observe the activity log of a developer
- Make a Storage Request
Module-8 Present Dynamic Content
- Build a dynamic action and utilize it
- Create and modify a chart
- Import a Plugin and use it
- Create a tree and a calendar
Module-9 Application Development and Management
- Track Application features
- bugs
- and changes to do
- Take Feedbacks
- Monitor Application Performance
