Oracle Application Express 3.0: Developing Web Applications
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
Skills Gained
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
Who Can Benefit
Forms Developer
Reports Developer
Developer
Application Developers
PL/SQL Developer
Prerequisites
Basic knowledge of SQL, PL/SQL, and HTML
Code:
AE-DEV-WEB
Length:
4 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$2,400
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
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
rentiating 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
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
