Oracle Application Express
View course dates
Course Duration: 3 days
Course Code: OAE
Course Description:
This course introduces the delegate to Oracle Application Express. It is designed to give delegates practical experience in using this tool for building user applications for the Web. By the end of the course delegates will be able to use the Oracle Application Express development environment for functional application development for the Web. They will gain practical experience in building and deploying applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express environment.
The delegate will practice:
- Developing a Web Application
- Creating Reports
- Creating Forms
- Managing Pages and Regions
- Using and Managing Shared Components in an Application
- Adding Page Processing Components
- Managing Database Objects
- Building Queries of Database Objects
- Deploying an Application as a Packaged Application
- Managing Users and Groups
- Authorising and Authenticating Users
- Administering APEX Workspaces
- Loading and Unloading Data or Application Components
- Deploying an Application
Prerequisites:
A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.
Prerequisite courses:
Oracle SQL
PL/SQL
Follow on courses:
PL/SQL Stored Program Units
SQL*Plus Performance Tuning
This course includes the following modules:
Introduction to Oracle Application Express
- APEX Concepts
- APEX Main Components
- Create a Workspace
- Workspace Administrator
- Log into APEX
- Run an Application
SQL Workshop
- Browse, Create and Modify Objects
- Process Ad Hoc SQL Statements
- Manage Scripts
- Create, Run and Save SQL Queries
Build an Application
- Application Components
- Create an Application
- Create an Application from a Spreadsheet
Create Reports
- Create Reports Using Wizards
- Edit Report Attributes
- Add Links to Reports
- Save Reports in Different Formats
- Print Reports in Different Formats
Pages and Regions
- View Page Definitions
- Edit Page Definitions
- Create a New Region
- View Region Attributes
- Add Comments
- Add a Title
- Add a logo
Create Forms
- Create a Form on a Table with Report
- Create Forms of Different Types
- Add a List of Values to a Form
Items and Buttons
- Create Items
- Edit Item Attributes
- Create Buttons
- Edit Button Attributes
Page Processing
- Page Rendering and Page Processing
- Create Computations
- Validate Input Data
- Process Data
- Create Application Branching
Add Shared Navigation Components
- Shared Components Overview
- Parent and Standard Tabs
- Navigation Bars
- Lists
- Breadcrumbs
Other Shared Components
- Lists of Values
- Trees
- Shared Component Reports
- User Interface Defaults
Display Dynamic Content
- Filter Reports with Dynamic Queries
- Create Charts with a Wizard
- Create a Calendar
State and Debugging
- Implement Session State
- Set a Session State Value
- Clear the Session State
- Review the Session State
- Review the Messages in Debug Mode
Themes and Templates
- Switch to a Different Theme
- View Existing Templates
- Manage Templates
- Add a Reference to a Cascading Style Sheet
Administer Apex Workspaces
- Manage Users
- Request a Schema or Storage
- Purge Session State v Monitor Developer Activity Log
- Monitor Workspace Activity
- View Activity reports
Implement Security
- Authentication and Authorization
- Provide an Authentication Scheme
- Create an Authorization Scheme Using Access Control
- Enable and Configure Session State Protection
Deploy an Application
- Define Supporting Objects
- Package an Application
- Export an Application
- Import an Application
- Install Supporting Objects
Utility Programs
- Import and Export Data
- Generate DDL Statements
- View Objects Reports
- Monitor the Database
|
Click on course date to make a booking, check availability, or find out about available discounts.
|
London |
3 days |
£1195 |
|
28 - 30 |
|
23 - 25 |
|
4 - 6 |
Save as PDF
Print this course
Enquiry And Feedback Form