Sumanshu Nankana

@UCjNw0PpE3gKX_GCKMkT2BUA - 1.9K subscribers

Hello Everyone 👋 नमस्ते 🙏 This channel is your resource for industry-tested technical knowledge. I focus on sharing the most useful information I've learned on the job. Dive into practical guides for Python, Git, Kafka, SQL, AWS, and DevOps tools like GitHub Actions. Let's learn the essential skills together. Subscribe to learn the skills employers are looking for!

Home Videos Live Playlists

Python # 0020 # Parquet Deep Dive: Row vs Column, Size Comparison (1M), & Partitioning (Pandas)

Python # 0020 # Parquet Deep Dive: Row vs Column, Size Comparison (1M), & Partitioning (Pandas) Sumanshu Nankana

5 views - 8 hours ago

GitHub # 0022 # Stop Setting Up Projects From Scratch - Use GitHub Template Repositories

GitHub # 0022 # Stop Setting Up Projects From Scratch - Use GitHub Template Repositories Sumanshu Nankana

7 views - 1 day ago

Python # 0019# TypeError: Object Not JSON Serializable? Here's The Fix! 🐍

Python # 0019# TypeError: Object Not JSON Serializable? Here's The Fix! 🐍 Sumanshu Nankana

12 views - 2 weeks ago

Number of Unique Subjects Taught by Each Teacher - Leetcode 2356 Explained (PostgreSQL)

Number of Unique Subjects Taught by Each Teacher - Leetcode 2356 Explained (PostgreSQL) Sumanshu Nankana

5 views - 2 weeks ago

TechGig # 1. Prime Code Champ | Game Center | Python Solution

TechGig # 1. Prime Code Champ | Game Center | Python Solution Sumanshu Nankana

8 views - 3 weeks ago

Leetcode # 20. Valid Parentheses | Python Solution

Leetcode # 20. Valid Parentheses | Python Solution Sumanshu Nankana

26 views - 1 month ago

Leetcode # 1209. Remove All Adjacent Duplicates in String II | Python Solution

Leetcode # 1209. Remove All Adjacent Duplicates in String II | Python Solution Sumanshu Nankana

3 views - 1 month ago

Leetcode # 1169. Invalid Transactions | Python Solution

Leetcode # 1169. Invalid Transactions | Python Solution Sumanshu Nankana

196 views - 2 months ago

Leetcode # 56. Merge Intervals | Python Solution

Leetcode # 56. Merge Intervals | Python Solution Sumanshu Nankana

9 views - 2 months ago

Leetcode # 3531. Count Covered Buildings | Python Solution

Leetcode # 3531. Count Covered Buildings | Python Solution Sumanshu Nankana

17 views - 2 months ago

Analyze Organization Hierarchy – LeetCode 3482 Explained (PostgreSQL)

Analyze Organization Hierarchy – LeetCode 3482 Explained (PostgreSQL) Sumanshu Nankana

78 views - 2 months ago

Product Sales Analysis III – LeetCode 1070 Explained (PostgreSQL)

Product Sales Analysis III – LeetCode 1070 Explained (PostgreSQL) Sumanshu Nankana

13 views - 2 months ago

Leetcode # 380. Insert Delete GetRandom O(1) | Python Solution

Leetcode # 380. Insert Delete GetRandom O(1) | Python Solution Sumanshu Nankana

8 views - 2 months ago

Python # 0018 # What Does {True: 1, 1: 'a', 1.0: 'b'} Print and WHY ?

Python # 0018 # What Does {True: 1, 1: 'a', 1.0: 'b'} Print and WHY ? Sumanshu Nankana

12 views - 3 months ago

Python # 0017 # What is Decorator Chaining? Which Order Do They Execute (Top-Down or Bottom-Up)?

Python # 0017 # What is Decorator Chaining? Which Order Do They Execute (Top-Down or Bottom-Up)? Sumanshu Nankana

9 views - 3 months ago

Find Golden Hour Customers – LeetCode 3705 Explained (PostgreSQL)

Find Golden Hour Customers – LeetCode 3705 Explained (PostgreSQL) Sumanshu Nankana

13 views - 3 months ago

Average Selling Price – LeetCode 1251 Explained (PostgreSQL)

Average Selling Price – LeetCode 1251 Explained (PostgreSQL) Sumanshu Nankana

14 views - 3 months ago

Actors and Directors Who Cooperated At Least Three Times – LeetCode 1050 Explained (PostgreSQL)

Actors and Directors Who Cooperated At Least Three Times – LeetCode 1050 Explained (PostgreSQL) Sumanshu Nankana

7 views - 3 months ago

Find Products with Valid Serial Numbers – LeetCode 3465 Explained (PostgreSQL Tutorial)

Find Products with Valid Serial Numbers – LeetCode 3465 Explained (PostgreSQL Tutorial) Sumanshu Nankana

54 views - 3 months ago

Find Students with Study Spiral Pattern – LeetCode 3617 Explained (PostgreSQL Tutorial)

Find Students with Study Spiral Pattern – LeetCode 3617 Explained (PostgreSQL Tutorial) Sumanshu Nankana

