Oracle Application Express Workshop I Ed 2 NEW
• کد دوره : OR131
• مدت دوره : 40 ساعت
• شهریه : 0 ریال
• مدت دوره : 40 ساعت
• شهریه : 0 ریال
برای این دوره ، کلاس عمومی برنامه ریزی نشده است.
لطفا پیش ثبت نام نمایید
لطفا پیش ثبت نام نمایید
What you will learn:
In the Oracle Application Express Workshop I Ed 2 class, students learn how to develop database-centric web applications quickly using Oracle Application Express.
Learn To:
- Create Database Application for both desktop and mobile interfaces.
- Add various components like new pages, reports regions, items and other components required to enhance an application.
- Create Processes, Validations, computations and dynamic actions within an Application.
- Create and use Shared Components for an Application.
- Understand managing and using session state variables.
- Implement Security in an Application.
- Manage application navigation using shared components.
- Improvise their application by creating Calendars, Charts, and Trees.
- Extend their application by adding advanced features like Printing, BLOB object, Data Loading, site.
- Enable Feedback mechanism from the application and tracking the feedback from Oracle APEX.
Benefits To You
Students benefit by learning how to create database applications using desktop and mobile interfaces. They learn to enhance their application by adding various components like reports, forms, items, dynamic actions, calendars, charts, plug-ins and other shared components that are required in an application. They learn to change the look and feel of their web applications using built-in themes and templates. They will also learn about implementing security in their applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.
Audience
- Application Developers
- Business Intelligence Developer
- Database Administrators
- Forms Developer
- Project Manager
- System Analysts
- Web Administrator
Related Training
Required Prerequisites:
- Basic knowledge of SQL, PL/SQL, and HTML
Suggested Prerequisites:
- Oracle Database: SQL Workshop I NEW
- Oracle Database: SQL and PL/SQL Fundamentals NEW
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 and Run Database Applications using desktop and mobile interfaces
Course Topics:
Course Overview
- Course Goals
- Course Outline
- Order Management Database Application (OMDA)
- Introducing Course Persona: Jack
- Course Environment: Products Installed
- Course Environment: Workspace Details
- Accessing the Labs Directory
Introducing Oracle Application Express
- Application Express Overview
- Application Express Terms and Concepts
- Using Application Express
Creating a Desktop and Mobile Database Application
- Application Builder Overview
- Introducing Database Applications
- Creating Database Applications
- Creating Mobile Application
Extending Your Application: Dynamic Actions
- Adding Dynamic Actions
Working with Reports for Desktop Application
- Introducing Reports
- Using Classic Reports
- Using Interactive Reports
- Creating and Customizing an Interactive Report
Working with Reports for Mobile Application
- Creating Reports for a Mobile Application
- Creating Column Toggle Report
- Creating a Reflow Report
Creating Forms
- Using Forms
- Creating Forms
- Modifying Forms
- Creating a Form in a Mobile Application
Working with Pages and Regions
- Introducing Page Definition
- Working with Page Regions
- Working with Pages
Adding Items and Buttons
- Introducing Items
- Using Items
- Creating List of Value (LOV) Type of Items
- Using Buttons
Understanding Session State
- Understanding Session State in Oracle Application Express
- Using Session State in Oracle Application Express
Including Page Processing
- Introducing Page Processing
- Including Computations
- Including Processes
- Including Validations
- Including Branches
Validating and Debugging Your Application
- Using the Advisor
- Managing Your Attribute Dictionary
- Debugging Your Application
Adding Shared Components That Aid Navigation
- Introducing Shared Components
- Creating Tabs
- Creating Lists
- Creating Breadcrumbs
- Creating a Navigational Bar
Working with Themes, Templates and Files
- Using Themes
- Using Templates
- Using Files
Implementing Security
Managing Application Navigation
Extending Your Application
Creating and Editing Charts
Adding Calendars and Trees
Using Dynamic Actions and Plug-Ins
Utilizing Application Express Printing
Managing Application Feedback
- Securing an Application
- Using Authentication Schemes
- Using Authorization Schemes
-
Using Session State Protection
- Building a Hierarchical List with Images
- Building a Site Map
- Enforcing Authorization on Your Site Map
- Linking Interactive Reports using a Declarative Filter
- Creating Data Load Wizard Pages
- Creating an Upload and Download Page
- Adding BLOB Data to an Existing Application
- Sending Email from an Application
- Creating and Using Charts
- Enhanced Charting Examples
- Using Calendars
- Using Trees
- Using Dynamic Actions
- Using Plug-Ins
- Printing a Standard Report with Derived Output
- Creating a PDF Report with Multiple Queries
- What is Team Development?
- Managing Feedback