Skip to content

Latest commit

 

History

History
17 lines (13 loc) · 1023 Bytes

README.md

File metadata and controls

17 lines (13 loc) · 1023 Bytes
Raw

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.