SQL for Data Analysis in 2 hours (with dataset + 50 queries)

Learn how to think like SQL . SQL is one of the most in demand data analytics skills. In this 2 hours video we will learn how to write efficient SQL queries. We will learn how to sort, filter, aggregate, join data in SQL along with string and date functions.

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataanalytics #dataanalysis

[Batman-hrn]

Thank you so much Ankit bhai for this. It has helped me a lot in building my foundation. Will watch your other videos as well. Bhai, I have tried to summarise it as below. Let me know if I need to make any changes or remove this comment. Happy to oblige. :)
**The execution order of an SQL query follows this logical sequence:**

FROM → JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT/TOP

**Step-by-Step Explanation:**

1⃣ FROM → Choose the table to retrieve data from.
2⃣ JOIN → If multiple tables are involved, join them.
3⃣ WHERE → Filter rows before grouping (applies row-level filtering).
4⃣ GROUP BY → Group rows based on column values.
5⃣ HAVING → Filter groups after aggregation (like SUM() or COUNT()).
6⃣ SELECT → Choose which columns or calculated values to display.
7⃣ ORDER BY → Sort the final result.
8⃣ LIMIT/TOP → Restrict the number of rows returned.

Example Query with Execution Order

Scenario: **Find total sales per customer but only include customers who made purchases greater than $10, 000, sorted by highest sales.**

SELECT customer_name, SUM(sales) AS total_sales -- (6) SELECT
FROM orders_data -- (1) FROM
JOIN customers ON orders_data.customer_id = customers.customer_id -- (2) JOIN
WHERE orders_data.order_date >= '2024-01-01' -- (3) WHERE (filter rows)
GROUP BY customer_name -- (4) GROUP BY (group data)
HAVING total_sales > 10000 -- (5) HAVING (filter groups)
ORDER BY total_sales DESC -- (7) ORDER BY (sort results)
LIMIT 10; -- (8) LIMIT (restrict rows)

[ankitbansal]

It takes lot of efforts to create 2 hours video so please do like the video. It will motivate me to create more long form videos. 🙏

[kunalchakraborty]

SQL for Data Analysis - Key Topics & Timestamps

00:00 - Introduction and Purpose
02:40 - Understanding the Data
07:40 - Selecting Data
12:20 - Filtering Data
20:45 - Sorting Data
24:50 - Aggregate Functions
30:10 - Grouping Data
40:50 - Filtering Aggregated Data
50:10 - Joining Tables
01:00:00 - Left Joins
01:10:40 - Case When Statements
01:20:30 - Date Functions
01:30:50 - String Functions
01:40:00 - Conclusion

[AnkitaTiwari]

Thank you so much, sir! Just because of this one video, I was able to crack my data analyst interview. I watched and practiced it, and the next day in my interview, they mainly asked about subqueries. They asked 4–5 SQL questions, and I was able to answer all of them because of this one video.

[arvindsuryawanse]

Student of ur 'Namaste SQL' course and I can say that yours is hands down the best course to learn SQL I have come across. Thank you for creating such good content. 👌👌

[muntundlovu]

Thank you very much Ankit for such a powerful video, I love your approach and how you explain the concepts. This channel is now my home until I master these concepts.

[chandrakantshimpi]

thank you ankit sir i saw many of sql videos but this type of teaching i cant see on youtube thanks for sharing

[anjanashakya]

Thanks for creating this video for someone to start from scratch, especially for folks who come from non-tech backgrounds. This was intuitive and very well explained. I'm looking forward to more such content for learning advanced SQL. Thanks again!

[uttamsharma]

This 2-hour video has been more informative than those overhyped 2-hour masterclasses that promise to turn you into a data analyst overnight. Thanks a ton, Ankit Bhai - your content actually delivers!

[karangupta-xozp]

Best video on SQL covering all important topics to get through the Database language. Very crisp and well explained. One of the best resources to learn SQL. Great content for the beginners to start their Data Journey. Looking forward for moderate and advanced Contents. Thanks!!

[PruthviK-ip]

Even a layman can understand easily.. Great work ankit sir🙏

[AnalyticNerd]

Fantastic SQL crash course! I’m just beginning my journey into SQL and data analysis, and this video covered so much in just two hours. I’ve started exploring SQL on my own channel as well, where I’m documenting the basics and sharing what I learn. Thanks for making it so digestible!

[DataScience-rd]

I love this video . Your teaching style is amazing . All concepts are taught by tutor but we need a separate video of advanced sql questions for data analysis.

[ritikasingh]

"I really appreciate how deeply you dive into SQL concepts. Your detailed explanations make even the trickiest topics easy to grasp. The way you cover every little aspect, from basic queries to advanced optimizations, shows your mastery and passion for teaching. Keep up the great work!"Thankyou Sir

[Sukkolu]

ln less than 2 hour covered all most all the SQL queries and functions, I have seen lots of SQL lectures, the lecture duration was 10+ hours, but i was not able to understand most of the functions and queries. The way you teaching Ankit sir is very good and easy to understand. Thank you sir for making such a learning stuff. ❤😍

[Malayalam_learner]

Completed 45:00 minutes of it and enjoyed it , now Instagram time

[raheemmd]

In order to conquer any technology we need have strong basics, this video is very clear and like refresher . Thanks man worth to watch.

[pratikthunbreakable]

Really Excited to get deep dive into this comprehensive course sir 😅

[srinivasreddygundlapalli]

I finished this video..
Very useful and helpful for how functions will execute in order and very interesting concepts ❤❤❤

[pavitrashailaja]

Very well made. Even a person who has zero knowledge on sql can understand. 👍