SQL CRUD App Demo

Introduction

I’ve created a simple CRUD SQL demo app using SQLite3 to demonstrate SQL queries. This data is based on my experience as a business and data analyst in India, although it has been significantly altered for demonstration purposes.

App Overview

The app, built using Python’s Streamlit library, allows users to perform basic CRUD (Create, Read, Update, Delete) operations on two datasets: one from Flipkart and one from Amazon. It provides an interactive interface for viewing, searching, updating, and deleting data, along with the SQL queries used.

Key Features

Home Page

Overview of the app and its capabilities.

Visit the Home Page

Select Operation

Perform select queries to fetch specific data. Learn how to use SELECT statements to retrieve data from a database.

Insert Operation

Add new records to the database. Understand how to use INSERT INTO statements to add data.

Update Operation

Update existing records in the database. Explore UPDATE statements to modify existing data.

Delete Operation

Delete records from the database. Use DELETE FROM statements to remove data.

Join Operations

Perform various join operations like Inner Join, Left Join, Right Join, and Full Join. Learn the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN and how they combine data from multiple tables.

Search and Filter

Search and filter records using specific criteria. Use WHERE clauses and other filtering techniques to find specific data.

Aggregation Operations

Perform aggregation operations to summarize data. Utilize functions like SUM(), AVG(), COUNT(), MIN(), and MAX() to aggregate data.

Conclusion

This SQL CRUD app serves as a practical demonstration of how to perform basic SQL operations using a user-friendly interface. It is a valuable tool for anyone looking to learn or teach SQL in an interactive and engaging manner.

If you have any questions or need further assistance, feel free to contact me.