Oracle Application Express: Developing Web Applications
Duration : 5 Days (40 Hours)
Oracle Application Express: Developing Web Applications Course Overview:
Oracle Application Express (APEX) is a web-based application development tool that enables developers to rapidly create, deploy, and manage business-critical web applications. It serves as a low-code platform, streamlining web application development and automating database management, leading to the creation of secure, robust, and feature-rich web applications.
The course titled “Oracle Application Express: Developing Web Applications” provides an introduction to current web technologies and focuses on utilizing APEX for building database-driven web applications. Through a combination of lectures and hands-on exercises, students gain the skills necessary to efficiently develop such applications.
Key topics covered in the course include application design, page creation, form processing, dynamic and interactive components, web services, and best practices. Additionally, students learn how to employ interactive reports and charts for effective data interaction.
Intended Audience:
- Web Developers
- Database Administrators
- Software Engineers
- IT Professionals
- Application Developers
- Business Analysts
- Database Developers
- IT Managers
- Software Development Teams
- Students and Enthusiasts
Learning Objectives of Oracle Application Express: Developing Web Applications:
1. Learn how to design, develop and deploy web applications using Oracle Application Express.
2. Acquire knowledge of SQL, PL/SQL and basic database concepts.
3. Understand the component-based architecture of Oracle Application Express.
4. Learn to secure and manage the web applications created.
5. Develop web-enabled database applications for deploying online.
6. Enhance the functionality of the applications using plugins & themes.
7. Manage, customize and format the data using reports and charts.
8. Handle different types of user interaction with the applications.
9. Use data validation, form processing, processes and authentication.
10. Optimize performance and integration of the applications.
Module 1: Maintaining Database Objects Using SQL Workshop
- Browse, create and modify database objects using Object browser
- Execute SQL scripts using SQL Command and SQL Scripts
- Build and save SQL queries using Query Builder
- Import and export data using Utilities
Module 2: Building Database Applications
- Discuss the difference between a Database Application and a Websheet Application
- Identify the components of a database application
- Create a database application from scratch
- Create a database application from a spreadsheet
Module 3: Creating Reports
- Identify the types of reports you can create
- Create, manipulate and customize interactive reports
- Create and modify classic and wizard reports
Module 4: Creating Forms
- Identify the types of reports you can create
- Create, manipulate and customize interactive reports
- Create and modify classic and wizard reports
Module 5: Working with Pages and Regions
- View and edit page definitions and attributes
- Create and modify a region and subregion
- Create a Page Zero
- Add page groups and comments
Module 6: Adding Items and Buttons
- Identify different types of items
- Create items and edit item attributes
- Create and use List of Values
- Create buttons and edit button attributes
Module 7: Understanding Session State and Debugging
- Explain how APEX uses session state
- View, reference and clear session state values
- Review messages in debug mode
Module 8: Including Page Processing
- Explain the difference between page rendering and page processing
- Create computations in application pages
- Create page processes
- Create validations to verify user input
- Create branches within a application
Module 9: Building a Websheet Application
- Create a Websheet Application
- Add a Page to a Websheet Application
- Add and manipulate a Data Grid and Report
- Add Annotations to a Data Grid
- Create a Saved Report of a Data Grid
- Add Sections to a Page
- Share Websheets using an Access Control List
Module 10: Using Application and Page Utilities
- Use the Advisor to verify your application
- Manage defaults using the Attribute Dictionary
Module 11: Adding Shared Components that Aid Navigation
- Explain the use of shared components in an application
- Create and edit tabs, navigation bar entries, lists and breadcrumbs
Module 12: Displaying Dynamic Content
- Create and use a dynamic action
- Import and use a plugin
- Create and modify a chart
- Create a calendar
- Create a tree
Module 13: Working with Themes, Templates, and Files
- Explain what themes and templates are
- Create a new theme from the repository and switch to the theme to make current
- Create and edit a template
- Upload and use a Cascading Style Sheet and an image
Module 14: Administering Application Express Workspaces
- Create a developer and a workspace administrator user
- Request a schema or a storage
- Monitor the developer activity log
Module 15: Implementing Security
- List the different ways to secure your application
- Differentiate between authentication and authorization
- Create an authentication scheme for your application
- Create an authorization scheme using Access Control
- Enable and configure Session State Protection
Module 16: Deploying Your Application
- Identify the supporting objects for your application
- Export an application and its supporting objects
- Import an application
- Install the supporting objects
Module 17: Managing and Maintaining the Application Development Process
- Track Features, Milestones, Bugs and To Dos
- Track Features, Milestones, Bugs and To Dos
Oracle Application Express: Developing Web Applications Course Prerequisites:
There are no specific prerequisites for taking the Oracle Application Express: Developing Web Applications Training course, but the student should have a basic understanding of database concepts and hands-on experience developing in SQL and PL/SQL.
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
