Objetivo

Este Curso Oracle Application Express Workshop II,  nos ajuda a obter as informações aprendidas no curso Oracle Application Express Workshop I. Aprendemos os tópicos que incluem o conhecimento sobre como usar coleções, adicionar ações dinâmicas, produzir e modificar plug-ins e criar e consumir um Web Service tranquilo. Objetivos do Curso: Divulgar aplicativos usando coleções, aplicativos dinâmicos e plug-ins. Criando e praticando Web Services repousantes. Tornando o aplicativo acessível. Modificando temas e modelos. Criando um aplicativo principal e um tema corporativo que vários aplicativos podem preparar. Movendo-se de um aplicativo atual para um novo tema. Integre um tema jQueryUI ThemeRoller em nosso aplicativo móvel. Proteja, organize e sustente seus aplicativos. Melhorando o desempenho do nosso aplicativo.

Publico Alvo

• Administrator
• Database Administrator
• Developer
• Manager
• Systems Administrator

Pre-Requisitos

• Conhecimento básico de SQL, PL/SQL e HTML.
• Curso Workshop Oracle Application Express I Foundation

Informações Gerais

• Carga Horaria: 32h
• Se noturno este curso e ministrado de segunda-feira a sexta-feira das 19h às 23h, total de 6 encontros
• Se aos sábados este curso e ministrado das 09h às 18h, total de 3 encontros
• Quando in-company, este curso e ministrado de acordo com abas as agendas.

Formato de entrega:

• 100% on-line via Microsoft Teams, na presença e um instrutor/consultor Oracle ativo no mercado e docente em sala de aula, com experiencia na formação de pessoa física e empresas
• Apostila + Lab Oracle

Materiais

Conteúdo Programatico

Course Overview

1. Course Objectives
2. Lesson Schedule
3. Course Environment: Products Installed
4. Course Environment: Workspace Details
5. Accessing the Labs Directory
6. Introducing Course Persona

Introducing Course Persona

1. Quick Review of What You Already Know
2. Securing Database Applications
3. What is a Packaged Application?
4. Components of Team Development
5. Workspace Administration
6. Other Components
7. Packaged Application Used in this course
8. Additional Resources

Using Collections

1. What is a Collection?
2. Create a collection on an interactive report

Extending Your Application: Dynamic Actions

• Adding Dynamic Actions

 Extending Your Application: Plug-ins

1. Authentication/Authorization Plug-in Capability
2. Using and Customizing the CSS Bar Chart Plug-In

Incorporating Interactivity in Your Application

1. Tooltip
2. Scrolling Region
3. Add buttons with conditions in the report page to display report based on the conditions
4. Add a procedure in AJAX to refresh a page region periodically
5. Configuring Oracle Application Express to send email

Generating and Using Table APIs

1. What is a Table API?
2. Generate a Table API
3. Modify the Table API
4. Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API

 Creating and Using RESTful Web Services

1. What is a RESTful Web Service?
2. Components of a RESTful Web Service
3. An Example: RESTful Web Service
4. Creating a new RESTful Web Service
5. Consuming a RESTful Web Service in an APEX Application

Using Themes and Templates

1. Application Types: Desktop, Mobile, Responsive - Explain what they are and what criteria determines which application to creat
2. Theme Overview: Which ones are for which type of Application
3. Review the layout of a Page template
4. Include using CSS to customize the template
5. Using Substitution Strings in Templates
6. Utilize new page attributes - files/inline styles
7. Create and modify a theme
8. Establishing a Master Application and a Corporate Theme

Developing a New Theme for Your Application Using ThemeRoller

1. What is ThemeRoller?
2. Create a theme using the ThemeRoller

Securing Your Application

1. What Is a Directory?
2. Oracle Internet Directory
3. Technical Architecture: Overview
4. Authenticating Users by Using LDAP
5. SQL Injection
6. Cross-Site Scripting
7. Browser Security
8. Application Level Security

Deploying and Maintaining Your Application

1. Application Components
2. Things to consider
3. Backups
4.  Module 13: Optimizing Your APEX Application
5. Application Performance Considerations
6. Managing Services
7. Monitoring Activity
8. Database Configuration Considerations
9. Monitoring Application Performance

Globalization and Translation

1. Understanding Application Translation and Globalization Support
2. Specifying the Primary Language for an ApplicationLoading a New Language
3. Translating an Application
4. Translating the Data the Application Uses
5. Localization
6. Switching Languages