Hi, I'm Vedant Jamdade 🎓 B.Tech CSE Student 📊 Aspiring Data Analyst
This repository is part of my journey to become a Data Analyst, where I practice and implement SQL concepts used in real-world data analysis.
The goal of this repository is to:
- Learn and practice SQL from basics to advanced
- Understand how SQL is used in data analysis
- Build strong problem-solving skills using SQL queries
- Prepare for Data Analyst internships and interviews
- SQL (MySQL)
- MySQL Workbench
- Git & GitHub
Download MySQL Installation Guide
This repository covers SQL concepts from basic to advanced levels used in data analysis:
- SQL Commands (DDL, DML, DQL)
- Data Types
- Constraints (Primary Key, Foreign Key, NOT NULL, UNIQUE)
- SELECT Statements
- WHERE Clause (Data Filtering)
- ORDER BY
- GROUP BY
- HAVING Clause
- Aggregation Functions (SUM, AVG, COUNT, MAX, MIN)
- Data Exploration Techniques
- Joins (INNER, LEFT, RIGHT)
- Subqueries
- Common Table Expressions (CTE)
- Window Functions
- Frame Clause (ROWS / RANGE)
- CASE Statements
- Set Operators (UNION, INTERSECT)
- String Functions
- Data Filtering (WHERE)
- Aggregations (SUM, AVG, COUNT)
- Joins (INNER, LEFT, RIGHT)
- Subqueries
- Window Functions
- Data Exploration Techniques
Through this repository, I have:
- Built a strong foundation in SQL
- Learned how to analyze and explore data
- Practiced real-world query scenarios
- Improved problem-solving skills
- Add real-world datasets
- Add SQL projects (Retail, Sales, E-commerce)
- Add interview-based SQL questions
⭐ If you find this repository helpful, please consider giving it a star!