(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies

IT-D 235 - Oracle Application Express (Apex)

Code Start Date Duration Venue
IT-D 235 09 October 2023 5 Days Istanbul Registration Form Link
IT-D 235 04 December 2023 5 Days Istanbul Registration Form Link
Please contact us for fees


Course Description

In this course, participants will learn about controlling behavior between the many different APEX components such as charts, reports, and maps. They will explore how to quickly set up departmental wiki pages using websheets, as well as integrate team development features to help improve overall application quality assurance. This course is intended for developers who have built a few applications already or have attended our introduction class.

Course Objectives

  • Understand APEX platform advantages
  • Use APEX platform
  • Create APEX applications 
  • Securing APEX applications

Who Should Attend?

  • Developers
  • Managers
  • supervisors
  • Anyone involved in operational IT services

Course Details/Schedule

Day 1

  • Introduction to APEX platform
  • Advantages of using APEX
  • APEX Best Practices
  • Explore how to change region positions
  • Modify templates and their different region positions
  • Understand how page templates work
  • Developing a standard application to copy navigation 
  • Resolve missing Tabs and Breadcrumbs
  • How to use Tabs, Lists, and Breadcrumbs to connect pages
  • Managing developers and user accounts; authentication and authorization
  • Using components on the global page(page zero)
  • Managing external Files
  • Region and item layout
  • How to leverage grid layout for regions and items

Day 2

  • Managing Application Development
  • How to use the APEX Adviser
  • Reports  and Dashboards
  • Customize report templates
  • Discuss column templates vs row templates
  • Understand generic column vs named column reports
  • How to create and manage charts
  • Create and edit gantt charts
  • Finding and using chart plugins
  • Creating and managing maps

Day 3

  • Websheets
  • Create and validate tabular forms
  • Using collections to enhance tabular forms
  • Creating custom themes
  • Creating custom templates
  • Using subscriptions
  • Build and understand how a plugin renders
  • Create an AJAX call and process to update a plugin
  • Bind to a native API
  • Working with native dynamic actions
  • Creating and modifying templates
  • Understand how page templates work

Day 4

  • Quality Assurance 
  • Techniques to Make Development Easier
  • Data Loading 
  • Create data upload forms
  • Process CSV and other delimited data
  • Transform the data upon upload
  • Customizing installation for easier backups
  • Validate and reject rows
  • Dynamic Actions 
  • Refresh items and regions
  • Preventing SQL Injection
  • Invoke PL/SQL processes from browser events
  • Retrieve data from the DB and set items values
  • Working with Files 
  • User managed files in the database
  • Developer files on web servers (JavaScrtipt, css, and images)
  • Upload shared component files
  • Session state; persisted vs in-memory
  • How row fetch and row process works
  • Explore some of the features those processes provide

Day 5

  • Using Virtual Private Database(VPD)
  • Understand APEX metadata views
  • Create custom QA checks
  • Team Development  
  • How to solicit application feedback
  • Manage and diagnose task and bug tracking
  • Create a user maintained departmental wiki
  • Securing applications
  • Preventing Cross-Site Scripting
  • Using Session State Protection
  • Preventing URL tampering