📝 Get this Data Analysis Project Guide: www.databasestar.com/project-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
If you want to improve your SQL, you'll need to practice your skills.
A great way to do this is to download a sample data set and run some SQL on it.
In this video, you will learn how to:
- download a sample CSV data set
- import this CSV into a database
- adjust the table to resolve some issues we find
- answer a range of questions we have about the data
⏱ TIMESTAMPS:
00:00 - Our project
00:37 - Download and import the data
05:17 - Initial analysis
12:46 - Question 1
14:24 - Question 2
21:45 - Question 3
22:46 - Question 4
26:17 - Question 5
27:18 - Question 6
29:20 - Question 7
30:30 - Question 8
🔗 VIDEO LINKS:
Script for Alter Table: github.com/bbrumm/databasesta...
23 июл 2024