73 views - 3 months ago

Project Employees I – LeetCode 1075 Explained (PostgreSQL Tutorial)

Project Employees I – LeetCode 1075 Explained (PostgreSQL Tutorial) Sumanshu Nankana

3 views - 3 months ago

Customer Who Bought All Products – LeetCode 1045 Explained (PostgreSQL Tutorial)

Customer Who Bought All Products – LeetCode 1045 Explained (PostgreSQL Tutorial) Sumanshu Nankana

1 views - 3 months ago

Find Invalid IP Addresses – LeetCode 3451 Explained (PostgreSQL Tutorial)

Find Invalid IP Addresses – LeetCode 3451 Explained (PostgreSQL Tutorial) Sumanshu Nankana

28 views - 3 months ago

Not Boring Movies – LeetCode 620 Explained (PostgreSQL Tutorial)

Not Boring Movies – LeetCode 620 Explained (PostgreSQL Tutorial) Sumanshu Nankana

2 views - 3 months ago

Swap Salary – LeetCode 627 Explained (PostgreSQL Tutorial)

Swap Salary – LeetCode 627 Explained (PostgreSQL Tutorial) Sumanshu Nankana

6 views - 3 months ago

First Letter Capitalization II – LeetCode 3374 Explained (PostgreSQL Tutorial)

First Letter Capitalization II – LeetCode 3374 Explained (PostgreSQL Tutorial) Sumanshu Nankana

48 views - 3 months ago

Odd and Even Transactions SQL Solution – LeetCode 3220 Explained (PostgreSQL Tutorial)

Odd and Even Transactions SQL Solution – LeetCode 3220 Explained (PostgreSQL Tutorial) Sumanshu Nankana

7 views - 3 months ago

Calculate Special Bonus SQL Solution – LeetCode 1873 Explained (PostgreSQL Tutorial)

Calculate Special Bonus SQL Solution – LeetCode 1873 Explained (PostgreSQL Tutorial) Sumanshu Nankana

2 views - 3 months ago

Movie Rating SQL Solution – LeetCode 1341 Explained (PostgreSQL Tutorial)

Movie Rating SQL Solution – LeetCode 1341 Explained (PostgreSQL Tutorial) Sumanshu Nankana

18 views - 3 months ago

Biggest Single Number SQL Solution – LeetCode 619 Explained (PostgreSQL Tutorial)

Biggest Single Number SQL Solution – LeetCode 619 Explained (PostgreSQL Tutorial) Sumanshu Nankana

4 views - 3 months ago

Exchange Seats SQL Solution – LeetCode 626 Explained (PostgreSQL Tutorial)

Exchange Seats SQL Solution – LeetCode 626 Explained (PostgreSQL Tutorial) Sumanshu Nankana

7 views - 3 months ago

Triangle Judgement SQL Solution – LeetCode 610 Explained (PostgreSQL Tutorial)

Triangle Judgement SQL Solution – LeetCode 610 Explained (PostgreSQL Tutorial) Sumanshu Nankana

7 views - 3 months ago

Sales Person SQL Solution – LeetCode 607 Explained (PostgreSQL Tutorial)

Sales Person SQL Solution – LeetCode 607 Explained (PostgreSQL Tutorial) Sumanshu Nankana

19 views - 3 months ago

Tree Node SQL Solution – LeetCode 608 Explained (PostgreSQL Tutorial)

Tree Node SQL Solution – LeetCode 608 Explained (PostgreSQL Tutorial) Sumanshu Nankana

5 views - 3 months ago

Classes With at Least 5 Students SQL Solution – LeetCode 596 Explained (PostgreSQL Tutorial)

Classes With at Least 5 Students SQL Solution – LeetCode 596 Explained (PostgreSQL Tutorial) Sumanshu Nankana

3 views - 3 months ago

Customer Placing The Largest Number Of Orders – LeetCode 586 Explained (PostgreSQL Tutorial)

Customer Placing The Largest Number Of Orders – LeetCode 586 Explained (PostgreSQL Tutorial) Sumanshu Nankana

4 views - 3 months ago

Game Play Analysis IV SQL Solution – LeetCode 550 Explained (PostgreSQL Tutorial)

Game Play Analysis IV SQL Solution – LeetCode 550 Explained (PostgreSQL Tutorial) Sumanshu Nankana

8 views - 3 months ago

Game Play Analysis I SQL Solution – LeetCode 511 Explained (PostgreSQL Tutorial)

Game Play Analysis I SQL Solution – LeetCode 511 Explained (PostgreSQL Tutorial) Sumanshu Nankana

5 views - 3 months ago

Investments in 2016 SQL Solution – LeetCode 585 Explained (PostgreSQL Tutorial)

Investments in 2016 SQL Solution – LeetCode 585 Explained (PostgreSQL Tutorial) Sumanshu Nankana

5 views - 3 months ago

Human Traffic of Stadium SQL Solution – LeetCode 601 Explained (PostgreSQL Tutorial)

Human Traffic of Stadium SQL Solution – LeetCode 601 Explained (PostgreSQL Tutorial) Sumanshu Nankana

