Intermediate SQL Tutorial (SQL Series Part 2)

In this intermediate SQL video, learn joins, subqueries, regexp and much more.

Download free billionaires table:

In this intermediate SQL video, we'll go over 4 essential concepts. These are the REGEXP to do some advanced filtering, the IF & CASE statements for creating new categories, SUBQUERIES for complex data analysis, and JOINS for working with multiple tables. To make this realistic, we'll work with a real dataset on billionaires using multiple tables.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Intro
0:36 - REGEXP
3:31​ - IF & CASE statements
6:47​ - Subqueries
10:17​ - JOINS

[ancientlessons]

more on sql tutorial Kenji, we really love how simple you explain everything in your videos

[camlex]

Thank you for the part 2!! Really neat explanations

[Helen.Channel]

Kenji, you're the best. I really love to take your course but I am not capable at the moment, continue the good work man. Thank you

[shikohshee]

Hi Kenji😊. These videos are great! Please post a part 3🥺

[adityadavid]

Thanks Kenji you covered tons of concepts in 15 min

[felixoluoch]

I wish I could like and subscribe twice, excellent!

[LifestyleofMasina]

You are such a great teacher and i find your tutorials incredibly helpful.

[kashifbhatti]

2nd 🙋🏻‍♂️
Glad that you actually made 2nd part i asked week ago..

[mallikarjunshettar]

Explaination was too good brother, Thank you

[dilipkrishna]

Thanks for the wonderful video brother! Expecting a unique SQL and POWER BI end to end project from your channel

[martysonn]

"You can see all these people are high" made me giggle.
I'm childish, don't judge me

[Ayesha_]

Very Well! Thankyou, Kenji
But why you stopped?😢

[tranceformeeer]

Please make part 3 and also 4, 5 and 6! :D

[hussienrammal]

Do u have curses data analysis and finance excel?

[aishvaryasthana]

Your teaching method is excellent, pls also introduce python for data analysis.

[carloschacin]

Whats the difference between using case statements and if with elseifs

[kalapalanivelu]

Hi Kenji, I need some help on highlighting. How do I highlight a range of duplicate cells alternately without using the format painter.
Simon
Simon
Simon

Robert
Robert
Robert
Robert

Michael
Michael
Michael
Michael
Michael
Michael
I want to highlight the range Simon and leave Robert blank and then highlight Michael again.

Pls help😩

[preetshah]

Thank you for this and waiting for part 3😂

[abrahammoruti]

Isn't regexp similar to like statement?

[aymankhalaf]

@KenjiExplains, Love your content, could you validate the 20% off so I can take your course please. :)