Oracle Apex - Web App Development

In this lecture, you'll learn to Create Table in Oracle Relational Database. 

Here, we will write code to create table, alter table to add primary key constraint, then save it as SQL script and run it to create category table with primary key.

In this tutorial, you will learn to add Auto Increment in primary key using Sequence and Trigger.

Sequence - Sequence is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

Triggers - A trigger is a named program unit that is stored in the database and fired (executed) in response to a specified event. The specified event is associated with either a table, a view, a schema, or the database.

It is executed automatically Before/After INSERT, UPDATE or DELETE.

In this tutorial, you'll create another table with auto increment and foreign key save details of products.

tbl_product has a foreign key with our first tbl_category.

Both Primary and Foreign key Constraints are added with SQL Query.

In this tutorial, you'll learn to create web application with Oracle Apex.

This episode will teach you to create your first web application in Low Code Environment of Oracle Apex (Application).

Most of the design part will be using templates provided by oracle Apex. And with few code changes you can customized the app as per your need.

In this tutorial, you will learn to create Form with Report in Oracle Apex.

Here you will learn to add functionality to Insert new data, Update or Delete existing data and display or filter the available data in database using Oracle Apex, Low Code Environment.

Form is the area where you can input the details and save in the database. Form is also used on Updating data where recent data will also be previewed.

Report is the section where the data inserted in database will be displayed in tabular form. And they can be updated or filtered or searched from this area.

In this tutorial, you'll learn to create popup form or modal in Oracle Apex.

Here, you will create a popup form or modal to insert and update data for Product module. And you'll create it with a flick of a switch (no extra code needed).

In this tutorial, you'll learn to add drop down functionality in Oracle Apex (Application).

And here you'll create List of Values (LOVs) on shared component to achieve the drop down functionality on Apex Web applications.

In this tutorial, you will learn to create master detail page in Oracle Apex (Application Express) to display or filter Products by Category.

Here, we will display both categories and products from database on a single page. And the products will be displayed based upon the category selected.

In this tutorial, you will learn to create trigger to add validation before adding or updating any products.

Here we will check whether the Expiry date is later than Manufacture Date or not. And only allow Insert or Update if the expiry date is later than manufacture date else we will display custom error message.

For this, we will create trigger which will be automatically executed whenever we try to Insert or Update on Product Module.

In this tutorial, you'll learn to add User Tracking functionality in our Apex Web App.

And here, you'll learn to Create T R I G G E R in oracle to capture user activity in our app.

This trigger will be fired/executed automatically when certain events are performed and the data will be stored in 'Logs Table' in database. Like this, we can add extra layer of security on our web application.

In this tutorial, you will learn to create beautiful charts, graphs and calendar in web Application using Oracle Apex.

Here, we will create a beautiful Pie Chart to visualize the frequency of different Actions (INSERT, UPDATE and DELETE) performed on our App.

Also, we will show the Bar Graph of Products that are low on Stock. When the qty is less than 5, it'll considered as Low Stock Products and will be displayed on Home Page Dashboard.

Finally, we will also add Calendar on our dashboard to display the products that are going to expire.

In this tutorial, you'll learn to add Custom Icon on Navigation Menu of our "Web App with Oracle Apex".

Here, you will learn to make your navigation menu beautiful and visually readable with Icons.

Thank you so much for Following the tutorials to the last. Hope if was helpful to you.

And if you think the tutorials can be helpful to others a well, then don't forget to SHARE it with your loved ones.

Download the resource file for more FREE resources.