Introduction to Oracle APEX Training (APEX101)
The Introduction to Oracle APEX course is designed for individuals looking to gain comprehensive knowledge of Oracle Application Express (APEX). This course covers the fundamental concepts and practical applications of APEX, providing students with the skills needed to build and deploy robust web applications using Oracle's low-code development platform. The course is suitable for beginners with no prior experience in Oracle APEX as well as those with basic knowledge looking to deepen their understanding. Through a combination of theoretical lessons and hands-on exercises, participants will explore various components of APEX, including SQL Workshop, application and page design, interactive reports, forms, dynamic actions, and security features. By the end of the course, students will be equipped with the knowledge to create secure, dynamic, and efficient applications using Oracle APEX.
- Gain a solid understanding of Oracle Application Express (APEX) and its architecture.
- Learn to build and deploy web applications quickly and efficiently using APEX.
- Acquire practical experience through hands-on exercises and real-world scenarios.
- Understand the use of SQL Workshop for data manipulation and query building.
- Master the design and development of application pages and user interfaces.
- Explore dynamic actions and interactive reports to enhance application functionality.
- Develop skills in managing security, session states, and user authentication in APEX applications.
- Learn best practices for application development, deployment, and team collaboration.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
- Introduction to APEX
- What is Oracle Application Express (APEX)?
- History of APEX
- Why Use APEX?
- Architecture and Components
- Main Programming Languages in APEX
- User Roles in the APEX Ecosystem
- APEX Deployment Options
- The APEX Hierarchy
- Log in to the APEX Workspace (Exercise)
- SQL Workshop
- Components of SQL Workshop
- Query Builder
- Selecting Data from a Single Table
- Joining Tables
- Creating Queries in Query Builder from Graphical Representation (Exercise)
- Creating Queries in Query Builder from Report (Exercise)
- Applications
- App Builder Areas
- Creating An Application (Exercise)
- Options for Creating an Application
- Best Practice: Create the Oracle Data Model
- Pages
- Page Designer Overview
- Create An About Us Page (Exercise)
- Page Designer: Left Pane
- Page Designer: Right Pane
- Page Designer: Central Pane
- Breadcrumbs and Navigation
- Understanding Layout
- Designing the About Us Page (Exercise)
- Regions
- Working with Regions
- Creating Regions on a Page (Exercise)
- Classic Reports
- Classic Reports Overview
- Creating A Classic Report (Exercise)
- Classic Report Attributes
- Alternative for Creating a Classic Report Page
- Forms
- Basic Functionality of a Form
- Browsing Records in a Table
- Create a Form to Browse Employees (Exercise)
- Interactive Reports
- Features of Interactive Reports
- Create Departments Interactive Report (Exercise)
- Using Drill Downs (Exercise)
- Items
- The ABCs of Items
- Layout Properties
- Building a Dynamic Countries Form with APEX Items (Exercise)
- Dynamic Department Filtering with APEX Checkboxes (Exercise)
- Buttons and Sessions
- Button Actions
- Session State Management
- Exploring Session Management and Redirection in APEX (Exercise)
- Computations
- Application Computations vs. Page Computations
- Calculate Employee Benefits Contribution
- Create a Computation (Exercise)
- Validations
- Validations Overview
- The Sequence of Events During Page Submission
- Create Validations (Exercise)
- Processes
- Application Processes vs. Page Processes
- Page Processes
- Creating Insert and Delete Processes (Exercise)
- Branches
- Understanding Branches in Oracle APEX
- Create Departments in Country Branch (Exercise)
- Using Plug-ins
- Plug-in Basics
- Using a Plug-In (Exercise)
- Best Practice: Choose Your Plug-ins Wisely
- Calendars
- APEX Calendar Features
- Using a Calendar For Employee Hire Date (Exercise)
- Dynamic Actions
- Types of Dynamic Actions
- Creating and Using Dynamic Actions (Exercise)
- Adding Check and Uncheck All Buttons (Exercise)
- Security
- Session State Protection
- Understanding Authorization Schemes
- Hashing
- Creating Authentication and Authorization Schemes (Exercise)
- Best Practice: Build to be Secure
- Deployment
- What is Deployment?
- Deployment Strategies
- Exporting and Importing Applications
- Exporting and Importing an Application (Exercise)
- Team Development
- Team Development Overview
- Creating an Issue in Team Development (Exercise)
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Oracle Application Express (APEX) class:
- SQL
- PL/SQL
Experience in the following would be useful for this Oracle Application Express (APEX) class:
- Some Web Development experience with:
- HTML
- CSS
- JavaScript and jQuery
Courses that can help you meet these prerequisites:
Live Public Class
$2,795.00 / student
Live Private Class
- Private Class for your Team
- Live training
- Online or On-location
- Customizable
- Expert Instructors