Перейти к содержимому

Intermediate SQL Tutorial (SQL Series Part 2)

Kenji Explains

0:00 / 0:00

Intermediate SQL Tutorial (SQL Series Part 2)

57 095 просмотров · 2 года назад
Kenji Explains
965 тыс. подписчиков
57 095 просмотров · 2 года назад
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/all-... 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