| Oracle Application Express 3.0: Developing Web Applications |
|
Oracle University
Oracle Application Express 3.0: Developing Web Applications Duration:
4 Days
What you will learn 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. Learn to: Develop a database-centric Web application using the Application Builder Manage Authentication, Authorization and Session State within your Application Utilize and Manage Shared Components Administer Application Express Workspaces Manage Database Objects Using SQL Workshop Deploy Your Application Audience Application Developers Developer Forms Developer PL/SQL Developer Reports Developer Prerequisites Suggested Prerequisites Basic knowledge of SQL, PL/SQL, and HTML Course Objectives Login to Oracle Application Express Develop a database-centric Web application Utilize and Manage Shared Components in an Application Add Page Processing components Manage database objects Build queries of database objects and incorporate in an application Deploy the Application as a Packaged Application Manage users and groups Manage Access Control by authorizing and authenticating users Administer Oracle Application Express Workspaces Load and Unload data or application components Copyright © 2009, Oracle. All rights reserved. Page 1 Course Topics 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 |
