Training objectives
- Obtain an overview of the APEX components
- Understand the APEX architecture
- Develop customized RAD applications with key features such as page structure & types, page rendering & processing, and shared components
- Setup of APEX security
- Setup of external resources such as mail and print server
- Familiarize with the Apex best practices all across the application development lifecycle
Topics
- Oracle APEX overview and history
- APEX Architecture
- APEX components: application builder, SQL workshop, team development, administration
- Application development basics for page structure & types: properties, regions, buttons and items, reports & forms, chart & calendars, wizard pages & global pages, data loading
- Application development basics for page rendering & processing as well as shared components: computations, processes, validations, dynamic actions (jQuery), branches, tabs, lists of values, breadcrumbs, lists, navigation bar
- APEX Security: authentication and authorization concept (LDAP, https)
- Mail and FOP print server integration
- Application deployment concept and automatization
- Exception handling
- Data loading
Method
- Presentation with countless practical exercises and trainings
- Case studies, Live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA), PL/SQL developer, persons responsible for or supporting internal application development based on Oracle technology
Language & documentation
- Workshop training normally held in English; French or German possible instead as course languages
- Documentation: content details, scripts, case study solutions as PDF file (in English)