Получить консультацию
Training Center MUKКурсыOracleDatabaseOracle Application Express Workshop I Ed 2

Oracle Application Express Workshop I Ed 2

Код курса
Orcl_App_l
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

Course overview

This Oracle Application Express Workshop I Ed 2 training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.

Цели

Course Objectives

  • Create Pages and Regions in an Application
  • Log in to an Oracle Application Express Workspace
  • Create Page and Application Items and Buttons
  • Create Page Processes and Validations
  • Implement Security
  • Manage Application Navigation
  • Extend an Application
  • Create Themes and Templates
  • Create Shared Components such as Tabs, Lists, and Breadcrumbs
  • Add Dynamic Actions
  • Import and Use Plug-Ins
  • Create and Use Calendars and Trees
  • Utilize Application Express Printing methods
  • Manage Application feedback
  • Create Reports and Forms in an application
  • Create and Run Database Applications using desktop and mobile interfaces
Требования

Suggested Prerequisite

  • Basic knowledge of SQL, PL/SQL, and HTML

Required Prerequisite

  • Oracle Database: SQL Workshop I
  • Oracle Database: SQL and PL/SQL Fundamentals

Audience

  • Application Developers
  • Database Administrators
  • System Analysts
  • Project Manager
  • Forms Developer
  • Business Intelligence Developer
  • Web Administrator
Программа курса

Course Topics

1. Course Overview

  • Course Environment: Products Installed
  • Introducing Course Persona: Jack
  • Course Goals
  • Course Outline
  • Course Environment: Workspace Details
  • Order Management Database Application (OMDA)
  • Accessing the Labs Directory

2. Introducing Oracle Application Express

  • Application Express Overview
  • Using Application Express
  • Application Express Terms and Concepts

3. Creating a Desktop and Mobile Database Application

  • Application Builder Overview
  • Creating Mobile Application
  • Introducing Database Applications
  • Creating Database Applications

4. Working with Reports for Desktop Application

  • Using Interactive Reports
  • Using Classic Reports
  • Introducing Reports
  • Creating and Customizing an Interactive Report

5. Working with Reports for Mobile Application

  • Creating a Reflow Report
  • Creating Reports for a Mobile Application
  • Creating Column Toggle Report

6. Creating Forms

  • Creating Forms
  • Creating a Form in a Mobile Application
  • Modifying Forms
  • Using Forms

7. Working with Pages and Regions

  • Working with Page Regions
  • Introducing Page Definition
  • Working with Pages

8. Adding Items and Buttons

  • Creating List of Value (LOV) Type of Items
  • Using Buttons
  • Introducing Items
  • Using Items

9. Understanding Session State

  • Using Session State in Oracle Application Express
  • Understanding Session State in Oracle Application Express

10. Including Page Processing

  • Introducing Page Processing
  • Including Computations
  • Including Branches
  • Including Processes
  • Including Validations

11. Validating and Debugging Your Application

  • Using the Advisor
  • Managing Your Attribute Dictionary
  • Debugging Your Application

12. Adding Shared Components That Aid Navigation

  • Introducing Shared Components
  • Creating a Navigational Bar
  • Creating Lists
  • Creating Tabs
  • Creating Breadcrumbs

13. Working with Themes, Templates and Files

  • Using Templates
  • Using Files
  • Using Themes

14. Implementing Security

  • Using Authorization Schemes
  • Using Authentication Schemes
  • Using Session State Protection
  • Securing an Application

15. Managing Application Navigation

  • Enforcing Authorization on Your Site Map
  • Building a Site Map
  • Building a Hierarchical List with Images
  • Linking Interactive Reports using a Declarative Filter

16. Extending Your Application

  • Sending Email from an Application
  • Creating Data Load Wizard Pages
  • Creating an Upload and Download Page
  • Adding BLOB Data to an Existing Application

17. Creating and Editing Charts

  • Creating and Using Charts
  • Enhanced Charting Examples

18. Adding Calendars and Trees

  • Using Calendars
  • Using Trees

19. Using Dynamic Actions and Plug-Ins

  • Using Dynamic Actions
  • Using Plug-Ins

20. Utilizing Application Express Printing

  • Printing a Standard Report with Derived Output
  • Creating a PDF Report with Multiple Queries

21. Managing Application Feedback

  • What is Team Development?
  • Managing Feedback
Регистрация на ближайший курс
Oracle Application Express Workshop I Ed 2
Код курса:
Orcl_App_l
Продолжительность:
5 Дней, 40 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.