In this video let us work on an SQL Case study in which we shall download a dataset from Kaggle and then upload it to a PostgreSQL database using Python. We shall then analyze the data and solve 20+ SQL queries. You can term this SQL practice exercise as an SQL project or an SQL case study. The aim is to provide you with a dataset to analyze data and then practice basic to intermediate SQL problems.

The dataset we use is the famous paintings dataset taken from Kaggle. We use a simple Python script to upload data from CSV files to PostgreSQL database tables. We then use SQL queries to answer over 20 problems related to the famous paintings dataset.

Download the project material from my blog:
[ Ссылка ]

Kaggle dataset link:
[ Ссылка ]

Timestamp:
00:00 Intro
00:50 Download Kaggle Dataset
01:27 Load data to Database using Python
12:29 Analysing Kaggle Dataset
16:01 Solving SQL Query no 1
21:27 Solving SQL Query no 2
27:46 Solving SQL Query no 3

Thank you for watching!

Watch more videos:
🔴 My Recommended courses 👇

✅Complete Data Analytics Bootcamp:
[ Ссылка ]

✅ Learn Power BI:
[ Ссылка ]

✅ Learn complete SQL:
[ Ссылка ]
[ Ссылка ]

✅ Practice SQL Queries:
[ Ссылка ]

✅ Learn Python:
[ Ссылка ]



🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:
[ Ссылка ]

✅ SQL Tutorial - Intermediate concepts:
[ Ссылка ]

✅ SQL Tutorial - Advance concepts:
[ Ссылка ]

✅ Practice Solving Basic SQL Queries:
[ Ссылка ]

✅ Practice Solving Intermediate SQL Queries:
[ Ссылка ]

✅ Practice Solving Complex SQL Queries:
[ Ссылка ]--

✅ Data Analytics Career guidance:
[ Ссылка ]

✅ SQL Course, SQL Training Platform Recommendations:
[ Ссылка ]

✅ Python Tutorial:
[ Ссылка ]

✅ Git and GitHub Tutorial:
[ Ссылка ]

✅ Data Analytics Projects:
[ Ссылка ]

THANK YOU,
Thoufiq | techTFQ

свернуть