Oracle Application Express Workshop I Ed 3
Duration : 5 Days (40 Hours)
Overview
Course Details
Prerequisites
Oracle Application Express Workshop I Ed 3 Course Overview:
The Oracle Application Express Workshop I Ed 2 training course provides participants with the knowledge and skills to develop database-centric web applications using Oracle Application Express (APEX) efficiently and effectively. The course covers various aspects, including:
- Creating web applications using Oracle APEX, emphasizing speed and efficiency in development.
- Implementing security measures in the applications to ensure data protection and prevent unauthorized access.
- Managing navigation within the applications, enhancing user experience and ease of use.
- Applying basic validation techniques to ensure data integrity and accuracy.
- Learning debugging techniques to identify and resolve issues in the application development process.
Intended Audience:
- Application Developers
- Business Intelligence Developer
- Database Administrators
- Forms Developer
- System Analysts & Web Administrator
Learning Objectives of Oracle Application Express Workshop I Ed 3:
- Create database applications using desktop and mobile interfaces
- Enhance the application with components like forms, dynamic actions, calendars, charts, plug-ins
Module 1: Course Overview
- Course Goals
- Course Outline
- Order Management Database Application (OMDA)
- Introducing Course Persona: Jack
- Course Environment: Products Installed
- Course Environment: Workspace Details
- Accessing the Labs Directory
Module 2: Introducing Oracle Application Express
- Application Express Overview
- Application Express Terms and Concepts
- Using Application Express
Module 3: Creating a Desktop and Mobile Database Application
- Application Builder Overview
- Introducing Database Applications
- Creating Database Applications
- Creating Mobile Application
Module 4: Working with Reports for Desktop Application
- Introducing Reports
- Using Classic Reports
- Using Interactive Reports
- Creating and Customizing an Interactive Report
Module 5: Working with Reports for Mobile Application
- Creating Reports for a Mobile Application
- Creating Column Toggle Report
- Creating a Reflow Report
Module 6: Creating Forms
- Using Forms
- Creating Forms
- Modifying Forms
- Creating a Form in a Mobile Application
Module 7: Working with Pages and Regions
- Introducing Page Definition
- Working with Page Regions
- Working with Pages
Module 8: Adding Items and Buttons
- Introducing Items
- Using Items
- Creating List of Value (LOV) Type of Items
- Using Buttons
Module 9: Understanding Session State
- Understanding Session State in Oracle Application Express
- Using Session State in Oracle Application Express
Module 10: Including Page Processing
- Introducing Page Processing
- Including Computations
- Including Processes
- Including Validations
- Including Branches
Module 11: Validating and Debugging Your Application
- Using the Advisor
- Managing Your Attribute Dictionary
- Debugging Your Application
Module 12: Adding Shared Components That Aid Navigation
- Introducing Shared Components
- Creating Tabs
- Creating Lists
- Creating Breadcrumbs
- Creating a Navigational Bar
Module 13: Working with Themes, Templates and Files
- Using Themes
- Using Templates
- Using Files
Module 14: Implementing Security
- Securing an Application
- Using Authentication Schemes
- Using Authorization Schemes
- Using Session State Protection
Module 15: Managing Application Navigation
- Building a Hierarchical List with Images
- Building a Site Map
- Enforcing Authorization on Your Site Map
- Linking Interactive Reports using a Declarative Filter
Module 16: Extending Your Application
- Creating Data Load Wizard Pages
- Creating an Upload and Download Page
- Adding BLOB Data to an Existing Application
- Sending Email from an Application
Module 17: Creating and Editing Charts
- Creating and Using Charts
- Enhanced Charting Examples
Module 18: Adding Calendars and Trees
- Using Calendars
- Using Trees
Module 19: Using Dynamic Actions and Plug-Ins
- Using Dynamic Actions
- Using Plug-Ins
Module 20: Utilizing Application Express Printing
- Printing a Standard Report with Derived Output
- Creating a PDF Report with Multiple Queries
Module 21: Managing Application Feedback
- What is Team Development?
- Managing Feedback
Oracle Application Express Workshop I Ed 3 Course Prerequisites:
Basic knowledge of SQL, PL/SQL, and HTML
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
