Just shared a real-world story on when ELT failed and why we had to switch back to ETL — even in a cloud-native setup.
If you're confused about which one to use in your data projects, this post will clear things up 👇
📊 Use-case breakdown ⚠️ Mistakes to avoid 🔁 When not to follow trends
👉 Check it out and drop your thoughts in the comments! 📎 https://www.linkedin.com/posts/adityabansal095_dataengineering-etl-elt-activity-7335157740572430336-FCjt?utm_source=share&utm_medium=member_ios&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
Let’s discuss what’s working (and what’s not) in real data pipelines 💬
#SQLJunction #DataEngineering
If you're confused about which one to use in your data projects, this post will clear things up 👇
📊 Use-case breakdown ⚠️ Mistakes to avoid 🔁 When not to follow trends
👉 Check it out and drop your thoughts in the comments! 📎 https://www.linkedin.com/posts/adityabansal095_dataengineering-etl-elt-activity-7335157740572430336-FCjt?utm_source=share&utm_medium=member_ios&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
Let’s discuss what’s working (and what’s not) in real data pipelines 💬
#SQLJunction #DataEngineering
Linkedin
ELT vs ETL: When to choose each | Aditya Bansal posted on the topic | LinkedIn
💣 ETL is dead. ELT is the future. Or is it?
Everyone's jumping on the ELT bandwagon... but I recently worked on a project where ELT failed spectacularly.
Here’s what happened 👇
We were processing sensitive financial data for a client using a cloud-native…
Everyone's jumping on the ELT bandwagon... but I recently worked on a project where ELT failed spectacularly.
Here’s what happened 👇
We were processing sensitive financial data for a client using a cloud-native…
❤2
🚨 Just Dropped!
I’ve uploaded the first video of my new YouTube series: SQL Server Interview Questions – Episode 1 🎥
👉 Watch Now
It covers a real-world SQL challenge with match results, NULLs, and detailed output logic. If you’re preparing for interviews or want to sharpen your SQL problem-solving skills, don’t miss this breakdown.
💬 I’d love to hear your version of the solution in the comments. Let’s learn from each other!
🙏 I’m on a mission to reach 500 subscribers and build a strong SQL & Data community on YouTube.
If you’ve found value in SQL Junction, I truly need your support now more than ever.
🎯 Please:
1️⃣ Watch the video
2️⃣ Like + Comment your thoughts
3️⃣ Hit Subscribe if you haven’t already
🔗 https://youtu.be/inJ85gOS078
Thanks for being part of this journey. Let’s grow together! 🚀
#SQLJunction #SQLServer #SQLInterview #SQL
I’ve uploaded the first video of my new YouTube series: SQL Server Interview Questions – Episode 1 🎥
👉 Watch Now
It covers a real-world SQL challenge with match results, NULLs, and detailed output logic. If you’re preparing for interviews or want to sharpen your SQL problem-solving skills, don’t miss this breakdown.
💬 I’d love to hear your version of the solution in the comments. Let’s learn from each other!
🙏 I’m on a mission to reach 500 subscribers and build a strong SQL & Data community on YouTube.
If you’ve found value in SQL Junction, I truly need your support now more than ever.
🎯 Please:
1️⃣ Watch the video
2️⃣ Like + Comment your thoughts
3️⃣ Hit Subscribe if you haven’t already
🔗 https://youtu.be/inJ85gOS078
Thanks for being part of this journey. Let’s grow together! 🚀
#SQLJunction #SQLServer #SQLInterview #SQL
YouTube
SQL Server Complex Interview Question Series – Find Total Matches Played, Matches Won, Tied and Lost
🚨 99% FAIL This SQL Interview Question! Can YOU Solve It?
Most candidates freeze when they see this SQL Server interview question — do you have what it takes to solve it?
In this video, we will break down a real SQL challenge involving match results, NULLs…
Most candidates freeze when they see this SQL Server interview question — do you have what it takes to solve it?
In this video, we will break down a real SQL challenge involving match results, NULLs…
🚨 New YouTube Video Just Dropped!
🎯 Amazon SQL Interview Question Solved!
🟣 Learn how to calculate month-over-month percentage change in revenue — a real SQL question asked in Amazon interviews!
📺 Watch Now 👉
https://youtu.be/WrRA-hVDZ5I
📌 Don’t forget to: 🔗 Subscribe to the channel 💬 Drop your thoughts in the comments 📣 Share with friends preparing for data interviews!
Please help me in reaching 500 subscribers.
#SQL #AmazonInterview #DataAnalytics #SQLInterview #SQLJunction
🎯 Amazon SQL Interview Question Solved!
🟣 Learn how to calculate month-over-month percentage change in revenue — a real SQL question asked in Amazon interviews!
📺 Watch Now 👉
https://youtu.be/WrRA-hVDZ5I
📌 Don’t forget to: 🔗 Subscribe to the channel 💬 Drop your thoughts in the comments 📣 Share with friends preparing for data interviews!
Please help me in reaching 500 subscribers.
#SQL #AmazonInterview #DataAnalytics #SQLInterview #SQLJunction
YouTube
Amazon SQL Interview Question | Calculate Month-over-Month Revenue Challenge 🔥
🚀 AMAZON SQL INTERVIEW QUESTION THAT STUMPED MANY! 🔥 | Month-over-Month Revenue Challenge in SQL
If you're preparing for top-tier FAANG interviews, THIS VIDEO is your cheat code. 🧠💻
📉 Challenge:
Given a table of purchases by date, calculate the Month-over…
If you're preparing for top-tier FAANG interviews, THIS VIDEO is your cheat code. 🧠💻
📉 Challenge:
Given a table of purchases by date, calculate the Month-over…
❤1
🚨 Netflix SQL Interview Question Alert!
They asked this in an actual interview:
🎬 "Find the genre of the person with the most Oscar wins… and join using names, not IDs."
Sounds simple? It’s not.
Real-world SQL. Real logic. Real fun. 😄
I just posted a breakdown on LinkedIn — check it out and drop a “Netflix 🔥” to get the full solution!
📎 https://www.linkedin.com/posts/adityabansal095_sql-dataanalytics-sqlinterview-activity-7343592162338422785-OsV9?utm_source=share&utm_medium=member_desktop&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
#SQL #Netflix #SQLJunction #DataEngineering #InterviewPrep
They asked this in an actual interview:
🎬 "Find the genre of the person with the most Oscar wins… and join using names, not IDs."
Sounds simple? It’s not.
Real-world SQL. Real logic. Real fun. 😄
I just posted a breakdown on LinkedIn — check it out and drop a “Netflix 🔥” to get the full solution!
📎 https://www.linkedin.com/posts/adityabansal095_sql-dataanalytics-sqlinterview-activity-7343592162338422785-OsV9?utm_source=share&utm_medium=member_desktop&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
#SQL #Netflix #SQLJunction #DataEngineering #InterviewPrep
Linkedin
#sql #dataanalytics #sqlinterview #datascience #database #sqlquery #techinterview #dataengineering #learnsql #bigdata #datajobs…
Dear Data Enthusiasts,
🎬 Netflix interview questions aren’t just cool — they’re designed to mess with your head (in a good way) 🎬
💡𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧:
Find the genre of the person with the most Oscar wins.
If there's a tie, return the genre of the person whose…
🎬 Netflix interview questions aren’t just cool — they’re designed to mess with your head (in a good way) 🎬
💡𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧:
Find the genre of the person with the most Oscar wins.
If there's a tie, return the genre of the person whose…
🚨 New Video Just Dropped!
📺 Just uploaded a fresh YouTube video where I break down a Hard Google SQL interview question:
🎬 Compare the rating of an actor’s most recent film with the average of all their previous films.
If you’re preparing for SQL interviews or just want to level up your logic — this is a must-watch!
📌 Watch here: https://youtu.be/gZ7ZKtKvL7s
🔥 Don’t forget to like, comment, and share if it helps!
Please help me in reaching 500 subscribers, Guys!!
#SQLJunction #SQLInterview #Google #DataEngineering #InterviewPrep #DataJobs
📺 Just uploaded a fresh YouTube video where I break down a Hard Google SQL interview question:
🎬 Compare the rating of an actor’s most recent film with the average of all their previous films.
If you’re preparing for SQL interviews or just want to level up your logic — this is a must-watch!
📌 Watch here: https://youtu.be/gZ7ZKtKvL7s
🔥 Don’t forget to like, comment, and share if it helps!
Please help me in reaching 500 subscribers, Guys!!
#SQLJunction #SQLInterview #Google #DataEngineering #InterviewPrep #DataJobs
YouTube
Google SQL Interview Question | Calculate Actor Latest VS Average Film Ratings 🔥
🎬 Google SQL Interview Question – Most Recent Film vs Average Rating Explained!
In this video, I break down a real SQL question asked in a Google interview:
👉 For each actor, calculate the difference between the rating of their most recent film and their…
In this video, I break down a real SQL question asked in a Google interview:
👉 For each actor, calculate the difference between the rating of their most recent film and their…
Sure! Here's a concise and engaging Telegram post you can use to share your YouTube video in your SQL Junctionchannel:
🚀 NEW VIDEO DROP – SQL Interview Question from Netflix!
🔗 Watch now on YouTube (Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY)
📌 Problem Statement:
You're given two tables –
Your task?
🎯 Recommend pages to users that they don’t follow but at least one of their friends does.
This was asked in a real Netflix SQL interview!
✅ In the video, I break down:
The logic step-by-step
How to write the SQL query
Key concepts like anti-joins, self joins, and recommendation filtering
Perfect for:
🔸 SQL learners
🔸 Data analyst/engineer interview prep
🔸 Anyone curious how Facebook-style recommendations work under the hood!
👨💻 Watch now & level up your SQL skills!
🎬 Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY
#SQL #SQLJunction #NetflixInterview #SQLChallenge #DataEngineering #SQLQuery #TechInterview #TelegramLearning
🚀 NEW VIDEO DROP – SQL Interview Question from Netflix!
🔗 Watch now on YouTube (Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY)
📌 Problem Statement:
You're given two tables –
user_friends and user_pages.Your task?
🎯 Recommend pages to users that they don’t follow but at least one of their friends does.
This was asked in a real Netflix SQL interview!
✅ In the video, I break down:
The logic step-by-step
How to write the SQL query
Key concepts like anti-joins, self joins, and recommendation filtering
Perfect for:
🔸 SQL learners
🔸 Data analyst/engineer interview prep
🔸 Anyone curious how Facebook-style recommendations work under the hood!
👨💻 Watch now & level up your SQL skills!
🎬 Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY
#SQL #SQLJunction #NetflixInterview #SQLChallenge #DataEngineering #SQLQuery #TechInterview #TelegramLearning
YouTube
Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
🚀 Netflix SQL Interview Question Solved!
In this video, I walk through a real-life SQL interview question asked at Netflix.
📌 Problem Statement:
You're given two tables:
user_friends(user_id, friend_id) – represents the Facebook friendship graph
user_pages(user_id…
In this video, I walk through a real-life SQL interview question asked at Netflix.
📌 Problem Statement:
You're given two tables:
user_friends(user_id, friend_id) – represents the Facebook friendship graph
user_pages(user_id…
🚨 SQL Interview Prep Kit 🚨
1️⃣ Aggregations
2️⃣ Window Functions
3️⃣ Set Operators
4️⃣ Indexing for Performance
5️⃣ SQL for Analytics
🎯 Perfect for quick revision before interviews or weekend practice!
#SQL #InterviewPrep #DataEngineering #SQLJunction
1️⃣ Aggregations
2️⃣ Window Functions
3️⃣ Set Operators
4️⃣ Indexing for Performance
5️⃣ SQL for Analytics
🎯 Perfect for quick revision before interviews or weekend practice!
#SQL #InterviewPrep #DataEngineering #SQLJunction
Average SQL vs Great SQL.pdf
169.7 KB
🚫 Most developers write SQL like this...
✅ But great developers write it like this.
Just shared a visual breakdown of common SQL mistakes — and how to fix them like a pro! ⚡
Perfect for anyone preparing for interviews or writing SQL daily.
📌 Upgrade your query game in 60 seconds.
#SQL #InterviewPrep #SQLTips #SQLJunction #SQLInterview
✅ But great developers write it like this.
Just shared a visual breakdown of common SQL mistakes — and how to fix them like a pro! ⚡
Perfect for anyone preparing for interviews or writing SQL daily.
📌 Upgrade your query game in 60 seconds.
#SQL #InterviewPrep #SQLTips #SQLJunction #SQLInterview
❤2
Hey folks 👋
I just created a clean and simple SQL cheat sheet — perfect for quick revision before interviews or while working on projects.
It covers:
🔸 DDL / DML / DCL / TCL
🔸 All types of Joins
🔸 Common Window Functions
🔸 Aggregate functions
🖼️ Check out the full image in the post 👆
📌 Save it for your reference
📤 Share it with someone learning SQL
— Aditya | SQL Junction
#SQL #SQLCheatSheet #DataEngineering #LearningSQL #SQLJunction
I just created a clean and simple SQL cheat sheet — perfect for quick revision before interviews or while working on projects.
It covers:
🔸 DDL / DML / DCL / TCL
🔸 All types of Joins
🔸 Common Window Functions
🔸 Aggregate functions
🖼️ Check out the full image in the post 👆
📌 Save it for your reference
📤 Share it with someone learning SQL
— Aditya | SQL Junction
#SQL #SQLCheatSheet #DataEngineering #LearningSQL #SQLJunction
❤2👍1
🚀 SQL Challenge #14 — The Lift Capacity Problem is LIVE!
You’re given two tables — LIFT and LIFT_PASSENGERS.
Multiple passengers can try to enter the same lift, but the total passenger weight cannot exceed the lift’s capacity.
Your task?
👉 Write an SQL query that returns a comma-separated list of passengers who can fit into each lift without exceeding capacity, ordered by their weight in ascending order.
In this video, I’ll walk you through my entire step-by-step solution in SQL Server, breaking down the logic clearly so you can learn, understand, and apply it in your own interviews 💼
🎥 Watch the full video here:
👉 https://youtu.be/8e-e1xYsgG0
https://youtu.be/8e-e1xYsgG0
💬 Drop your approach in the comments — let’s see how you solved it differently!
👥 Share this with your SQL buddies who love a good challenge.
#SQLChallenge #SQLServer #SQLQuery #SQLInterview #SQLPractice #SQLJunction #LearnSQL
You’re given two tables — LIFT and LIFT_PASSENGERS.
Multiple passengers can try to enter the same lift, but the total passenger weight cannot exceed the lift’s capacity.
Your task?
👉 Write an SQL query that returns a comma-separated list of passengers who can fit into each lift without exceeding capacity, ordered by their weight in ascending order.
In this video, I’ll walk you through my entire step-by-step solution in SQL Server, breaking down the logic clearly so you can learn, understand, and apply it in your own interviews 💼
🎥 Watch the full video here:
👉 https://youtu.be/8e-e1xYsgG0
https://youtu.be/8e-e1xYsgG0
💬 Drop your approach in the comments — let’s see how you solved it differently!
👥 Share this with your SQL buddies who love a good challenge.
#SQLChallenge #SQLServer #SQLQuery #SQLInterview #SQLPractice #SQLJunction #LearnSQL
YouTube
Find Passengers That Can Fit in Each Lift | SQL Interview Question
In this video, we solve an interesting SQL problem that tests your ability to work with aggregations, joins, and string functions.
🧩 Problem Statement:
The relationship between the LIFT and LIFT_PASSENGERS tables is such that multiple passengers can attempt…
🧩 Problem Statement:
The relationship between the LIFT and LIFT_PASSENGERS tables is such that multiple passengers can attempt…
🎯 New SQL Interview Question on YouTube!
A real Deloitte Interview Question that tests: • Window functions • Logical thinking under pressure • Your ability to connect dates correctly 📅⚙️
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
https://youtu.be/ZPcV0OmSaIo
Most candidates struggle here… Can YOU solve it? 🤔
Watch now 👇
🔥
#SQL #InterviewPrep #DataEngineering #LearnSQL #SQLServer #Programming #SQLPractice #TechInterview #YouTubeChannel #SQLCommunity #SQLJunction #AdityaBansal
A real Deloitte Interview Question that tests: • Window functions • Logical thinking under pressure • Your ability to connect dates correctly 📅⚙️
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
https://youtu.be/ZPcV0OmSaIo
Most candidates struggle here… Can YOU solve it? 🤔
Watch now 👇
🔥
#SQL #InterviewPrep #DataEngineering #LearnSQL #SQLServer #Programming #SQLPractice #TechInterview #YouTubeChannel #SQLCommunity #SQLJunction #AdityaBansal
YouTube
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
🎯 SQL Interview Challenge – Can You Solve This?
In this video, we take a real-world problem involving event logs and use SQL window functions (ROW_NUMBER) to group consecutive records by date. This is a popular interview question used in top tech and data…
In this video, we take a real-world problem involving event logs and use SQL window functions (ROW_NUMBER) to group consecutive records by date. This is a popular interview question used in top tech and data…
FAANG SQL Challenge: Can you solve "The Delimiter Trap"? 🧩
I just dropped a new breakdown of a classic interview problem that trips up even Senior Data Engineers.
The Task: Extract and calculate reward points from a single "messy" column (e.g., `'MM:CI:CD'`).
Why you should watch:
✅ Learn the cleanest way to use
✅ Master Conditional Aggregation (no more spaghetti code!).
✅ Avoid the #1 over-engineering mistake candidates make in FAANG interviews.
Stop struggling with messy data—master the logic in 5 minutes.
Watch the full solution here:
👇👇👇
https://youtu.be/Pg5F8_ViXE8
Which one is faster for this—`STRING_SPLIT` or
#SQL #InterviewPrep #DataEngineering #SQLJunction #SQLInterview
I just dropped a new breakdown of a classic interview problem that trips up even Senior Data Engineers.
The Task: Extract and calculate reward points from a single "messy" column (e.g., `'MM:CI:CD'`).
Why you should watch:
✅ Learn the cleanest way to use
STRING_SPLIT.✅ Master Conditional Aggregation (no more spaghetti code!).
✅ Avoid the #1 over-engineering mistake candidates make in FAANG interviews.
Stop struggling with messy data—master the logic in 5 minutes.
Watch the full solution here:
👇👇👇
https://youtu.be/Pg5F8_ViXE8
Which one is faster for this—`STRING_SPLIT` or
CROSS APPLY? Let me know in the YouTube comments! 🚀#SQL #InterviewPrep #DataEngineering #SQLJunction #SQLInterview
YouTube
FAANG SQL Interview Challenge | Calculate Total Club Points
🎯 SQL Challenge – Can You Solve This?
In this video, we’ll solve a real SQL interview-style problem involving reward points and club memberships.
Table Create Statements:
Create Table Club (
Club_Id int,
Member_Id int,
EDU varchar(30))
Insert into Club…
In this video, we’ll solve a real SQL interview-style problem involving reward points and club memberships.
Table Create Statements:
Create Table Club (
Club_Id int,
Member_Id int,
EDU varchar(30))
Insert into Club…
👍1