Task-4---SQL-Data-Analysis

E-commerce dataset analysis using SQL - includes select, joins, subqueries, views, query optimization with indexes.

🧮 Task 4 – SQL Data Analysis on E-Commerce Dataset

📘 Project Overview

This project demonstrates how to extract and analyze data from an E-Commerce Dataset using MySQL Workbench.
It showcases SQL skills such as data filtering, aggregation, joining tables, subqueries, creating views, and query optimization with indexes.

---

🎯 Objectives

• Use SQL queries to extract and analyze meaningful insights from the dataset.
• Apply:
  • SELECT, WHERE, ORDER BY, GROUP BY
  • JOIN operations (INNER, LEFT, RIGHT)
  • Subqueries and aggregate functions (SUM, AVG, COUNT)
  • Views for reusable analysis
  • Query optimization using Indexes

---

🧰 Tools & Technologies

• Database: MySQL Workbench
• Dataset: E-Commerce Dataset (CSV)
• Language: SQL

---