Mastering SQL for EDA : A Comprehensive SQL Project Guide with Queries

Welcome to our in-depth tutorial on analyzing NFT transactions using SQL! In this video, we’ll walk you through several powerful SQL queries to extract and analyze data from our NFT transaction dataset. By the end of this video, you’ll have a solid understanding of how to manipulate and gain insights from your data.

*Here’s what we’ll cover:*

1.) 🔗 Overview of the NFT Dataset:
2.) 📊 Total sales in the given time period.
3.) 💸 Top 5 highest transactions (USD): name, ETH price, USD price, date.
4.) 📈 Transaction table: event, USD price, 50-transaction moving average.
5.) 💰 NFT names with average USD sale price (descending order).
6.) 📅 Day of the week: number of sales and average ETH price, ordered by transaction count.
7.) 📝 Transaction summary: seller, buyer, NFT name, date, and rounded USD price.
8.) 👤 View of sales with “0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685” as buyer.
9.) 📉 Histogram of ETH price ranges (rounded to nearest hundred).
10.) 🔀 Union query: highest and lowest NFT purchase prices with status.
11.) 🏆 Most sold NFT each month/year with name and USD price (chronological order).
12.) 📅 Monthly total volume of sales (rounded to nearest hundred).
🔍 Estimated average value calculator: daily representative price excluding outliers.
For the steps in creating the "estimated average value calculator":
a.) 🗂 Subquery: event date, USD price, average USD price (daily) in a temporary table.
b.) 🧮 Filter subquery: exclude USD prices below 10% of daily average, return new estimated daily average.

⏰ * Time Stamp: *

00:00 📝 Overview and Objective SQL Project
01:20 📊Total sales in the given time period
01:48 💸Top 5 highest transactions (USD): name, ETH price, USD price, date
02:50 📈 Transaction table: event, USD price, 50-transaction moving average
06:25 💰 NFT names with average USD sale price (descending order)
07:50 📅 Day of the week: number of sales and average ETH price, ordered by transaction count
12:25 📝 Transaction summary: seller, buyer, NFT name, date, and rounded USD price
15:50 👤 View of sales with “0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685” as buyer
17:45 📉 Histogram of ETH price ranges (rounded to nearest hundred)
19:45 🔀 Union query: highest and lowest NFT purchase prices with status
22:15 🏆 Most sold NFT each month/year with name and USD price (chronological order)
28:05 📅 Monthly total volume of sales (rounded to nearest hundred)
30:00 🔍 Estimated average value calculator: daily representative price excluding outliers

💸 *SQL Queries and Data Repository:*

Find the complete Queries and Data used in this video on our GitHub repository

[dss]

I found this as excellent video on YouTube for SQL.
This single 30 min video covers all the SQL concepts. Instead of wasting time searching for multiple videos, I will highly recommend watching this one. It will be incredibly helpful.
Thanks for the sharing 👍👍

[deepesh]

It is a beneficial and informative video, with Clear Explanations and perfect coverage of the topic. Thank you for sharing & much appreciate for your effort.

[Explore_DataScience]

I found this tutorial very Appreciated.

[coolsudhir]

its really helpful source available on you tube . It covers some important topics of sql in the respect of interview purpose thanks for sharing

[bgupta]

Very well explained. Request you to please upload more videos.

[keeplearning]

Really it is great video.... Please upload more video.... would be great if you have can more and more into the depth.