Intermediate SQL Tutorial (SQL Series Part 2)

In this intermediate SQL video, learn joins, subqueries, regexp and much more.
🔥Get 20% OFF our SQL Course with code SQL20 at checkout: www.careerprinciples.com/cour...
Download free geography table: careerprinciples.myflodesk.co...
Download free billionaires table:
careerprinciples.myflodesk.co...
Watch the SQL tutorial part 1 here: • Learn SQL Basics in Ju...
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:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Intro
0:36 - REGEXP
3:31​ - IF & CASE statements
6:47​ - Subqueries
10:17​ - JOINS

[@KenjiExplains]

🔥Get 20% OFF our SQL Course with code SQL20 at checkout: www.careerprinciples.com/courses/sql-for-business-analytics

[@serenetonero]

Is the coupon still valid?

[@ancientlessons]

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

[@willzinner8813]

part 3 please!

[@KenjiExplains]

Noted!

[@Babyk4315]

Good video please make a part 3!!

[@camlex6310]

Thank you for the part 2!! Really neat explanations

[@Helen.Channel988]

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

[@aditya3david]

Thanks Kenji you covered tons of concepts in 15 min

[@felixoluoch1371]

I wish I could like and subscribe twice, excellent!

[@kashifbhatti7287]

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

[@KenjiExplains]

Yes sir! Hope you found it helpful :)

[@mallikarjunshettar7976]

Explaination was too good brother, Thank you

[@masinalifestyle]

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

[@KenjiExplains]

Glad you like them!

[@victoriaalli8778]

Awaiting part 3 please

[@user-jk5gg8mv6n]

Thank you

[@KenjiExplains]

You're welcome!

[@aspectoflife]

greatest!

[@Thetoluomotayo]

This is a very good video!!

[@KenjiExplains]

I'm glad you like it!

[@tranceformeeer]

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

[@preetshah3793]

Thank you for this and waiting for part 3😂

[@raymondatampore9437]

Part 3 please Kenji

[@hussienrammal5797]

Do u have curses data analysis and finance excel?

[@vishal7269]

Next part please....

[@kalapalanivelu4139]

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😩

[@aishvaryasthana9089]

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

[@KenjiExplains]

Thank you! You can find a video on that here:
ua-cam.com/video/RAAwSmjlGoQ/v-deo.html

[@abrahammoruti5967]

Isn't regexp similar to like statement?

[@KenjiExplains]

Yes! Just has a bit more features but very similar :)

[@aymankhalaf757]

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

[@aymankhalaf757]

SQL20 is not working. is it invalid now?

[@yopiwijaya1905]

python pandas please

[@UtkarshKumar-mp2ls]

As usual 1st viewer 😅

[@KenjiExplains]

Thank you haha XD

[@jameshatfield6448]

thanks more sql please

[@araeisi]

when I want to insert Geography table nothing happens and get this instead
PREPARE stmt FROM 'INSERT INTO `richlist`.`billionaires` (`rank`,`finalWorth`,`category`) VALUES(?,?,?)'