SQL Data Analyst Project: Car Sales Data

Get this Data Analysis Project Guide: https://databasestar.mykajabi.com/lpkj-data-analysis-projects/?video=xlSWkDZkAO4 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=xlSWkDZkAO4 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/syedanwarafridi/vehicle-sales-data Import a CSV in different editors: DBeaver: https://www.youtube.com/watch?v=u2N4UEL8Lm8 MySQL Workbench: https://www.youtube.com/watch?v=sfRwJH04QJc SQL Developer: https://www.youtube.com/watch?v=GcB4_0Iz2Zw