Oracle APEX (Application Express) is a powerful low-code development platform designed for rapid application development. The online training courses available for APEX cater to a wide range of skill levels, from beginners to experienced developers. These courses focus on key areas such as application building, SQL and PL/SQL integration, and user interface design.Key Topics Include:Introduction to Oracle APEX: Overview of its architecture, features, and benefits.Setting Up the APEX Environment: Installation and configuration of Oracle APEX and related components.Application Development: Creating user-friendly web applications using APEX components, including forms, reports, and dashboards.Data Management: Understanding how to manage and manipulate data using SQL and PL/SQL within APEX.User Interface Design: Employing templates, themes, and custom styles to enhance application usability and aesthetics.Security Best Practices: Implementing security measures to protect applications and sensitive data.Deployment and Maintenance: Strategies for deploying applications and performing routine maintenance tasks.Learning Outcomes: By the end of this course, participants will be able to:Develop and deploy web applications using Oracle APEX.Utilize SQL and PL/SQL within APEX applications.Implement security best practices to safeguard applications.Design intuitive user interfaces that enhance user experience.Target Audience: This course is intended for software developers, database administrators, and IT professionals who are looking to leverage Oracle APEX for rapid application development.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Install Sample Data Set
Lecture 3 Workspace and Developer Tools Navigation
Section 2: Forms
Lecture 4 How to create form
Lecture 5 How to create Blank Page
Lecture 6 How to create Tree
Lecture 7 Items in APEX
Lecture 8 Master / Detail Form in APEX
Lecture 9 Modal / Non Modal
Section 3: Reports
Lecture 10 Basic Overview
Lecture 11 Interactive Report
Lecture 12 Interactive Grid
Lecture 13 Facet Search Intro
Lecture 14 Facet Chart
Section 4: ORDS
Lecture 15 RESTful Data Source
Section 5: Misc Samples
Lecture 16 Dialog Page - Modal & Non-Modal Dialog
Lecture 17 Themes & Templates
Lecture 18 Globalization - Translation
Lecture 19 Manage Static Application Files
Lecture 20 How to create Chart - Funnel Type
Lecture 21 How to create Calendar
Lecture 22 How to view Advisor
Lecture 23 How to create APEX Workspace in Autonomous DB