Application Express 3.0

APEX3.0 - Application Express 3.0

Descrição:

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various Application Express components and wizards to build applications and database objects that are easy to deploy. The students learn how to build forms and reports and incorporate different types of items and shared components. Creating and utilizing various navigation components as well as session management and debugging are discussed. In addition, students incorporate access control, and session protection to enforce application security. Once the application is complete, students learn how to define their packaged application and export the application. Students will also use all the Utilities and Report capabilities that Oracle Application Express provides to build a robust application.

Tópicos:

• Introducing Oracle Application Express
• Explaining the General Concepts
• Identifying the Main Components
• Creating a Workspace and Workspace Administrator
• Logging In to Oracle Application Express
• Installing and Running a Sample Application
• Installing a Packaged Application


• Interacting with the Database by Using SQL Workshop
• Browsing, Creating and Modifying Objects
• Processing Ad Hoc SQL Statements
• Managing Scripts
• Creating, Running and Saving SQL Queries


• Building an Application
• Identifying the Components of an Application
• Creating an Application from Scratch
• Creating an Application from a Spreadsheet


• Creating Reports
• Generating Reports Using Wizards
• Editing Report Attributes
• Adding Links in Reports
• Saving or Printing Reports in Different Formats


• Creating Forms
• Creating a Form on a Table With a Report
• Creating a Tabular Form
• Creating a Master-Detail Form
• Editing Form Attributes


• Working with Pages and Regions
• Viewing Page Definitions
• Editing Page Attributes
• Creating a New Region
• Viewing Region Attributes
• Adding Comments


• Adding Items and Buttons
• Creating Items
• Editing Item Attributes
• Creating Buttons
• Editing Button Attributes


• Understanding Session State and Debugging
• Implementing Session State
• Setting a Session State Value
• Clearing the Session State
• Reviewing the Session State
• Reviewing the Messages in Debug Mode


• Including Page Processing
• Explaining the Difference Between Page Rendering and Page Processing
• Creating Computations
• Validating Input Data
• Process Data
• Creating Application Branching


• Adding Shared Components That Aid Navigation
• Providing an Overview of Shared Components
• Managing Parent and Standard Tabs
• Managing Navigation Bars
• Managing Lists
• Managing Breadcrumbs


• Adding Other Shared Components
• Managing List of Values
• Managing Trees
• Accessing Shared Component Reports
• Setting User Interface Defaults


• Displaying Dynamic Content
• Filtering Reports Using Dynamic Queries
• Creating Charts Using a Wizard
• Creating a Calendar


• Working with Themes and Templates
• Switching to a Different Theme
• Viewing Existing Templates
• Managing Templates
• Adding a Logo
• Referencing a Cascading Style Sheet
• Changing a Field to Use a Class in the Referencing Stylesheet


• Administering Oracle Application Express Workspaces
• Managing Users
• Requesting a Schema or Storage
• Purging Session State
• Monitoring Developer Activity Log
• Monitoring Workspace Activity
• Viewing Activity Reports


• Implementing Security
• Differentiating Between Authentication and Authorization
• Providing an Authentication Scheme
• Creating an Authorization Scheme Using Access Control
• Enabling and Configuring Session State Protection


• Deploying Your Application
• Defining Supporting Objects
• Exporting Your Application
• Importing Your Application
• Installing Supporting Objects


• Using Utilities
• Importing and Exporting Data
• Generating Data Definition Language (DDL) Statements
• Viewing Object Reports
• Monitoring the Database

Duração: 3 dias