Music Store Analysis Project : SQL

SQL project to analyze online music store data

This project is for beginners and will teach you how to analyze the music store database. You can examine the dataset with SQL and help the store understand its business growth by answering simple questions.

Database & Tools

The Project is implemented through MySQL Workbench with SQL queries primarily written in MySQL.

Schema

Implementation

1. Design the Database and respective table as per the database schema, make sure to sure to the point datatypes for representing different attributes.
2. Populate the table Either using INSERT Clause or by Import data wizard and import data through CSV's.
3. Now Explore the data by leveraging different techniques like multi table JOINs Statement, Window Functions, CTEs and other useful clauses.
4. You can create your own set of questions or use this PDF for the reference.

Rules for Contribution

1. Identify real world scenario that need to be answered through this dataset and mold it in a statement.
2. Now write the SQL query.
3. Open a PR.

P.S. Abstain from using too simple queries.