Adarsh Yadav, Author at TheAdarshLife

17 May

Mastering SQL & PySpark Interview Questions: Identify Top 80% Sales-Contributing Products with Window Functions

May 17, 2026
By Adarsh Yadav
214 comments

Mastering SQL & PySpark Interview Questions: Identify Top 80% Sales-Contributing Products with Window Functions Introduction In th...

13 May

Uncategorized

Mastering SQL & PySpark Interview Questions: Find the N-th Saturday on or After a Given Date

May 13, 2026
By Adarsh Yadav
2 comments

Mastering SQL & PySpark Interview Questions: Find the N-th Saturday on or After a Given Date Introduction In the world of data engi...

23 Apr

Uncategorized

Mastering SQL & PySpark Interview Questions: How to Find Users’ Most Visited Floor, Total Visits & Unique Resources

April 23, 2026
By Adarsh Yadav
5 comments

Mastering SQL & PySpark Interview Questions: How to Find Users' Most Visited Floor, Total Visits & Unique Resources Introductio...

01 Jun

Fabric Data Engineering, SQL

How to crack Data engineer SQL Interview -Day 3/60 Challenge

June 1, 2025
By Adarsh Yadav
5 comments

Hey there, future data engineers! I'm Adarsh Yadav, a data engineer who's navigated the tough world of tech inter...

26 May

Fabric Data Engineering, SQL, Uncategorized

Data Engineer Interview SQL Question-Day 2

May 26, 2025
By Adarsh Yadav
12 comments

Hey there, future data engineers! I'm Adarsh Yadav, a data engineer who's navigated the tough world of tech inter...

24 May

SQL

Data Engineer Interview SQL Question-Day 1

May 26, 2025
By Adarsh Yadav
25 comments

Hey there, future data engineers! I’m Adarsh Yadav, a data engineer who’s navigated the tough world of tech inter...

24 May

Data Bricks

How to Achieve Parallelism in Databricks Jobs for data engineer

May 25, 2025
By Adarsh Yadav
0 comments

The Problem: Running Multiple JAR Files in Parallel In my project, ...

02 Mar

Fabric Data Engineering

Unlock the Power of Data Warehouse on Microsoft Fabric: The Future of Scalable Analytics

March 2, 2025
By Adarsh Yadav
3 comments

Microsoft Fabric is revolutionizing the way organizations handle data, and its Data Warehouse offering is a cruci...

16 Nov

Uncategorized

Introduction to PySpark an easy way

November 17, 2024
By Adarsh Yadav
2 comments

Welcome to PySpark! If you’re ready to dive into the world of big data, you’re in the right place. PySpark is whe...

Pages: 1 2

02 Nov

Cloud

Creating External File Formats in using (Transact-SQL)

November 2, 2024
By Adarsh Yadav
899 comments

Creating an external file format in T-SQL is essential when working with Azure SQL Data Warehouse and Azure Synap...