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 ...
Watch video SQL Data Analyst Project: Car Sales Data online without registration, duration hours minute second in high quality. This video was added by user Database Star 27 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,548 once and liked it 115 people.