Learn SQL quickly with the help of these 5 projects which will cover all types of datasets and you will get various industrial data knowledge.
SQL for Data Analyst
5 SQL projects to build your strong #dataanalytics #datascientist portfolio today 🎯.
1. European Soccer Game Analysis
Tech Stack: SQL
what you learn:
ORDER BY, GROUP BY, and LIMIT, Joins, Aggregate functions
Dataset link: https://lnkd.in/gFa_E2XA
2. Analyzing Road Safety in the UK
Tech stack: SQL, python
what you learn:
Aggregate functions, CREATE, indexing, subqueries
Repository Link: https://lnkd.in/dbEAKY2G
3. International Debt Statistics Analysis
Tech stack: SQL, postgreSQL
what you learn:
DISTINCT, COUNT, SUM, ROUND, MAX, MIN, GROUP BY
Repository Link: https://lnkd.in/g5VgYEaS
4. Analyzing the World Population
Tech Stack: SQL
what you learn:
Advanced SQL, windowing Functions
Repository Link: https://lnkd.in/drD4b72q
5. SQL-Project-for-Data-Analysis-part-1-7
Tech stack: SQL
what you learn:
Basics to advanced, PIVOT, UNPIVOT, data analysis, Rank, Dense_rank, Row_number, etc.
Repository Link: https://lnkd.in/gDimC5s5
Add this 5 projects to your portfolio, that demand you lot in your SQL Journey.
hope this guide is "helpful"🙂
0 Comments