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.
If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
https://sqlnest.com/
Download the project material from my blog:
https://techtfq.com/blog/sql-project-...
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/power-b...
✅ 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 Queries
✅ 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
Auf dieser Seite können Sie das Online-Video SQL Project | SQL Case Study to SOLVE and PRACTICE SQL Queries | 20+ SQL Problems mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer techTFQ 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 190,449 Mal angesehen und es wurde von 4.9 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
