In this intermediate SQL video, learn joins, subqueries, regexp and much more.
🔥Get 20% OFF our SQL Course with code SQL20 at checkout: [ Ссылка ]
Download free geography table: [ Ссылка ]
Download free billionaires table:
[ Ссылка ]
Watch the SQL tutorial part 1 here: [ Ссылка ]
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: [ Ссылка ]
📈 The Complete Finance & Valuation Course: [ Ссылка ]
👉 Excel for Business & Finance Course: [ Ссылка ]
🚀 All our courses: [ Ссылка ]
SOCIALS:
📸 Instagram - [ Ссылка ]
🤳 TikTok - [ Ссылка ]
🧑💻 LinkedIn - [ Ссылка ]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:36 - REGEXP
3:31 - IF & CASE statements
6:47 - Subqueries
10:17 - JOINS
Intermediate SQL Tutorial (SQL Series Part 2)
Теги
sqlintermediate sqlsql joinsql joinssql inner joinregexp sqlfilter with regexpsubquerysubqueriessql subquerynested query sqlif statement sqlif conditionl sqlif else sqlcase statement sqlcase sqlinner join sqlleft joinright joinintermediate sql tutorialsql tutorialintermediate sql videomultiple tables sqlwork with multiple tables in sqlintermediate sql in 15 minuteslearn sql in 15 minutesadvanced sqljoins in sql