Oracle APEX Fast Lane: From Novice to Pro in Weeks

Request a free workspace on Oracle APEX server to execute the exercises provided in this course.

In this lecture, you will create the barebones of your application with some default pages. You will add more pages to the application in subsequent lectures.

In this lecture, you will create tables, sequences, and triggers for the application. You will also upload data from CSV files to these tables using data load utility.

In this lecture, we will talk about shared components. Shared components are application structures used in application pages. These structures are called shared components because you create them once and utilize them across all the pages in the application.

This lecture will provide you with a hands-on overview of the interactive grid, which is a matrix report and can also be used simultaneously as a data manipulation tool. Besides, an input form will be created on top of the interactive grid to manage customers' data. This lecture will demonstrate how Apex transparently manages DML and DQL operations.

This lecture will teach you the use of interactive reports with different views of data. Most importantly, you will be guided on how to handle images and other digitized information in your Apex applications.

In this lecture, you will learn how to create and manage customers' orders using the master detail page option of Oracle Apex. Here, you will learn the techniques to customize the wizard-generated pages.

The actions menu is available in the interactive report and interactive grid and it allows end users to create custom reports. Using this handy tool, you can select and deselect report columns, filter and sort data, apply highlight and control breaks, create chart and pivot views, and more.

In this lecture, you will learn how to transform a blank Oracle Apex page into an executive dashboard. For this purpose, you will add multiple regions on the page and will arrange these regions with the help of 12 columns grid layout of Oracle Apex.

In the next lecture, you will use different chart types available in Oracle Apex to present data graphically. But prior to creating the charts, you will create a page that will list all the graphical reports you will create in the next lecture. When you click the reports option in the main navigation menu, you will see this page displaying all available graphical reports.

In this lecture, you will create an animated bar chart with horizontal, vertical, stack, and unstack animations.

In this lecture, you will display summarized information with the help of donut and range charts.

In this lecture, you will create two charts - a line with area chart and a bar chart. You will display these two charts using a region display selector.

Calendar is a very handy tool of Oracle Apex, especially for managing events. To help you understand this tool, in this lecture, we will be using it to display data from the orders master table.

In this lecture, you will be guided on how to create a hierarchical view of related data.

In this lecture, you will add search functionality to your application by adding a faceted search page that will allow end users to apply multiple filters to narrow the data and get the desired report.

In this lecture, you will set up Oracle Apex locally on your own computer with Oracle Rest Data Services under Oracle database 21c Express Edition. This installation will deploy Oracle Rest Data Services on Apache Tomcat server. The purpose of this local setup is to test application deployment and to create an environment for generating advanced reports using the JasperReports server.

In this lecture, you will learn how applications are deployed from a test environment to a production server. You can easily migrate your applications and data from one Apex instance to another using the data package utility in which you specify the tables for which the data gets exported with an application.

In this lecture, you will install and configure JasperReports on your local computer for advanced reporting. After this, you will create an invoice report and then you will integrate it with Oracle Apex.

In this final lecture, you will learn how to manage your application security using the built-in authorization features provided in Oracle Apex. The application access feature of Oracle Apex allows you to set privileges for your application. This way you can ensure that only authorized people can access your applications, menus, pages, and page components.

During this lecture, we will explore the world of real-time communication through Apex push notifications, creating a smooth and interactive experience for users of Apex applications, whether on desktop or mobile devices. These notifications significantly enhance your end user's experience by providing immediate updates and alerts, even when they are not actively using the application.

In this lecture, we'll delve into the process of retrieving your device's location and explore the seamless integration of Google Maps into your Apex application through the utilization of an API key.

In this quick session, we will discover the exciting features of the Oracle APEX Combo Box Page Item. Learn how it enhances user interaction, offers customization options, and brings a fresh look to your applications. Elevate your skills with this easy-to-follow exploration of the Combo Box's capabilities.