Product Components
Start course

This course provides an introduction to the Oracle APEX service, exploring its key features, architecture, and deployment options.

Learning Objectives

  • Obtain a foundational understanding of low-code application development
  • Learn the key features and characteristics of Oracle APEX
  • Understand the various environments where Oracle APEX is available
  • Learn about Autonomous Database
  • Learn about Oracle APEX architecture as well as all Oracle APEX deployment options

Intended Audience

  • Anyone who wants to enhance their knowledge of Oracle APEX


We recommend that you take this course as part of our Oracle APEX: Foundations learning path.


Hello, welcome to Oracle APEX Foundations course. Getting Started with Oracle APEX Module; Oracle Apex Product Components Lesson. My name is Chaitanya. I am a product manager on the Oracle APEX Product Development team. Now that you have provisioned an Oracle APEX Workspace, let's go ahead and see what are the key components of Oracle APEX. This lesson covers Oracle Apex product components. You are introduced to App Builder, SQL Workshop, Team Development, and Gallery. Once you sign into your APEX Workspace, the Workspace home page appears. Now, remember, a Workspace is a Virtual Private Database which enables multiple users to work within the same Apex installation while keeping their objects, data, and applications private. Each Apex development instance can contain such multiple workspaces. On the workspace homepage you see key development components such as App Builder, SQL Workshop, Team Development, and Gallery. You use App Builder to create an application which is composed of a set of HTML pages and based on database objects.

You use SQL workshop to access tools for viewing and managing database objects. Team development is used to track and manage issues in a conversational fashion. And now finally, Gallery enables you to access to starter applications, sample applications available in the Oracle Apex GitHub repository. Now, let's click App Builder. You use App Builder to create and manage applications and application pages. App Builder enables you to design, develop, and deploy applications which are beautiful and responsive. The App Builder homepage displays all installed applications in the current Apex instance. When you select an application to edit, the application homepage appears. You use the application homepage to run the application, edit, import, export, copy, or delete application. Select a page to edit the page properties, or you can click 'Create Page' to add a new page to the application. Now, let's view the next component, SQL Workshop. SQL Workshop provides tools that enable you to view and manage database objects. Let's click "Object Browser". Object Browser enables you to use a tree control, to use object properties, and create new objects. Let's navigate to SQL commands.

SQL Commands tool enables you to enter Ad Hoc SQL. Let's navigate to SQL scripts. SQL scripts enables you to store and run scripts. Let's now navigate to 'Utilities'. Utilities for example, includes Data Workshop. Data Workshop enables you to load and unload text, DDL and spreadsheet data. You also see their query builder, which enables you to create join queries using drag and drop. Now, let's navigate to the next component- Team Development. Team development is used to track and manage issues in a conversational fashion. You can create templates to provide users with some starter text for issues and comments. You can apply labels and label groups, assign issue owners, and set milestones. And now finally, lets navigate to 'Gallery'. The gallery includes 3 types of applications, sample apps, starter apps, and custom apps. Sample apps are built with sample data that highlight specific functionality. You can use the sample applications as a developer guide for how a particular feature would work. And then starter applications.

Starter applications are fully functional applications that provide stand alone solutions for simple requirements. You can use these applications as is or extend them with custom functionality. And then finally 'Custom ads'. Custom ads are specific to your workspace. They are only available if your instance administrator has enabled them. You can install sample applications, starter applications, and custom applications, directly from the gallery. You can also download sample applications and starter applications from GitHub to import into your workspace. This lesson covered Oracle Apex product components. You were introduced to App Builder, SQL Workshop, Team Development, and Gallery. This concludes the lesson on Oracle APEX product components. I hope you find that useful. Thank you so much for watching.

About the Author
Oracle University
Training Provider
Learning Paths

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.

Covered Topics