Oracle Application Express 3.0: Developing Web Applications

Seminarziel

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
Zielgruppe

Formsentwicker, Entwickler, PL/SQL-Entwickler

Seminarinhalte

- 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
Sachgebiete:

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

Voraussetzungen

Empfohlen:Basic knowledge of SQL, PL/SQL, and HTML