
Oracle Application Express (APEX) is a no-code low-code web application development platform that allows developers to build scalable, secure, and data-driven web applications quickly. In this introductory lecture, you will get an overview of the course in which you will learn Oracle APEX from scratch.
This lecture provides the architectural elements and anatomy of Oracle APEX.
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.
Unlock the power of Oracle APEX 23 with this comprehensive course designed for beginners! Dive into the world of low-code development and rapidly build scalable web applications without the need for extensive coding knowledge. Whether you're a novice or looking to enhance your skills, this course covers the fundamentals of Oracle APEX, guiding you through hands-on projects and real-world scenarios.
What sets this course apart? Upon completion, you'll receive an exclusive bonus: access to 100+ next-level lectures, carefully crafted to deepen your understanding and elevate your proficiency. Take your expertise to new heights as you explore advanced techniques, best practices, and intricate APEX functionalities.
Key Highlights:
- Beginner-friendly approach to Oracle APEX 23.
- Step-by-step guidance through practical projects.
- Learn to create dynamic, data-driven web applications effortlessly.
- Unlock the potential of low-code development for your projects.
But that's not all! Enroll now, and secure your place in a community of learners who gain not only the core knowledge but also an invaluable bonus—100+ advanced lectures for continuous growth.
The course goes beyond the basics, aiming to transform you into an adept enterprise-grade web application developer swiftly and effectively using Oracle Application Express (APEX). With a focused curriculum, I prioritize hands-on experience, guiding you through the creation of robust, scalable applications. My objective is to equip you with the skills needed to tackle real-world challenges, empowering you to contribute meaningfully to web development projects and propel your career forward. By the end of this course, you'll not only master the essentials of Oracle APEX but also possess the confidence and proficiency to excel in the dynamic landscape of enterprise-level web application development. Join me on this transformative journey, and let's elevate your skills together!