In this video, let's learn to write SQL Queries using a real dataset downloaded from the internet. We shall download Olympics dataset from Kaggle and then write SQL Queries to fetch different information from this Olympics data.

Understanding the underlying data stored across different tables will make it much easier to write SQL queries. And that is why we will use real data (real dataset) to write SQL queries in this video.

We start this video by downloading the Olympics history dataset from kaggle website. We then load this dataset into a PostgreSQL database. Meaning we store this data into database tables. Once the data is stored in tables, we then write SQL queries to fetch different information about the history of Olympic games.

I have come up with 20 different SQL queries which we can write on this Olympics dataset. I have posted all these queries in my blog. However, in this video, I will solve only 4 of the SQL queries which I feel are the most complex. If I tried to cover all the 20 SQL queries, then the video would have been many hours long.

The 20 SQL Queries should give you very good understanding of how to write different types of queries and how to think different when solving a SQL problem.

Link to my blog: hhttps://techtfq.com/blog/practice-wri...
Link to Kaggle Dataset: https://www.kaggle.com/heesoo37/120-y...


Timestamp:
00:00 Intro
02:41 Download dataset from Kaggle
04:22 Load Kaggle dataset to PostgreSQL database
12:25 Query 1 - Write SQL query to identify the sport which was played in all summer Olympic games.
21:21 Query 2 - Write SQL query to fetch the top 5 athletes who won the most Olympics gold medal.
26:12 Query 3 - Write SQL query to display the total gold, silver and bronze medal won by each country in Olympics.
40:17 Query 4 - Write SQL query to fetch the country which won the most gold, most silver and most bronze medal during each Olympic game.


🔴 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  

THANK YOU,
Thoufiq