SQL Data Analysis Project: eCommerce Site
📝 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 of an eCommerce company called Olist
import the CSV data into a database
answer a range of questions we have about the data
⏱ TIMESTAMPS:
00:00 - Setting up the data
06:19 - Question 1
07:30 - Question 2
10:02 - Question 3
12:06 - Question 4
15:30 - Question 5
24:40 - Question 6
🔗 VIDEO LINKS:
Data set used for this video: https://www.kaggle.com/datasets/olist...
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 Analysis Project: eCommerce Site online without registration, duration hours minute second in high quality. This video was added by user Database Star 22 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,100 once and liked it 90 people.