Visão Geral

Este Curso Oracle APEX Application Express Intermediate Workshop, ensina aos participantes como controlar o comportamento entre os diversos componentes do APEX, como gráficos, relatórios e mapas. Os alunos aprendem como configurar rapidamente páginas wiki departamentais usando planilhas da web, bem como integrar recursos de desenvolvimento de equipe para ajudar a melhorar a garantia geral de qualidade do aplicativo.

Objetivo

Após participar com êxito deste Curso Oracle APEX Application Express Intermediate Workshop você será capaz de:

• Implementar as melhores práticas do APEX
• Crie interfaces de navegação com guias, listas e/ou trilhas de navegação
• Refine o layout de suas regiões e itens
• Crie relatórios, gráficos e formulários tabulares
• Crie temas e modelos personalizados
• Construir plug-ins
• Crie ações dinâmicas
• Preservar o estado da sessão
• Implemente a autenticação LDAP e evite ataques de injeção de SQL e scripts entre sites

Pre-Requisitos

• Ter parcitipado do Curso Oracle APEX Application Express Workshop Foundation
• Ter conhecimento equivalente 

Materiais

Conteúdo Programatico

Introduction

APEX Best Practices

1. Customizing the install for easier backups
2. Managing developers and user accounts
3. Securing applications
4. Preventing URL tampering
5. Managing External Files
6. Techniques to Make Development Easier
7. Developing a Standard Application to Copy

Navigation

1. How to use Tabs, Lists, and Breadcrumbs to connect pages
2. Using components on the global page (page zero)
3. Resolve missing Tabs and Breadcrumbs

Region and Item Layout

1. How to leverage Grid Layout for Regions and Items
2. Explore how to change region positions
3. Modify templates and their different region positions
4. Understand how page templates work

Reports

1. Customize report templates
2. Discuss column templates vs row templates
3. Understand generic column vs named column reports

Charts

1. How to create and manage pie and bar charts
2. Create and edit Gantt charts
3. Finding and using Chart plugins

Interactive Grid

1. Manually Create Tabular Forms
2. Validation in Tabular Forms
3. Using Collections to enhance tabular forms

Themes and Templates

1. Creating Custom Themes
2. Creating Custom Templates
3. Using Subscriptions

Build a plugin

1. Understand how a plugin renders
2. Create an AJAX call and process to update the plugin
3. Bind to the native API so it works with native dynamic actions

Data Loading

1. Create data upload form for users
2. Process CSV and other delimited data
3. Transform the data upon upload
4. Validate and reject rows

Dynamic Actions

1. Refresh items and regions
2. Invoke PL/SQL processes from browser events
3. Retrieve data from the DB and set items values
4. Event scope and event delegation

Working with Files

1. User managed files in the database
2. Developer files on the webserver (JavaScript, css, and images)
3. Upload shared component files
4. Fetch files from a REST service
5. Add thumbnails to a report

Understanding Session State

1. Understand the difference between persisted and in-memory session state
2. How row fetch and row processing actually works
3. Explore some of the features those processes provide

Security

1. Custom Authentication and Authorization
2. Implementing LDAP and SSO
3. Using Virtual Private Database (VPD)
4. Using Session State Protection
5. Preventing SQL Injection
6. Preventing Cross-Site Scripting
7. Managing Application Development