📝 Get this Data Analysis Project Guide: [ Ссылка ]
🎓 Master SQL Fundamentals: [ Ссылка ]
There's a pretty comprehensive dataset available for the NBA, and in this video I'll use SQL to run some analysis on the data.
You'll learn some team-level statistics for the NBA over time, such as the teams with the best and worst single-season record, the best record over 5 years, and the best and worst single-season turnaround.
Adjustments I had to make during importing:
- draft_history.organisation - default to 27 characters, needs at least 100
- game.team_name_home - default to 27 characters, needs at least 100
- game.team_name_away - default to 27 characters, needs at least 100
⏱ TIMESTAMPS:
00:00 - Our data set
04:05 - Question 1
09:32 - Question 2
12:48 - Question 3
14:19 - Question 4
20:09 - Question 5
🔗 VIDEO LINKS:
Kaggle data set: [ Ссылка ]
Importing CSV:
DBeaver: [ Ссылка ]
MySQL Workbench: [ Ссылка ]
SQL Developer: [ Ссылка ]
