Oracle APEX: Complete Guide to Building Web Applications

Oracle Application Express (APEX) is a powerful, low-code development platform that enables you to build scalable web applications with robust functionality. This course, Mastering Oracle APEX: Comprehensive Guide to Building Web Applications, is designed to take you from the basics to advanced concepts, empowering you to create dynamic, data-driven applications. Whether you're a beginner or a seasoned developer, this course covers all essential aspects of Oracle APEX, from installation to advanced development techniques, providing you with the skills to excel in modern web development.

Section 1: Introduction to Oracle Application Express

This introductory section covers the basics of Oracle APEX. It starts with a general overview of what Oracle APEX is, its features, and how it simplifies the process of web application development. You will gain a foundational understanding of the platform and how it fits into the Oracle ecosystem.

• Lecture 1: General Introduction (Preview enabled)

Section 2: Pre-Installation Tasks

Before diving into the development, it's crucial to set up your Oracle APEX environment correctly. This section covers the pre-installation steps, including understanding the role of the web listener, various listener options, and the overall architecture of Oracle APEX. It also guides you through installation and essential maintenance tasks.

• Lecture 2: Pre-Installation Tasks and Role of the Web Listener

• Lecture 3: Listener Options, Architecture, Associated Roles

• Lecture 4: General Maintenance

• Lecture 5: Installation

• Lecture 6: Post Installation Tasks

Section 3: Installing Oracle REST Data Services (ORDS)

Oracle REST Data Services (ORDS) is essential for enabling RESTful web services in APEX. This section walks you through the installation and configuration of ORDS, allowing you to integrate RESTful services seamlessly with your APEX applications.

• Lecture 7: Installing ORDS - Part 1

• Lecture 8: Installing ORDS - Part 2

• Lecture 9: Configuring RESTful Services with APEX

Section 4: Getting Started with Oracle APEX

Learn how to get started with Oracle APEX by logging in, creating workspaces, and managing user roles. This section is crucial for beginners as it lays the foundation for application development within Oracle APEX.

• Lecture 10: Logging In

• Lecture 11: Creating Workspace

• Lecture 12: Creating Additional Workspaces, Developers, and User Roles

• Lecture 13: Logging in as Workspace Administrator and Developer

Section 5: Data Applications

In this section, you'll explore the core functionality of Oracle APEX by comparing Database Applications with Websheet Applications. You'll learn how to use the Create Application Wizard, manage user interfaces, and perform application management tasks.

• Lecture 14: Comparing Database Application with Websheet Application

• Lecture 15: Create Application Wizard - Overview

• Lecture 16: Deleting Applications, Managing UI, and Page Management

Section 6: Creating Form Pages & Report Pages

Discover how to create dynamic form and report pages within Oracle APEX. You'll get hands-on experience in creating form pages for data entry and report pages for data visualization using the classic style.

• Lecture 17: Creating a Form Page and Entering Data

• Lecture 18: Creating a Form Page - Continued

• Lecture 19: Creating a Report Page in Classic Style

Section 7: Shared Components

Shared components in Oracle APEX allow you to reuse elements across different applications. This section covers managing authentication schemes, globalization attributes, application utilities, and debugging techniques to enhance the functionality of your applications.

• Lecture 20: Shared Components - Removing Tabs

• Lecture 21: Managing Authentication Schemes

• Lecture 22: Globalization Attributes and Shared Components

• Lecture 23: Using the Find Icon and Managing Developer Comments

• Lecture 24: Application Utilities - Part 1

• Lecture 25: Application Utilities - Part 2

• Lecture 26: Managing Application Groups

• Lecture 27: Creating Websheet Applications as a Workspace Administrator

• Lecture 28: Exploring Packaged Applications

• Lecture 29: Packaged Applications - Continued

• Lecture 30: Debugging an Application

Conclusion:

By the end of this course, you will have a solid grasp of Oracle APEX and the skills needed to build and deploy robust web applications. You'll be capable of managing the full application lifecycle, from installation and configuration to advanced development and deployment. This course is designed to provide practical, hands-on experience that will equip you to leverage Oracle APEX for your web development needs.