Data Analyst Project: Step-by-Step Analysis with SQL

📝 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...

[@PaulRhee-gp8zu]

The projects are so great to put the information together and so much more fun. Thanks!!!

[@DatabaseStar]

That’s great to hear! Glad you like the video and the project.

[@tamiratabebe6623]

Thank you because the video Gide for me thank you

[@BlackSwan912]

Your trainings are always spot on.

[@DatabaseStar]

Thanks!

[@Danishkhan-rh2nf]

Hello sir
How to download and install oracle on MacBook m3

[@DatabaseStar]

Hi, I have a video coming out later this week on this very topic :)

[@mrbartuss1]

@@DatabaseStar Thank you very much! Could you please do that also for PostgreSQL, MySQL and MS SQL Server?

[@DatabaseStar]

Sure - MySQL and Postgres can be installed natively or using Docker, and SQL Server can only be installed using Docker. I have videos for all of these on my channel already.

[@maxyudin]

Thanks for the detalization. but Import, not impOrt.

[@DatabaseStar]

Thanks! Yeah the emphasis is on the first syllable.