Oracle Application Express Course Overview
This
Oracle Application Express course introduces the delegate to Oracle's Application Express version 4 software. It is designed to give delegates practical experience in using Application Express version 4, also known as Apex, for building web-based applications for an Oracle database and websheets for managing structured and unstructured data.
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.
Skills Gained
The delegate will practice:
- Developing an Apex Web Application
- Using the Apex SQL Workshop
- Creating Reports
- Creating Forms
- Managing Web Pages and Regions in the Apex Application
- Using and Managing Shared Components in an Application
- Using Cascading Stylesheets and Javascripts in Apex Applications
- Adding graphs and charts to an Apex Application
- Adding Page Processes to the Apex Application
- Adding Dynamic Actions to the Apex Application
- Developing an Apex Websheet
- Creating Data Grids and Links in an Apex Websheet
- Managing Database Objects from within Apex
- Building Queries of Database Objects
- Deploying an Apex Application as a Packaged Application
- Managing Apex Users and Groups
- Authorising and Authenticating Apex Users
- Administering Apex Workspaces
- Loading and Unloading Data or Application Components
- Deploying an Apex Application
Who will the Course Benefit?
The
Oracle Application Express course is aimed at Application developers, software developers, Web developers, Oracle Forms and Reports developers and technical support professionals who wish to develop interactive applications on the Web for end users.
Course Objectives
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.
Requirements
A working knowledge of SQL and a basic knowledge of PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.
Pre-Requisite Courses
Follow-On Courses
- Oracle PL/SQL Stored Program Units
- Oracle 10g SQL Performance Tuning
- Oracle 11g SQL Performance Tuning
- Java Programming
NOTE: Course technical content is subject to change without notice.
Oracle Application Express Training Course
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: INTRODUCTION TO ORACLE APPLICATION EXPRESS
- APEX Concepts
- APEX Main Components
- Workspaces, Database Applications and Websheet Applications
- Creating a Workspace
- The Workspace Administrator
- Upgrading APEX
- Logging into APEX
- Running an Application
Session 2: SQL WORKSHOP
- Use APEX to Browse, Create and Modify Objects
- Process Ad Hoc SQL Statements
- Manage Scripts in APEX
- Create, Run and Save SQL Queries
Session 3: BUILD A DATABASE APPLICATION
- Application Components
- Create an Application
- Create an Application from a Spreadsheet
Session 4: CREATE REPORTS
- Create Reports Using Wizards
- Edit Report Attributes
- Add Links to Reports
- Create a Link to a Printer-Friendly version of a Report
- Save and Print Reports in Different Formats
Session 5: PAGES AND REGIONS
- View Page Definitions
- Edit Page Definitions
- Create a Page Zero
- Create a New Region
- View Region Attributes
- Add Comments
- Add a Title
- Add a logo
Oracle Application Express Training Course
Course Contents - DAY 2
Session 6: INTRODUCTION TO SHARED COMPONENTS
- Overview of Application Express Shared Components
- Standard Tabs
- Dynamic and Static Lists of Values
- Create a Dynamic List of Values
- Create a Static List of Values
- Use a List of values to Control Data in a Report
- Create a Cascading List of Values
Session 7: CREATE FORMS
- Web Form Behaviour in APEX
- Create Forms of Different Types
- Format a Form
- Add a List of Values to a Form
- Locking in APEX Forms
Session 8: ITEMS AND BUTTONS
- Create Items
- Edit Item Attributes
- Create Buttons
- Edit Button Attributes
Session 9: PAGE PROCESSING
- Page Rendering and Page Processing
- Create Computations
- Validate Input Data
- Process Data
- Create Application Branching
Session 10: ADD SHARED NAVIGATION COMPONENTS
- Overview of Application Express Shared Components
- Parent and Standard Tabs
- Navigation Bars
- Lists
- Breadcrumbs
Oracle Application Express Training Course
Course Contents - DAY 3
Session 11: OTHER SHARED COMPONENTS
- Text Messages
- Trees
- Shared Component Reports
- User Interface Defaults
Session 12: DISPLAY DYNAMIC CONTENT
- Filter Reports with Dynamic Queries
- Create Charts with a Wizard
- Format Charts
- Create a Calendar
Session 13: 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
Session 14: Session 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
Session 15: 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
Oracle Application Express Training Course
Course Contents - DAY 4
Session 16: 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
Session 17: 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
Session 18: 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
Session 19: IMPLEMENT SECURITY
- Authentication and Authorization
- Provide an Authentication Scheme
- Create an Authorization Scheme Using Access Control
- Enable and Configure Session State Protection
Session 20: DEPLOY AN APPLICATION
- Define Supporting Objects
- Package an Application
- Export an Application
- Import an Application
- Install Supporting Objects
Session 21: UTILITY PROGRAMS
- Import and Export Data
- Generate DDL Statements
- View Objects Reports
- Monitor the Database
