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/cour...
Download free geography table: https://careerprinciples.myflodesk.co...
Download free billionaires table:
https://careerprinciples.myflodesk.co...
Watch the SQL tutorial part 1 here: • Learn SQL Basics in Just 15 Minutes!
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/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses
SOCIALS:
Instagram https://www.instagram.com/careerprinc...
TikTok / career_principles
LinkedIn / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 Intro
0:36 REGEXP
3:31 IF & CASE statements
6:47 Subqueries
10:17 JOINS