Project Overview: This project demonstrates my SQL skills by analyzing IPL Data. It focuses on designing a structured database, inserting IPL-related data and performing SQL queries to extract meaningful insights about players,teams and match performance.
Objectives: Design a relatable database for IPL data. Perform SQL-based data analysis. Practice SQLconcepts such as JOINs,GROUP BY,ORDER BY,Aggregate Functions,Window Functions,CTEs,VIEWs. Generate meaningful insights from the dataset.
Database Files: schema.sql ["IPL-SQL-Analysis-Project\schema.sql"] -- Creates the database tables. data.sql ["IPL-SQL-Analysis-Project\data.sql"] -- Inserts samaple data into the tables. queries.sql ["IPL-SQL-Analysis-Project\queries.sql"] -- Contains SQL queries for Analysis.
Key SQL Concepts Used: Aggregate Functions, Joins, Window Functions , CTEs, Views,
Tools Used: MySQL (Database Management System), SQL (Structured Query Language), GitHUB (for project hosting)
Sample Insights: Identified the top run scorers. Found the highest wicket takers. Compared team-wise match wins. Analyzed player wise performance statistics. Retrieved match-related analytical information.
Screenshots: The repository includes screenshots showing important SQL queries along with their outputs.