SQL Project | SQL Case Study to SOLVE and PRACTICE SQL Queries | 20+ SQL Problems

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

[hamantjagwan]

I always consider you as my primary SQL mentor. 🙏😊
Could you please provide us the answer key for the questions mentioned in the video? I would like to solve those questions

[leonmadara]

This guy is amazing!!! The stuff I have learnt from you is infinite, God bless!!! And please, make more video!!! Make it longer, tackle all the questions, we are hear to learn!!! SIMPLY AMAZING!!! THANKS

[Pravinunique]

Its great for freshers who wants to improve their problem solving skills

[-TechLearning]

Bro, I am not able to connect MySQL to Python and load the data into my database table. can you please help me? I have tried different methods but am still unable to make this happen.

[debacle-stylings]

i never leave comments on youtube but have to say that your videos are by far the best ive found ( after extensive searching )in regards to learning data analysis thank you very much!

[frankedwin]

This guy is so smart ... I'm dicovering incredible tricks in SQL. Amazing.

[Lokeshna]

Hi Thoufiq,

Thank you for all your vedios.

Is there any possibility that you can provide training personally by taking the charges?

It would be highly helpful.

[Sai-nkvd]

This is pretty straight forward, precise and crisp. Good content explained in a great way. So helpful. Thank you.

[mohsinmanzoor]

Can we use groupby in question 10.
How it is different from day in (‘sunday’, ’monday’)

[dnmykhb]

Thank you for this one. I hope I'm not asking too much as I would like you to do another one covering the remaining questions.

[kanchanshirnath]

Awesome... please make such more videos

[mohitnemade]

You are really perfect mentor for postgray sql, Thanks a lot 😍👍👍

[nilabja]

Amazing query has learnt from you. Thanks

[maghy_kethychannel]

superb affords. really hats of to you.please start a playlist videos for data engineers.which will help lots of techies

[muraliprasad]

Excellent and very informative, learned a lot of new things in SQL and python from this video. Thanks.

[okechukwuezinne]

I enjoyed the video cos you teach so well.
Thanks, man.

[sam-uwgf]

The data can be imported in Mysql easily than writing code of this much but I came to know about this way 👍👍

[moinuddinmohd]

Your videos always inspires to dig more into subject. Can i get the detailed SQL sessions from basics to advance and also with real time scenarios.

[fathimafarahna]

Much awaited😍As always, best of the best 👍

[jerofinsusanna]

Hi TFQ!!!Could you please make videos on MsSQL