Welcome to my SQL learning repository.
This repo contains all my SQL notes, day-wise learning files, practice exercises, concepts, and analysis tasks.
I use this space to track my daily progress and strengthen my SQL fundamentals.
This repository is dedicated only to SQL.
(Python, Power BI, and other tools will be stored in separate repositories.)
- Day-wise SQL learning notes
- SQL practice files (.sql)
- ERD diagrams & schema understanding
- Important SQL concepts with examples
- Real data analysis queries
- Mini SQL tasks & exercises
- Links to SQL projects
This repo helps me revise and track everything I learn in SQL.
- SELECT, WHERE, ORDER BY
- DISTINCT, LIMIT
- COUNT, SUM, AVG, MAX, MIN
- GROUP BY & HAVING
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Multi-table joins
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK)
- INSERT
- UPDATE
- DELETE
- Subqueries
- Common Table Expressions (CTE)
- Window Functions → RANK, DENSE_RANK, ROW_NUMBER
- Views & schema understanding
A complete SQL analysis project based on the Chinook Music Store database.
Includes joins, CTEs, window functions, and real business insights.
Project Link:
https://github.com/AmanVishwakarma-Data/SQL-Music-Store-Analysis
More SQL projects coming soon…
This repo works as my SQL learning journal, where I:
- Practice SQL every day
- Keep all notes organized
- Track my growth from beginner → intermediate
- Strengthen concepts through real queries
- Prepare myself for Data Analyst roles
It keeps my learning journey clear and consistent.
GitHub: AmanVishwakarma-Data