SQL Portfolio – WSDA Music Dataset

This repository showcases my SQL practice and projects using the WSDA Music dataset, built while learning from LinkedIn Learning. It demonstrates practical skills in querying, joining, aggregating, and analyzing relational data with SQLite.

🔧 Skills Demonstrated

• Core SQL: SELECT, WHERE, ORDER BY, LIMIT
• Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN
• Aggregations: GROUP BY, HAVING, COUNT, SUM, AVG, MIN, MAX
• Subqueries and filtering
• Database schema exploration in SQLite

📂 Repository Structure

SQL-Portfolio-WSDA-Music/
├── README.md
├── WSDA_Music_Queries.db
├── WSDA_Music_Queries.sqbpro

▶️ How to Use

1. Install SQLite.
2. Clone the repo:

   git clone https://github.com/Hasnainali19/SQL-Portfolio-WSDA-Music.git
   cd SQL-Portfolio-WSDA-Music

3. Open the database:

   sqlite3 WSDA_Music_Queries.db

4. Run queries for example:

   .read WSDA_Music_Queries.sqbpro

📝 Notes

• The .sqbpro file contains saved workspace/tabs from DB Browser for SQLite.

Author: Hasnainali Saiyed