دوره های آموزشی

Oracle Application Express Workshop I

مشاهده سرفصل های این دوره آموزشی در سایت education.oracle.com

Required Prerequisites:

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

Suggested Prerequisites:

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

Download Course Summary PDF



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.

Learn To:

  • Create database applications 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.
  • Change the look and feel of your web applications using built-in themes and templates.
  • 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 your application by creating calendars, charts and trees.
  • Extend your application by adding advanced features like printing, BLOB object, data loading, site and more.
  • Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.

Benefits to You

When you walk away from this course, you will have developed the knowledge and skills to create database applications using desktop and mobile interfaces. You'll learn how to enhance your application by adding various components like reports, forms, items, dynamic actions, calendars, charts, plug-ins and other shared components required in an application.


  • Application Developers
  • Database Administrators
  • System Analysts
  • Project Manager
  • Forms Developer
  • Business Intelligence Developer
  • Web Administrator


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

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

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

Managing Application Navigation

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

Extending Your Application

  • 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 Editing Charts

  • Creating and Using Charts
  • Enhanced Charting Examples

Adding Calendars and Trees

  • Using Calendars
  • Using Trees

Using Dynamic Actions and Plug-Ins

  • Using Dynamic Actions
  • Using Plug-Ins

Utilizing Application Express Printing

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

Managing Application Feedback

  • What is Team Development?
  • Managing Feedback

 

  • 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


 

Oracle Application Express Workshop 2

مشاهده سرفصل های این دوره آموزشی در سایت education.oracle.com

Required Prerequisites:

 

Download Course Summary PDF

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You'll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.

Learn To:

  • Extend Your applications using collections, dynamic application and plug-ins.
  • Create and use RESTful Web Services.
  • Make your application accessible.
  • Customize themes and templates.
  • Establish a master application and corporate theme that many applications can use.
  • Migrate an existing application to a new theme.
  • Incorporate a jQueryUI ThemeRoller theme into your mobile application.
  • Secure, deploy and maintain your applications.
  • Optimize your application performance.

Benefits to You

By taking this course, you'll develop the ability to ensure that the APEX application is accessible. You'll be able to determine which theme to use based on the type of application you want to build (desktop, mobile or responsive) as well as how to customize the templates.

Set Up a Master Template Application

This course will teach you how to set up a Master (Template) Application that contains common regions used as a starting point. You'll learn how to build a landing pad page that helps to navigate throughout the application. Expert Oracle University instructors will help you explore some considerations when upgrading your APEX applications to a responsive theme while incorporating a new jQueryUI ThemeRoller theme into your existing mobile application.

 


  • Application Developers
  • Database Administrators
  • System Analysts
  • Project Manager
  • Forms Developer
  • Business Intelligence Developer
  • Web Administrator

Course Overview

  • Course Objectives
  • Lesson Schedule
  • Course Environment: Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory
  • Introducing Course Persona

Introducing Course Persona

  • Quick Review of What You Already Know
  • Securing Database Applications
  • What is a Packaged Application?
  • Components of Team Development
  • Workspace Administration
  • Other Components
  • Packaged Application Used in this course
  • Additional Resources

Using Collections

  • What is a Collection?
  • Create a collection on an interactive report

Extending Your Application: Dynamic Actions

  • Adding Dynamic Actions

Extending Your Application: Plug-ins

  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In

Incorporating Interactivity in Your Application

  • Tooltip
  • Scrolling Region
  • Add buttons with conditions in the report page to display report based on the conditions
  • Add a procedure in AJAX to refresh a page region periodically
  • Configuring Oracle Application Express to send email

Generating and Using Table APIs

  • What is a Table API?
  • Generate a Table API
  • Modify the Table API
  • 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

  • What is a RESTful Web Service?
  • Components of a RESTful Web Service
  • An Example: RESTful Web Service
  • Creating a new RESTful Web Service
  • Consuming a RESTful Web Service in an APEX Application

Using Themes and Templates

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

Developing a New Theme for Your Application Using ThemeRoller

  • What is ThemeRoller?
  • Create a theme using the ThemeRoller

Securing Your Application

  • What Is a Directory?
  • Oracle Internet Directory
  • Technical Architecture: Overview
  • Authenticating Users by Using LDAP
  • SQL Injection
  • Cross-Site Scripting
  • Browser Security
  • Application Level Security

Deploying and Maintaining Your Application

  • Application Components
  • Things to consider
  • Backups

Optimizing Your APEX Application

  • Application Performance Considerations
  • Managing Services
  • Monitoring Activity
  • Database Configuration Considerations
  • Monitoring Application Performance

Globalization and Translation

  • Understanding Application Translation and Globalization Support
  • Specifying the Primary Language for an ApplicationLoading a New Language
  • Translating an Application
  • Translating the Data the Application Uses
  • Localization
  • Switching Languages

 

  • Create and use RESTful Web Services
  • Customize themes and templates
  • Create a master application and custom theme
  • Migrate an existing application to a responsive theme
  • Incorporate interactivity in your application
  • Build tabs based on a static list
  • Secure your application
  • Deploy and maintain your applications
  • Optimize your application performance
  • Extend Your applications using collections, dynamic applications, and plug-ins
 

 

دورهای برگزار شده

برگزاری دوره سازمانی اپکس در شرکت سیستم های طلایی شرق

برگزاری دوره سازمانی اپکس در شرکت رانیر مشهد

برگزاری دوره سازمانی اپکس در سازمان آستان قدس رضوی

اولین سمینار تخصصی Oracle Apex در مشهد (تصاویر سمینار)

دومین سمینار تخصصی Oracle Apex در مشهد(تصاویر سمینار)

برخی از مشتریان ما

درباره ما

وب سایت RDBMS.IR با هدف نصب و راه اندازی، پشتیبانی و مشاوره بانک اطلاعاتی اوراکل برای هم وطنان عزیر و همچنین آموزش و تدریس اوراکل اپکس  تاسیس شده است

 

تماس با ما

شماره تماس: 09199131631

شماره تماس: 09122345018

تلگرام: 09331788945

ایمیل: این آدرس ایمیل توسط spambots حفاظت می شود. برای دیدن شما نیاز به جاوا اسکریپت دارید
Top
We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…