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

[@user-vo9ud7in1i]

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!

[@mallikarjunshettar7976]

Explaination was too good brother, Thank you

[@kashifbhatti7287]

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

[@KenjiExplains]

Yes sir! Hope you found it helpful :)

[@masinalifestyle]

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

[@KenjiExplains]

Glad you like them!

[@tranceformeeer]

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

[@victoriaalli8778]

Awaiting part 3 please

[@preetshah3793]

Thank you for this and waiting for part 3😂

[@hussienrammal5797]

Do u have curses data analysis and finance excel?

[@aishvaryasthana9089]

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

[@KenjiExplains]

Thank you! You can find a video on that here: kzbin.info/www/bejne/iHKkqIajn9F6pbM

[@Thetoluomotayo]

This is a very good video!!

[@KenjiExplains]

I'm glad you like it!

[@user-jk5gg8mv6n]

Thank you

[@KenjiExplains]

You're welcome!

[@raymondatampore9437]

Part 3 please Kenji

[@aspectoflife]

greatest!

[@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😩

[@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