Oracle APEX with SQL and PL/SQL
A 24-module Oracle APEX learning path covering SQL, PL/SQL, application building, security, dynamic actions, workflows and REST-enabled applications.
What This Course Covers
A 24-module Oracle APEX learning path covering SQL, PL/SQL, application building, security, dynamic actions, workflows and REST-enabled applications.
Who Should Attend
Contact Tech Arryaan for audience guidance based on your current experience and the role or technology path you want to pursue.
Prerequisites
Contact our team for prerequisite guidance based on your current experience. Our team can help you choose a suitable starting point.
Approved Source Material
This course page is structured from the supplied Oracle APEX with SQL and PL_SQL Course Content.pdf.
Approved Course Syllabus
Expand each section below to review the approved modules, weeks, projects and learning areas supplied by Tech Arryaan.
- Understand SQL Basics
- Use SQL Commands and SQL Scripts
- Generate SQL by Using Quick SQL
- Database CRUD (Create, Read, Update, Delete) Functionality
- Database Objects – Table, Sequence, Trigger
- PLSQL Programming Fundamentals
- PLSQL Functions
- PLSQL Packages
- PLSQL Procedures
- What is Oracle APEX?
- Introduction to Oracle Autonomous Database
- Understand Low Code Application Development
- Oracle APEX Availability and Architecture
- Oracle APEX Use Cases
- Provisioning an APEX Workspace
- APEX History and Product Components
- Oracle APEX Architecture in Detail
- Previewing Out-of-the-Box Apps Provided by Oracle
- Installing a Sample APEX Application
- App Builder Concepts
- App Builder and the Create App Wizard
- Application Based on Existing Tables
- Create an Application from a File
- Object Browser
- Use SQL Commands and SQL Scripts
- Generate SQL by Using Quick SQL
- Usage of PL/SQL in APEX Apps
- Build Sample Datasets
- Purpose of Team Development
- Understand Labels, Milestones, and Templates
- Create and Manage Issues
- Team Development Utilities
- Create Oracle APEX Users
- Types of Oracle APEX Users and Access Control
- Introduction to Point of Sale (POS) App Design
- Design and Set Up Data Model for POS App
- Build Complex APEX Pages to Manage Sales at Store
- Add Administration Features Using APEX Components
- Build Pages to Manage Sales
- Build Pages to Add and Manage Customers
- Build Dashboard Page to Display Stock and Other Details
- Create and Manage List of Values
- Create and Customize Buttons
- Introduction to Expense Tracker App Design
- Design and Set Up Data Model
- Build Page to Add Expenses
- Build Page to Display Transactions
- Create Form and Report on the Same Page
- Reset Form After CRUD Operations
- File Upload in Oracle APEX
- File Download in Oracle APEX
- Restrict File Upload Based on File Type and Size
- Custom Authentication Schemes
- Oracle APEX Account Authentication
- Authorization Schemes
- Access Control Administration Page
- User Authorization and Access Control
- Introduction to POS Purchaser App
- Design Application and Set Up Data Model
- Introduction to Security and Authentication
- Parent-Child Relationship Regions Design
- Add Products and Fetch Details Dynamically
- Use APEX Collections for Runtime Data Storage
- Delete Data from APEX Collections
- Custom Interactive Grid Actions and Buttons
- Apply Custom CSS to Highlight Report Columns
- Interactive Grid Customizations
- Page Rendering and Processing
- Manage APEX Computations
- Create and Manage Page Processes
- Build and Manage Validations
- Understand Validations and Branches
- Understanding Dynamic Actions
- Enable/Disable Items
- Set Item Values Dynamically
- Filter and Refresh Reports
- Understand Dynamic Forms
- Create Dynamic Forms Using SQL
- Use Various Input Types
- Create and Customize Themes
- Use Redwood Theme
- Create and Use Plugins
- Understand Application Workflow
- Set Up Data Model and Load Data
- Build Leave Application Pages
- Create and Manage Automations
- Manage Approvals
- Create Task Definitions
- Understand Roles (Employee, Manager, Admin)
- Track Tasks Created by User
- Approve Tasks as Manager
- Approve Tasks as Admin
- End-to-End Testing of Application
- Test Fusion REST APIs Using Postman
- Create REST Data Sources (Part 1 & 2)
- Create Interactive Reports for Suppliers
- Create Forms for Supplier Details
- Use REST APIs in PL/SQL
- Parse API Responses in PL/SQL
- Oracle APEX Certification Guidance
- Resume Preparation Support
- Interview Questions and Preparation
Training Information
Training Mode
Confirmed based on the current offering.
Duration
Contact our team for current details.
Batch Timing / Next Batch / Trainer
Contact our team for current details.
Practical Learning
Projects, assignments, practical scenarios and capstone items are shown inside the approved syllabus wherever the source document includes them.
Course Enquiry
Tell us the technology, your current experience, preferred training mode and schedule.
