Login

u/grassp_dataAI

r/LearnDataAnalytics r/learnSQL r/YouTube_startups r/NewYouTubeChannels r/SQL
SQL Interview Tips - Shorts Style
▲ 16 r/learnSQL

SQL Interview Tips - Shorts Style

Hi All 👋,

I have been posting SQL interview tips as less than 1 min shorts in my youtube channel.

Some tips for reference below :

COUNT(*) vs COUNT(column) -

https://youtube.com/shorts/tTtoWa1OCIo?si=V2KZaDDNFhbfbhg7

Ranking Window Functions( ROW_NUMBER, RANK, DENSE_RANK) -

https://youtube.com/shorts/MyaH-v0CUUk?si=mHfEteTUkx5mUoHI

Replace NULLs -

https://youtube.com/shorts/NdoBwKAFcE0?si=2zXqab8lqG45QXLk

ORDER BY tricky part -

https://youtube.com/shorts/9bRm0IEKQRo?si=XUXqTQzbfLQD6\_Rs

I have also covered other topics like Anti-JOIN, WHERE vs HAVING,

LIKE vs ILIKE, IN vs NOT IN vs NOT EXISTS.

I will be continuing the series with similar style covering most important SQL topics through interview tips.

Feel free to check out and share it with whoever it benefits.

GRASSP Acad channel link -> https://m.youtube.com/@grasspDataAI/shorts

Happy learning:)

u/grassp_dataAI — 2 days ago
▲ 0 r/YouTube_startups

Started youtube channel for Data and AI education.

Today we started our youtube channel @grasspDataAI - Data and AI education.

We will follow a learning framework which follows-

->Story and scenario based teaching - every concept tied to a business situation

->Business context in every lesson, not just syntax

->Simple Beginner friendly language

-> Analogy based

We will connect to a fictional fast food chain called SuperFastFood Dataset and business scenarios in every concept and topic.

-Like a Data Universe - across all topics.

We just dropped our first series for SQL today.

We start with SQL, eventually we create content across Python, Data Analysis, Data Engineering, ML, AI, and Agentic AI, covering all areas of Data & AI.

u/grassp_dataAI — 24 days ago
▲ 2 r/NewYouTubeChannels

Started a educational channel teaching Data & AI through business scenarios — would love feedback from this community

Hey everyone,

We recently launched a channel called GRASSP Acad, focused on teaching SQL, Python, Data Analysis, Data Engineering, ML, AI, and Agentic AI, covering all areas of Data & AI.

A bit about the approach, since it's the core idea behind the channel:

Instead of teaching syntax in isolation, everything is taught through one consistent business scenario — a fictional fast food company "SuperFastFood Global" with customers, orders, and products — so concepts build on each other instead of feeling like disconnected examples.

The framework we follow for every topic:

→ Scenario based

→ Analogy based

→ Execution-focused — minimal theory, straight into business context → code → explanation

→ Every concept ties back to the business context

→ Transitive — each topic builds on the one before it

→ Beginner friendly

First series live now is a 20-part free SQL course (SQL Fast Track) — basics to advanced. Planning to follow the same framework for Python, Data Analysis, Data Engineering, AI/ML topics next.

Would really appreciate any feedback — on the channel setup, thumbnails, titles, whatever stands out. Thank you all for the support.

Channel Link: https://www.youtube.com/@grasspDataAI

u/grassp_dataAI — 24 days ago
▲ 44 r/learnSQL+1 crossposts

SQL Fast Track Series that teaches every concept through scenario-based business context - Available in Youtube.

Hi All👋,

We built a SQL Fast Track series around a single consistent fictional company SuperFastFood Global : a fast-food chain with customers, orders, and products.

It is a 20 part series where you will learn SQL through solving real business questions instead of memorizing syntax.

Whether you're preparing for an SQL interview, refreshing your skills, or just starting your SQL journey, this series is built to help you go from basics to advanced concepts quickly and confidently — covering everything in detail, but kept short and to the point.

What it covers:
→ SELECT, WHERE, ORDER BY, CASE
→ Aggregate functions, GROUP BY, HAVING
→ JOINs (with real use cases, not just definitions)
→ Window Functions — ranking, LAG/LEAD, running totals

We follow business context in every topic connects to it previous one with same SuperFastFood Global fictional fast food chain dataset.

The teaching framework we follow:
→ Scenario based
→ Analogy based
→ Execution-focused — business context → code → explanation
→ Every concept ties back to a business context
→ Each topic builds on the one before it, so nothing feels disconnected
→ Beginner friendly

This is the same framework we'll be using across future Data & AI topics too — not just SQL.

Also sharing a free 30-Day SQL Sprint (PDF, on GitHub).

Happy to answer questions on any of these topics in the comments.

Youtube Playlist: https://www.youtube.com/playlist?list=PLDTykWK3Vitc
GitHub: https://github.com/grasspacad07/grasspsqlsprintfile

u/grassp_dataAI — 24 days ago
▲ 3 r/LearnDataAnalytics

30 SQL Scenario Based Questions as single PDF.

Hi 👋,

I am sharing the Github link of GRASSP SQL Sprint Series. This github link contains the PDF doc of 30 SQL Scenario based Questions which covers beginner to advanced topics.

Doc is on GitHub, free: https://github.com/grasspacad07/grasspsqlsprintfile

File name: GRASSP_SQL_Sprint_30Days.pdf

Go through the question as per suggested approach in the doc and practice along each question and understand the concepts that each question cover.

