Project Overview

In this project, I explored a songs dataset using MySQL, creating a comprehensive database with tables for albums and bands. After populating these tables, I performed detailed analysis using SQL queries, including ORDER BY, GROUP BY, joins, and wildcards, to derive insights crucial for decision-making and refine my problem-solving skills.

Tools and Methodology

Tools

• 📊 MySQL: For database creation and data manipulation.
• 🗂️ SQL Queries: To analyze data using various functions and commands.
• 💻 SQL Workbench: For executing and managing SQL queries.
• 📈 Data Visualization Tools: To present derived insights effectively.

Methodology

• 📥 Data Import: Loaded songs dataset into MySQL.
• 🗂️ Database Creation: Created tables for albums and bands.
• 📊 Data Analysis: Used SQL queries to analyze and derive insights.
• 🧩 Query Techniques: Implemented ORDER BY, GROUP BY, joins, and wildcards for refined problem-solving.