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

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-sql-case-study-to-solve-and-practice-sql-queries Kaggle dataset link: https://www.kaggle.com/datasets/mexwell/famous-paintings 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-analytics-bootcamp-with-practical-job-assistance?refId=ujxkeg5e-n948-4cpg-fx9g-q0fvzczdyp ✅ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f ✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmohammed https://techtfq.graphy.com/courses/Recordings-from-SQL-Bootcamp-64f0e1cae4b014d5beccb78e ✅ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ ✅ Learn Python: https://techtfq.graphy.com/courses/Python-Bootcamp-for-Beginners-64d0e0a2e4b067acf3a67a2b-64d0e0a2e4b067acf3a67a2b?buy=true 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO ✅ SQL Tutorial - Intermediate concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii ✅ SQL Tutorial - Advance concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7 ✅ Practice Solving Basic SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp ✅ Practice Solving Intermediate SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV ✅ Practice Solving Complex SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL-- ✅ Data Analytics Career guidance: https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P ✅ SQL Course, SQL Training Platform Recommendations: https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n ✅ Python Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW ✅ Git and GitHub Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b ✅ Data Analytics Projects: https://www.youtube.com/playlist?list=PLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch THANK YOU, Thoufiq | techTFQ