Rahul Upadhyay

929 subscribers

92 videos

Hello, I am Rahul Upadhyay. I have 10 years of experience in IT industry and I am Data Engineer by profession. I am thrilled to share my knowledge and learni...

Latest Videos

Find Maximum Unique ID in SQL Handling Duplicates Efficiently

Calculate Monthly Sales from YTD Sales Using SQL LAG Window Function

Generate Movie Theatre Seat Numbers Using SQL Recursive CTE Approach

Check If a Word Is a Palindrome Using SQL Recursive CTE Approach

Merge Employee Data UNION vs JOIN Explained in SQL Handling New & Existing Records

Sort and Aggregate Emails by Team in SQL STRING AGG & GROUP BY Explained

Find Manager and Senior Manager for Employees Using SQL SQL Self Join

SQL Query to Pair Adults with Children Based on Age SQL Window Functions & Ranking

SQL Query to Find Employees with Only Outstanding Awards SQL Aggregation & Filtering

SQL Aggregation Transaction Analysis by Month and Country

Find Number of No Sale Days with Gaps Using SQL CTE & Window Functions

Generate Fibonacci Series in SQL Recursive CTE Example

Find Employees Without Promotion for 3+ Years Using SQL Window Functions & Joins

Find 3 or More Consecutive Vacant Seats Using SQL Window Functions & Row Number

🏆 Find Subject Toppers in SQL ROW_NUMBER() & Aggregation SQL Problem Solving

Generate Pattern from String Using SQL Recursive CTE in SQL SQL Problem Solving

Calculate Total Business Days Excluding Weekends & Holidays Using SQL

Find Stocks with Increasing Prices for 3 or More Consecutive Days Using SQL

Find Number of Months a Customer Placed an Order Using SQL SQL Aggregation & GROUP BY

Find Customer Start & End Points from Flight Data Using SQL

How to Calculate First Time City Visits Year Wise in SQL SQL Problem Solving with CTEs

Determining Organizational Hierarchy with Recursive CTEs

SQL Query to Find Customers Buying Specific Products A Step-by-Step Guide

Monthly Sales Aggregation Made Simple using CASE and PIVOT

Mastering SQL Unpivoting Two Simple Approaches to Reshape Your Data

Analyze Total Calls and Call Durations Between Individuals in SQL

Generate Alphabet Sequence Pairs in SQL Recursive CTE for AA-ZZ Pattern

Find First and Last Purchases for Each Customer Row_Number vs First_Value & Last_Value

Spark Scala Tutorial Data Transformation with Split and concat_ws Functions Full Name Composition

Spark Scala Tutorial Quick DataFrame and RDD Creation Sample Records Testing