SQL Data Analyst Project: Car Sales Data
Get this Data Analysis Project Guide: https://www.databasestar.com/project-...
🎓 Master SQL Fundamentals: https://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 on car sales
- import this CSV into a database
- answer a range of questions we have about the data
⏱ TIMESTAMPS:
00:00 - Setting up our data
05:39 - Q1 sales in each state
11:09 - Q2 make and model
12:57 - Q3 avg state prices
13:31 - Q4 avg prices per month
19:03 - Q5 num sales each month
21:40 - Q6 top models for each body type
25:09 - Q7 sales higher than model average
27:51 - Q8 condition and sales price
29:31 - Q9 odometer and sales price
30:32 - Q10 brand details
32:02 - Q11 cars sold multiple times
🔗 VIDEO LINKS:
Car sales data set on Kaggle: https://www.kaggle.com/datasets/syeda...
Import a CSV in different editors:
DBeaver: • DBeaver Data Import: How to Import a CSV
MySQL Workbench: • How to Import a CSV in MySQL Workbench
SQL Developer: • How to Import a CSV or Excel File in ...
Смотрите видео SQL Data Analyst Project: Car Sales Data онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Database Star 27 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,548 раз и оно понравилось 115 людям.