Oracle Application Express
Starting dates and places
Description
Prerequisites:
A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.Course Description:
This course introduces the delegate to Oracle's Application Express software.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 …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Prerequisites:
A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.Course Description:
This course introduces the delegate to Oracle's Application Express software.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.
Apex version 4 includes all the features of Apex version 3.This course covers all the features of Apex version 3 and the new features introduced in version 4.The course is suitable for both Oracle Application Express version 4 and Oracle Application Express version 3 users.The course will be delivered using Apex version 4 software.
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
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
Dynamic Actions and Plug-In Components
- Understand Dynamic Actions
- Understand Plug-in Components
- Plug In a Component
- Create a Dynamic Action
- Use a Plug-in in a Dynamic Action
State and Debugging
- Understand 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
- Create a new Template
- Template subscription
- Add a Reference to a Cascading Style Sheet
- Add a reference to a Javascript file
Build a Websheet Application
- Websheet Components
- Create a Websheet Application
- Run a Websheet
- Add a Section to a Websheet
- Add a Page to a Websheet
Websheet Data Grids and Links
- Add a Data Grid to a Websheet using Copy & Paste
- Add a Data Grid from Scratch
- Link a Data Grid to a Websheet Page
- Link a File to a Websheet Page
Administer Apex Workspaces
- Manage Users
- Request a Schema or Storage
- Purge Session State
- Monitor Developer Activity Log
- Monitor Workspace Activity
- View Activity reports
- Import a Workspace
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
For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.