SQL Junction
2.92K subscribers
17 photos
1 video
7 files
90 links
Download Telegram
SQL Junction pinned Β«πŸš€ It’s LIVE! The SQL Marathon is finally out πŸ”₯ I’ve published a 3-hour SQL + Data Analytics video where I solve 50 real SQL questions using one YouTube Analytics dataset β€” step by step. If you’re preparing for: β€’ SQL interviews β€’ Data Engineering / Analytics…»
Career growth rarely comes from one big move.
It comes from showing up every day β€” even when no one is watching.

β€’ Learn when it’s boring
β€’ Practice when progress feels slow
β€’ Stay consistent when results aren’t visible

Perseverance compounds quietly.

If you can stay disciplined for long enough,
your career will look very different by the end of 2026.

No hacks.
No shortcuts.
Just consistency.πŸ”₯
❀2πŸ‘2
🚨 My FIRST YouTube Short is LIVE! 🚨

This one is about a simple SQL habit that can save you from serious data loss in production πŸ‘€

πŸ‘‰ Before you ever run a DELETE, make sure you’re doing this one thing.

πŸŽ₯ Watch here:
πŸ‘‰ One DELETE mistake can destroy your data 😬 | SQL
https://youtube.com/shorts/6AK2S2Qv5kU

If you’ve ever worked with real databases, this is a must-watch.
Drop a πŸ‘ or comment on YouTube if it helped you β€” it really supports the channel.

More real-world SQL Shorts coming soon πŸ”₯
❀4
Happy long weekend to all πŸ”₯πŸ”₯
Use this weekend to relax and upskill yourself
Hey Data Engineers

One individual from this community just had an Snowflake DBT interview with TCS,these are the main questions asked into him

Snowflake + dbt interview questions asked at TCS πŸ‘‡

These are not beginner-level questions β€” they test real production understanding.

β€’ Difference between Snowpipe vs COPY INTO
β€’ Can you clone a subset of a table in Snowflake?
β€’ Track column value changes (Apple β†’ Orange) using Streams + MERGE
β€’ Types of views in Snowflake and their use cases
β€’ What is CLUSTER BY and how many columns should be used?

β€’ Is a Stream a database object in Snowflake?
β€’How do you register a source in dbt?
β€’ Difference between external table and managed tables in snowflake?

https://www.linkedin.com/posts/adityabansal095_a-friend-of-mine-recently-interviewed-at-activity-7420836271784321024-WuGJ

If you can confidently answer these,
you’re already ahead of most candidates.

More Snowflake & dbt interview content coming soon πŸš€

#Snowflake #DBT #DataEngineering #SQLInterviews #TCS #Analytics #CareerGrowth
❀1
🧠 Amazon SQL Interview Challenge
This is an interesting challenge ,please take a look

Ever tried applying Pythagoras theorem in SQL? πŸ˜„

You’re given triangle sides stored row-wise and your task is to identify which CombinationID forms a right-angled triangle.

πŸ“ Rule to apply:
HΒ² = PΒ² + BΒ² (longest side matters!)



If this showed up in an interview, how would you approach it?

https://www.linkedin.com/posts/adityabansal095_sql-amazon-amazoninterview-activity-7422150064292282368-fT9O

#SQL #SQLInterview #AmazonInterview #DataEngineering #Analytics #SQLChallenge
πŸ“Š Weekend Upskilling Idea: Build a Real Data Portfolio

If you’re stuck on what dataset to use for your next project β€” this list will save you hours.

Pick one dataset aligned with the industry you want to work in and build something meaningful around it πŸ‘‡

πŸ› Retail
Online Retail Sales (500k+ transactions)
Great for customer segmentation & sales trends
πŸ”— https://lnkd.in/d6H26umG

πŸ₯ Healthcare
WHO Global Health Data (194 countries)
Perfect for time series & geo analysis
πŸ”— https://lnkd.in/dMfCuDqM

πŸ’° Finance
World Bank Open Data (GDP, inflation, trade)
Ideal for economic insights & forecasting
πŸ”— https://data.worldbank.org

πŸš• Transportation
NYC Taxi Trips (millions of rides)
Demand forecasting & pricing analysis
πŸ”— https://lnkd.in/deVUEmmC

🎡 Entertainment
Spotify Top Songs (audio features)
Clustering & recommendation systems
πŸ”— https://lnkd.in/d6u8BjxD

πŸ‘₯ HR & Workforce
Employee Attrition Dataset
Churn prediction & retention analysis
πŸ”— https://lnkd.in/dTgGKfDG

πŸ“£ Marketing
Marketing Campaign Data
Campaign ROI & customer profiling
πŸ”— https://lnkd.in/d_4MFM_j

πŸŽ“ Education
Student Performance Dataset
Predictive modeling & insights
πŸ”— https://lnkd.in/dFv24vAs

πŸ›’ E-Commerce
Amazon Product Reviews
Sentiment analysis & rating prediction
πŸ”— https://lnkd.in/dZMvTDNj

🚚 Logistics
Supply Chain Dataset
Cost optimization & efficiency analysis
πŸ”— https://lnkd.in/d_4MFM_j

πŸ’‘ Weekend reminder:
You don’t need to finish a full project in one go.
Just start β€” explore the data, ask questions, write a few queries.

Small effort this weekend = big confidence boost later πŸš€

Save this list and pick one dataset to work on.

