Oracle APEX Training

1
Oracle Apex Training
37-12-14, plot no-27, NGGO's Colony, pattabhi
reddy gardens, Visakhapatnam-07, Ground Floor
8-3- 214/3/A, Srinivas nagar colony west, S.R
Nagar -500038, Near Huda Complex, Ph
9000444287Website www.21cssindia.com
2

• Fundamental Concepts in Oracle APEX
• Introduction to Oracle APEX
• What is an Apex solution?
• About Oracle APEX.
• Overview of APEX Architecture.
• When to use Apex?
• APEX vs. Other Web Development technologies
• History of Oracle Apex
• Progress of Oracle APEX
• Apex look feel
• Design, ready-to-use functionalities.
• How to design the solution?
• Key points for developing APEX solutions

3

• Fundamentals of Oracle APEX
• Oracle APEX Architecture.
• Oracle APEX Environment.
• Installation and Prerequisites.
• Database Users or Database Schemas
• Workspaces
• Application Express User Roles
• Creating Workspaces and Users
• Oracle APEX Development Walkthrough.
• Application Builder
• SQL Workshop
• Team Builder
• Administration
• System Message and News Regions 

4

• Understanding Oracle APEX
• Application Builder Concepts
• What is an Oracle Application Express
  Application?
• Understanding Session State Management
• Understanding URL Syntax
• Utilizing Packaged Applications
• About Packaged Applications
• Managing Packaged Applications
• About Sample Database Application
• Using Application Builder (Practical)
• Application Builder Home Page
• Application Home Page
• Managing the Development Process (Practical)

5

• About the Team Development Home Page
• Tracking Features
• Tracking Milestones
• Tracking to Dos
• Managing Bugs
• Managing Feedback
• Utilizing the Tags Summary
• Managing Team Actions
• Application Development in Oracle APEX       
• Using SQL Workshop and SQL Developer usage for
  APEX 
• Using SQL Workshop
• SQL Developer usage for APEX 
• Working with Reports
• SQL Classic Reports.
• Interactive Reports

6

• Working with Simple Forms
• Creating manual Forms.
• Creating Forms and Reports
• Understanding how forms works.
• Working with Advanced Forms
• Master-Detail Forms.
• Tabular Forms
• Working with Dynamic Actions
• Understanding Dynamic Actions
• Using Dynamic Actions
• Working with Dynamic PL/SQL Regions
• Creating a report using dynamic PL/SQL
• Creating a basic form using Pl/SQL
• Creating charts with dynamic PL/SQL

7

• Integration and Usage of Other Web Technologies
  in APEX
• HTML Basics and using it in APEX
• CSS basics and using it in APEX
• JavaScript basics and using it in APEX
• JQuery basics and using it in APEX 
• Exploring Shared Components
• Application Items
• Application Processes
• Application Computations
• Tabs and Breadcrumbs
• App Images and Workspace Images 
• Exploring Application and Code Management
• Understanding Application Export and Import
• Code Management in Oracle APEX