In this intermediate SQL video, learn joins, subqueries, regexp and much more.
Get 20% OFF our SQL Course with code SQL20 at checkout: https://www.careerprinciples.com/courses/sql-for-business-analytics

Download free geography table: https://careerprinciples.myflodesk.com/y9jthmyf3f

Download free billionaires table:
https://careerprinciples.myflodesk.com/wandnfcrg2

Watch the SQL tutorial part 1 here: https://youtu.be/wmiDdBG-yP4
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: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑‍ LinkedIn - https://www.linkedin.com/company/careerprinciples/

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

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