Creating a Grocery Shopping List Application with SQL

---

Building an application includes the integration of numerous functions. In this article, we will walk through the procedure of creating a grocery shopping list application utilizing the power of SQL. When we talk about creating an application, it mainly includes Database creation, Table formation, Inserting values, Updating those values, and deleting some. We’ll cover how to use SQL to implement these functions in the grocery shopping list application.

Grocery Database

Before we go into the details of creating tables, let’s first establish our database. We’ll be using the CREATE DATABASE statement for this purpose:

Creating The Table

We’ll need a table to hold our grocery list. We’ll create it with specific columns- ItemName, Quantity, and Price. Here is how we create our table using the CREATE TABLE statement:

Inserting Values

Now that our table is created, we can begin populating it with some data. Let’s add an entry for apples into our GroceryList table:

Updating The List

Updating data is a common operation in any application. In our case, we can increase the quantity of the apples in our grocery list from 1 to 2. Here’s how we’ll use the UPDATE statement to accomplish that:

Deleting from the list

At times, we’ll need to remove items from our list. Suppose we’ve decided against getting apples, here’s how we can remove them from our list:

Conclusion

Applications can vary considerably in size and complexity. Regardless, the core operations you’ll carry out on your data will largely be the same. By mastering these SQL statements, you’ll have a good foundation to build any size application.