10 views - 3 months ago

Trips and Users SQL Solution – LeetCode 262 Explained (PostgreSQL Tutorial)

Trips and Users SQL Solution – LeetCode 262 Explained (PostgreSQL Tutorial) Sumanshu Nankana

8 views - 3 months ago

Python # 0016 # Can we create a set of lists in Python ?

Python # 0016 # Can we create a set of lists in Python ? Sumanshu Nankana

36 views - 4 months ago

Duplicate Emails SQL Solution – LeetCode 182 Explained (PostgreSQL Tutorial)

Duplicate Emails SQL Solution – LeetCode 182 Explained (PostgreSQL Tutorial) Sumanshu Nankana

7 views - 4 months ago

Friend Request II: Who has the most Friends Solution – LeetCode 602 Explained (PostgreSQL Tutorial)

Friend Request II: Who has the most Friends Solution – LeetCode 602 Explained (PostgreSQL Tutorial) Sumanshu Nankana

3 views - 4 months ago

Python # 0015 # Implement a Decorator in Python

Python # 0015 # Implement a Decorator in Python Sumanshu Nankana

1 views - 4 months ago

Delete Duplicate Emails SQL Solution – LeetCode 196 Explained (PostgreSQL Tutorial)

Delete Duplicate Emails SQL Solution – LeetCode 196 Explained (PostgreSQL Tutorial) Sumanshu Nankana

10 views - 4 months ago

Employees Earning More Than Their Managers–LeetCode 181 Explained (PostgreSQL Tutorial) (PostgreSQL)

Employees Earning More Than Their Managers–LeetCode 181 Explained (PostgreSQL Tutorial) (PostgreSQL) Sumanshu Nankana

10 views - 4 months ago

Department Top Three Salaries SQL Solution – LeetCode 185 Explained (PostgreSQL Tutorial)

Department Top Three Salaries SQL Solution – LeetCode 185 Explained (PostgreSQL Tutorial) Sumanshu Nankana

12 views - 4 months ago

Customers Who Never Order SQL Solution – LeetCode 183 Explained (PostgreSQL Tutorial)

Customers Who Never Order SQL Solution – LeetCode 183 Explained (PostgreSQL Tutorial) Sumanshu Nankana

8 views - 4 months ago

Consecutive Numbers SQL Solution – LeetCode 180 Explained (PostgreSQL Tutorial)

Consecutive Numbers SQL Solution – LeetCode 180 Explained (PostgreSQL Tutorial) Sumanshu Nankana

22 views - 4 months ago

Department Highest Salary SQL Solution – LeetCode 184 Explained (PostgreSQL Tutorial)

Department Highest Salary SQL Solution – LeetCode 184 Explained (PostgreSQL Tutorial) Sumanshu Nankana

11 views - 4 months ago

Combine Two Tables SQL Solution – LeetCode 175 Explained (PostgreSQL Tutorial)

Combine Two Tables SQL Solution – LeetCode 175 Explained (PostgreSQL Tutorial) Sumanshu Nankana

23 views - 4 months ago

Rank Scores SQL Solution – LeetCode 178 Explained (PostgreSQL Tutorial)

Rank Scores SQL Solution – LeetCode 178 Explained (PostgreSQL Tutorial) Sumanshu Nankana

4 views - 4 months ago

Nth Highest Salary SQL Solution – LeetCode 177 Explained (PostgreSQL Tutorial)

Nth Highest Salary SQL Solution – LeetCode 177 Explained (PostgreSQL Tutorial) Sumanshu Nankana

39 views - 4 months ago

Second Highest Salary SQL Solution – LeetCode 176 Explained (PostgreSQL Tutorial)

Second Highest Salary SQL Solution – LeetCode 176 Explained (PostgreSQL Tutorial) Sumanshu Nankana

11 views - 4 months ago

Leetcode # 703. Kth Largest Element in a Stream | Python Solution | Heapq

Leetcode # 703. Kth Largest Element in a Stream | Python Solution | Heapq Sumanshu Nankana

12 views - 4 months ago

Leetcode # 215. Kth Largest Element in an Array | Python Solution | Heapq

Leetcode # 215. Kth Largest Element in an Array | Python Solution | Heapq Sumanshu Nankana

21 views - 4 months ago

Leetcode # 468. Validate IP Address | Python Solution Explained

Leetcode # 468. Validate IP Address | Python Solution Explained Sumanshu Nankana

25 views - 5 months ago

Kafka # 028 # ksqlDB : CREATE TABLE, CTAS, Persistent vs Pull vs Push Queries

Kafka # 028 # ksqlDB : CREATE TABLE, CTAS, Persistent vs Pull vs Push Queries Sumanshu Nankana

70 views - 6 months ago

Kafka # 028 # Flatten Nested Data in ksqlDB Using EXPLODE Function and CREATE STREAM AS SELECT

Kafka # 028 # Flatten Nested Data in ksqlDB Using EXPLODE Function and CREATE STREAM AS SELECT Sumanshu Nankana

36 views - 6 months ago