Solving LeetCode SQL Problems | SQL Part 1/n

Hi friends, I am starting this SQL LeetCode practice series and I selfishly want to brush up on my interview skills and and help you learn along the process. Let me know in comments if this was useful and if you want more of this.

~~~ CERTIFICATES & COURSES ~~~

DATA SCIENTIST

DATA ANALYTICS

PYTHON

SQL

MACHINE LEARNING

STATISTICS

Excel

~~~~~~~~~~~~~~~~~~~~~~~~~~~

MY FAVORITE GEAR

MY FAVORITE SOFTWARE

LET'S BE FRIENDS

SUBSCRIBE FOR MORE VIDEOS

0:00 intro
2:16 join two tables
6:46 learnings

BINGE THESE PLAYLISTS NEXT

ABOUT ME
I'm Sundas. I'm a self-taught data scientist from a non-tech background, currently at a FAANG company. I have been in the industry for over 8 years spread across two big tech companies. On this channel, I share tips for people interested in entering data science with the goal to democratize knowledge and make complicated topics digestible for everyone. All opinions are mine!

PS. Some of the links included are affiliate links and help me keep this channel going. Thanks for the support.

#sql #datascience #interviewprep

[sgn_sabir]

I am learning sql and was looking for such guidance, which I have got now. Thank you waiting for more videos

[alfatmiuzma]

Thanks! Please make a series of "Practice with me -SQL/Python/Data science Algos" .It will be much appreciated. It is fun to work with you side by side, as I did with this video:)

[vamsikrishna]

Thanks..You should continue these videos of solving SQL Leetcode problems.

[hoozaifaansari]

This was super helpful. Please add more videos in this series.

[aashikanoongo]

This is a great idea!!! I love that you keep it so real

[naseemmhd]

This is a really good initiative.. hoping for more videos like this...

[candidlyvivian]

Great video as always Sundas! Keep it up!

[muhammadfahadakram]

you have great knowledge and experience please do a series of SQL, python and its Algorithms, I am sure you lectures 'll do best due to you strong professional skill :)

[afreen]

Extremely helpful .. thank you very much

[nismashakeer]

It would be really helpful if u could do a video on how to install SQL on mac :)

[dakshbhatnagar]

Hey, This was definitely a change of pace from how you usually do your vids. Just a question why was there a left join and not a right join or inner join?

[mayankpant]

Lmao, i thought u will solve atleast 2-3 medium to difficult question but you straight up went to easy and that too solved only one. Kudos

[kishorer]

Hi which is the best site to practice problems? Leetcode or anyother sites?

[leetsqlcode]

Apart from leetcode, what else would you suggest that we practice for sql. My question is geared towards loop round sql questions at MNG that are more like self updating aggregate tables etc.

[bryanstark]

That's interesting, I never tried leetcode for SQL before. I would have used ISNULL on the Address and State just as a habit. A lot of people don't like to see "null" values. Would that get marked wrong?

[kamalverma]

Hi Sundas, could you please tell me the best book to start python and data science?

[nilanjanadutta]

Can you recommend more interactive platforms like LeetCode?

[observer]

0:48 so you are saying that you actually don't need the things you are going to be solving in these videos at your job? Since I know that you are not interested in data engineering jobs but front-facing jobs, which you don't need to know SQL queries?

[rameeniqbal]

Hello sister.. i have completed coursera data analytics course from google..i need yourr i want to be perfect in SQL AND R .what should i do now?

[bipashasikarwar]

I can't able to understand the sql question i understand ....then again in my test i unable to write query unable to execute them.