SQL portfolio strategy

[GeekTree0101]

• Find dataset that would interest a company, not interest you. Think sales data over Pokemon data.
• Perform SQL stuff. Aggregations, joins, windows functions if you're feeling spicy.
• Visualize it in Tableau and post it to your public portfolio.
• Be able to communicate the story
• Post on github
• Practice on stratascratch and leetcode.
• Get the job 🎉

[GeekTree0101]

The World Bank's international debt data 포트폴리오

https://github.com/kamararichards/SQL-Portfolio-Projects/blob/main/Analyze_International_Debt_Statistics/Analyze_International_Debt_Statistics.ipynb

• ipynb
• csv 데이터 셋
• csv 데이터 셋을 DB에 넣는 sql 스크립트

[GeekTree0101]

Kaggle python sql runner example https://www.kaggle.com/code/agilesifaka/historic-nba-drafting-game-and-player-analysis/notebook

[GeekTree0101]

브라질 전자상거래 시각화 SQL https://www.kaggle.com/code/muhammadrifki/data-visualization-aggregation-with-python-sql

[GeekTree0101]

SQL cheatsheet https://github.com/enochtangg/quick-SQL-cheatsheet