SQL Data Analysis Project: eCommerce Site

Published: 22 July 2024
on channel: Database Star
2,100
90

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


On this page of the site you can watch the video online SQL Data Analysis Project: eCommerce Site with a duration of hours minute second in good quality, which was uploaded by the user Database Star 22 July 2024, share the link with friends and acquaintances, this video has already been watched 2,100 times on youtube and it was liked by 90 viewers. Enjoy your viewing!