#dataengineer #SQL #careers #projects #learning #upskill
❀2
🎯 Data Engineering Interview in 30 Days? Here’s the Game Plan.

If I had an interview next month, this is exactly how I’d prepare πŸ‘‡

🧠 Strengthen the Basics
β€’ Revise core SQL concepts
β€’ Solve 20–30 recent SQL questions
β€’ Practice 20–30 Python coding problems

⚑ Spark & Big Data
β€’ Understand PySpark fundamentals
β€’ RDDs vs DataFrames vs Datasets
β€’ Practice top PySpark programs

πŸ— Data Engineering Foundations
β€’ Revise Data Warehousing concepts
β€’ Understand your project’s data model
β€’ Review cloud services used

πŸ’» Practical Knowledge
β€’ Essential Linux commands
β€’ Be ready to explain your project clearly
β€’ Know your roles & responsibilities
β€’ Understand implementation details

πŸ“š Interview Readiness
β€’ Common DE interview questions
β€’ Read interview experiences of the target company

πŸ’‘ 30 days is more than enough β€” if you prepare with focus.

Start today. Small daily effort > last week panic πŸš€

#dataengineer #jobopportunity #learning #interview #SQLInterview
❀5
This media is not supported in your browser
VIEW IN TELEGRAM
When I give KT to my junior πŸ˜‚πŸ˜‚ on running the TRUNCATE statement
😁3
Hey Engineers
Another freelance opportunity

I have a friend who needs some one who is good at SQL,SSIS,SSRS ,PostGreSQL
and Airflow

The client wants to migrate existing SSIS ETL packages


Please ping me on linkedin if you are interested.
linkedin.com/in/adityabansal095

#hiring #freelancer #jobalert #jobopportunity #ETL #SQLCommunity
πŸ‘1
Hi

Hope you're doing well.

We’re currently hiring for a Senior Python Developer role with one of our global consulting firm clients in pan India location , for a high-impact InsurTech transformation project.

Role highlights:

5+ years of experience in Python backend development

Mandatory experience in insurance products (Life / Health / General Insurance)

Strong exposure to insurance systems, APIs, and backend platforms

Opportunity to work on a large-scale InsurTech program

Unique exposure to learn and work on new-age insurance platforms that are rapidly booming in the industry

This role offers both deep insurance domain exposure and future-facing platform learning, making it a strong long-term career opportunity.

If this aligns with your profile or career direction, I’d be happy to share more details.
Also, referrals are most welcome and truly appreciated.

Warm regards,
Soham Ganguly
EliteRecruitments
www.eliterecruitments.com
https://www.linkedin.com/company/eliterecruitments

#hiring #jobalert #jobopportunity #python
πŸ‘1
πŸ”₯ Fractal Data Engineer Interview (23 LPA + 2L Variable)

This wasn’t about textbook SQL.
It was about real-world data engineering.

Here’s how it went πŸ‘‡

πŸ“ž Screening
β†’ SQL + Python basics

πŸ’» Round 1
β†’ Medium SQL problem
β†’ PySpark optimization
β†’ Kafka architecture
β†’ Custom PySpark function

🧠 Round 2 (Technical Deep Dive)
β†’ My project architecture
β†’ Design a scalable ETL from scratch
β†’ Schema evolution in Delta Lake
β†’ Azure stack discussion

πŸ‘” Round 3 (Managerial)
β†’ Leadership + ownership
β†’ Live coding (ETL test cases)
β†’ Real production challenges

πŸ’‘ What they really tested:
Reliability. Scalability. Decision-making. Ownership.

Not memorized syntax.
πŸ‘3❀2
πŸ”₯ Cracked 100 DAX Interview Questions β€” Here’s What Actually Matters

Power BI interviews aren’t basic anymore.

If you’re preparing for Data Analyst or BI roles, these DAX concepts are non-negotiable:

βœ… SUM vs SUMX β€” Aggregation vs row-by-row evaluation
βœ… CALCULATE β€” The king of filter context
βœ… RANKX, FILTER, ALL, ALLEXCEPT β€” Core for dynamic reports
βœ… Time Intelligence β€” TOTALYTD, SAMEPERIODLASTYEAR, DATEADD
βœ… DIVIDE > / β€” Always handle division safely

DAX isn’t about memorizing formulas.
It’s about understanding context.

If you’re serious about cracking BI interviews, spend time mastering these this week. πŸš€
πŸ‘3
SQL Junction pinned Deleted message
SQL Junction pinned Deleted message
Whats your plan for this weekend?
Final Results
69%
Upskilling
21%
Cricket
7%
Netflix
3%
Trip
❀1πŸ‘1
Mine is cricket 🏏πŸ₯Ή
REPOSTING

🚨 New SQL Interview Video is LIVE! 🚨

Can you solve a real KPMG SQL interview question?

The task sounds simple…
But it tests your understanding of aggregation and logic πŸ‘€

πŸ‘‰ Calculate:
β€’ Total Rides
β€’ Won Rides
β€’ Lost Rides

Think it’s easy? Try solving it before watching.

πŸŽ₯ Watch now:
πŸ‘‰ https://youtu.be/tFaIBqj3jUI

After watching, tell me honestly β€”
Did you solve it correctly on your first attempt? 😏

More real-world SQL interview questions coming soon. Stay sharp. πŸ”₯
πŸ”₯2❀1