Player: It has Players’ names, height, weight, birth date, FIFA ID, and API ID. The information is specified using the unique ids of the other three tables: Country, League, and Team. Match: It contains performance metrics of various players for different league matches. League: It contains the specific titles of the sports events/league matches. It contains the following tables:Ĭountry: It contains the list of countries where the games are played and their unique ids.
#Practice it gitup download
This SQL project will guide you through the application of the query language for understanding the dataset at an aggregated level.ĭataset: Download this European Soccer Game Dataset from Kaggle. If you are a soccer fan and enjoy analyzing trends in sports teams, this SQL project for practice is for you. Get FREE Access to Data Analytics Example Codes for Data Cleaning, Data Munging, and Data Visualization 2.
How was the weather during the year of highest sales?Ĭonclude whether the weather has an essential impact on sales.ĭo the sales always rise near the holiday season for all the years?Īnalyze the relationship between sales and the different macroeconomic variables in the dataset. to answer the following sample questions: After that, use SQL commands like order by, group by, etc. SQL Project Idea: You can use the dataset to create an online retail application database in SQL. You will also have weather and holiday data. It also includes macroeconomic parameters like GDP, CPI, cotton production, unemployment rate, etc. The dataset contains Walmart store sales (Year, Month, Product Category, and Sales) for 2009-2014. Data Analysts use SQL to build an inventory management system to help business owners make critical decisions related to inventory planning.ĭataset: As an example, you can use this Walmart Dataset on Kaggle. Inventory Control Management Database Projectįor any product-based business, keeping track of all the items in their inventory is critical. These project ideas for beginners are simple and will help you quickly learn the basics of SQL.ġ.
#Practice it gitup code
You will also find a few SQL projects with source code towards the end of this blog.īelow is a list of beginner SQL projects for freshers or newbies in SQL. You can use these SQL projects for data analysis and add them to your data analyst portfolio. Hoping the example above has fueled you with the zeal to enhance your programming skills in SQL, we present you with an exciting list of SQL projects for practice.
0 kommentar(er)
