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:
https://techtfq.com/blog/sqlproject...

Kaggle dataset link:
https://www.kaggle.com/datasets/mexwe...

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:
https://codebasics.io/bootcamps/data...

✅ Learn Power BI:
https://codebasics.io/courses/powerb...

✅ Learn complete SQL:
https://learnsql.com/?ref=thoufiqmoha...
https://techtfq.graphy.com/courses/Re...

✅ Practice SQL Queries:
https://www.stratascratch.com/?via=te...

✅ Learn Python:
https://techtfq.graphy.com/courses/Py...



WATCH MORE VIDEOS HERE

✅ SQL Tutorial Basic concepts:
   • SQL Tutorial  Basic concepts  

✅ SQL Tutorial Intermediate concepts:
   • SQL Tutorial  Intermediate concepts  

✅ SQL Tutorial Advance concepts:
   • SQL Tutorial  Advance concepts  

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries  

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Que...  

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries  

✅ Data Analytics Career guidance:
   • Data Analytics career and more  

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training  

✅ Python Tutorial:
   • Python Tutorial  

✅ Git and GitHub Tutorial:
   • Git and GitHub  

✅ Data Analytics Projects:
   • Data Analytics Projects  

THANK YOU,
Thoufiq | techTFQ