Solving LeetCode SQL Problems | SQL Part 1/n

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

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

sgn_sabir
Автор

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:)

alfatmiuzma
Автор

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

vamsikrishna
Автор

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

hoozaifaansari
Автор

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

aashikanoongo
Автор

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

naseemmhd
Автор

Great video as always Sundas! Keep it up!

candidlyvivian
Автор

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 :)

muhammadfahadakram
Автор

Extremely helpful .. thank you very much

afreen
Автор

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

nismashakeer
Автор

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?

dakshbhatnagar
Автор

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

mayankpant
Автор

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

kishorer
Автор

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.

leetsqlcode
Автор

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?

bryanstark
Автор

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

kamalverma
Автор

Can you recommend more interactive platforms like LeetCode?

nilanjanadutta
Автор

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?

observer
Автор

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?

rameeniqbal
Автор

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.

bipashasikarwar
visit shbcf.ru