Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Oct 17, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
Oracle Application Express Workshop II
Description: This Oracle Application Express Workshop II will help you extend your skills with Oracle Application Express. Learn to extend your applications using collections, dynamic applications and plug-ins.
Duration: 3 Days
Learn to:
- Generate Form based on Methods on Tables utility.
- Create and use RESTful Web Services.
- Customize themes and templates.
- Create a master application and custom theme.
- Migrate an existing application to a responsive theme.
- Incorporate interactivity in your application.
- Build tabs based on a static list.
- Secure your application.
- Deploy and maintain your applications.
- Optimize your application performance.
Audience:
- Project Manager
- Database Administrators
- Application Developers
- Web Administrator
- System Analysts
- Business Intelligence Developer
- Forms Developer
Course Objectives:
- Create and use RESTful Web Services
- Generate Form based on Methods on Tables utility
- Make your application accessible
- Customize themes and templates
- Incorporate Interactivity in your application
- Build tabs based on a static list
- Extend your applications using collections, dynamic applications, and plug-ins
- Secure your application
- Deploy and maintain your applications
Required Prerequisites:
- Basic knowledge of SQL, PL/SQL, and HTML
Topics: Course Overview
Course Objectives
- Lesson Schedule
- Course Environment: Products Installed
- Course Environment: Workspace Details
- Accessing the Labs Directory
Introducing and Review
- Quick Review of What You Already Know
- Packaged Application Used in this course
- Additional Resources
Using Collections
- What is a Collection?
- Create a collection on an interactive report
Generating and Using Table APIs
- What is a Table API?
- Generate a Table API
- Modify the Table API
- Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API
Extending Your Application: Dynamic Actions
- Process a Modal Window using Dynamic Actions
- Delete a Row in a Report using Dynamic Actions
Extending Your Application: Plug-ins
- Import and use region type plug-ins, such as Big Value List, CSS Bar Chart
- Optimize the performance of your plug-ins
Creating and Using RESTful Web Services
- What is a RESTful Web Service?
- Components of a RESTful Web Service
- An Example: RESTful Web Service
- Creating a new RESTful Web Service
- Consuming a RESTful Web Service in an APEX Application
Using Themes and Template
- Application Types: Desktop, Mobile, Responsive
- Theme Overview: Which ones are for which type of Application
- Review the layout of a Page template
- Using Substitution Strings in Templates
- Review a page that contains a report and review the region template and then the report template
- Create and modify a theme
- Switch to the Custom Theme
Making Your Application Accessible
- What is Web Accessibility?
- Accessibility Modes
- About VPAT
- Areas in an Application that need to be accessible
- Testing Application to identify accessibility issues
- Show an example of an accessible app and what features make it so
Incorporating Interactivity in Your Application
- Tooltip
- Scrolling Region
- Modal Region
Building Tab Drop Down as Dynamic/Static List
- Show how to create the Tab structure using a List
Securing Your Application
- What Is a Directory?
- Oracle Internet Directory
- Technical Architecture: Overview
- Authenticating Users by Using LDAP
- SQL Injection
- Cross-Site Scripting
- Application Level security
- Restricted Characters - at the item level
Deploying and Maintaining Your Application
- Application Components
- Things to consider
- Backups
Optimizing Your APEX Application
- Application Performance Considerations
- Managing Services
- Monitoring Activity
- Database Configuration Considerations
- Monitoring Application Performance
Securing Your Application
- What Is a Directory?
- Oracle Internet Directory
- Technical Architecture: Overview
- Authenticating Users by Using LDAP
- SQL Injection
- Cross-Site Scripting
- Browser Security
- Application Level Security
Deploying and Maintaining Your Application
- Application Components
- Things to consider
- Backups
Optimizing Your APEX Application
- Application Performance Considerations
- Managing Services
- Monitoring Activity
- Database Configuration Considerations
- Monitoring Application Performance
Globalization and Translation
- Understanding Application Translation and Globalization Support
- Specifying the Primary Language for an ApplicationLoading a New Language
- Translating an Application
- Translating the Data the Application Uses
- Localization
- Switching Languages