It covers various topics :

  • Aggregation, JOINs, GROUP BY / HAVING
  • Window functions — RANK vs DENSE_RANK vs ROW_NUMBER, LAG/LEAD, Running totals, Moving Average
  • CTEs, Multi level aggregation.
  • CREATE, INSERT sample data helps too understand datatypes, constraints.

Hope this helps in your next SQL interview. All the best!

Happy learning :) Happy querying :)

u/grassp_dataAI — 1 month ago
▲ 53 r/learnSQL

30 SQL Scenario Based Questions as single PDF.

Hi 👋,

I am sharing the Github link of GRASSP SQL Sprint Series. This github link contains the PDF doc of 30 SQL Scenario based Questions which covers beginner to advanced topics.

Doc is on GitHub, free: https://github.com/grasspacad07/grasspsqlsprintfile

File name: GRASSP_SQL_Sprint_30Days.pdf

Go through the question as per suggested approach in the doc and practice along each question and understand the concepts that each question cover.

It covers various topics :

  • Aggregation, JOINs, GROUP BY / HAVING
  • Window functions — RANK vs DENSE_RANK vs ROW_NUMBER, LAG/LEAD, Running totals, Moving Average
  • CTEs, Multi level aggregation.
  • CREATE, INSERT sample data helps too understand datatypes, constraints.

Hope this helps in your next SQL interview. All the best!

Happy learning :) Happy querying :)

reddit.com
u/grassp_dataAI — 1 month ago
▲ 15 r/learnSQL

SQL scenario based learning - July month coupon

Hi All,

We had shared coupon for June for our SQL course which is currently a Hot & New course in Udemy. It had a very good response.

Sharing the July month coupon here in case it helps learners who missed the June one.

Coupon: SQLGRAJUL7

(100 slots left - expires in a month).

Course name: Complete SQL for Data Analysis - Scenario Based Learning

Search with course name and enter the coupon code and enroll for free.

Grab it if you are looking to learn SQL through real time scenarios. The scenarios are based on a fictional fast food chain "SuperFastFood Global" data story.

Also posting 30 day SQL series in LinkedIn "GRASSP Acad" page. We are in 27th day of the series. The series is also based on the same fictional fast food data. Feel free to checkout series to practice on advanced SQL scenario based questions.

Happy Learning and Happy Querying:)

reddit.com
u/grassp_dataAI — 1 month ago
▲ 2 r/learnSQL

Day 11 of our SQL scenario series — also have free course coupons left if anyone's stuck on the basics

In SuperFastFood (a fictional fast food chain we use for these scenarios), the menu strategy team calls a meeting: "We want to create combo deals. Which two products get ordered together in the same order most often? Show us the top 5 pairs." --> Try writing the query for it.

That's the kind of question we have been running daily as part of a 30-day SQL challenge series — covers CTEs, window functions, joins, and more, framed around real business problems instead of plain syntax.
We post these daily on our LinkedIn page (search GRASSP Acad) if you want to follow along with the full series.

A few people reached out asking for free coupons alongside the series, so opening it up here too. If you are working through the fundamentals and want a fuller course alongside this, here's a free coupon for our course titled "Complete SQL for Data Analysis – Scenario Based Learning" on Udemy:

Coupon: EARLYSQLGRA7
Ends July 3rd, 70 slots left.

Happy to help if anyone's stuck on query problem — drop it in the thread or DM.

reddit.com
u/grassp_dataAI — 2 months ago
▲ 2 r/SQL

Doing a 30-day SQL interview question challenge — sharing the approach in case it helps others

We have been running a personal challenge for the last week — one SQL interview-style question a day, all based on a single fictional business dataset (a fast-food chain with stores, products, customers, orders).

The idea was to avoid the usual "random unconnected queries" problem most practice sets have, where each question feels disconnected from the last.

Instead, every day's question builds on the same dataset, so it starts to feel like you're actually working with real business data rather than isolated syntax drills — filtering, joins, aggregations, then moving into window functions, cohort-style problems, gap detection, etc. as the days go on.

We are already 7 days in, and it's been a good way to actually retain concepts instead of just solving and forgetting.

If anyone wants to follow along day by day, I've been posting it on our LinkedIn page - but mainly wanted to share the format here in case it's useful for others building their own practice routine, even outside of this specific series.

Follow along and check it out, should be useful.

-GRASSP Acad

reddit.com
u/grassp_dataAI — 2 months ago
▲ 86 r/LearnDataAnalytics+1 crossposts

Learn SQL through real scenario-based learning — for data analysis

We created a Udemy course for SQL focused on data analysis through scenario-based learning.

Instead of teaching syntax in isolation, everything is built around a fictional fast food chain "SuperFastFood Global" — so every query you write has a real business context behind it.

The course includes:

- Line-by-line query writing with explanation

- Business scenario-based examples throughout

- Practice questions and interview prep

It designed to not overwhelm you — beginner-friendly from day one.

Udemy course name: Complete SQL for Data Analysis - Scenario Based Learning
Limited time offer ! Grab it, if interested.

We also run a — free 30-day SQL series called "GRASSP SQL Sprint" on our LinkedIn page — one question every day, each with a business scenario from the same fictional fast food chain SuperFastFood Global , along with sample data, query, and a simple explanation.

Learning the concepts from the course + practicing daily is a solid combo.

Follow GRASSP Acad in LinkedIn

reddit.com
u/grassp_dataAI — 2 months ago