Master 12 Advanced SQL Concepts in 20 Minutes 📊

Level up your SQL skills in just 20 minutes with SQL Pocket Guide author, Alice Zhao.

In this video, we'll cover 12 advanced SQL concepts:
✔ UNION
✔ UNION ALL
✔ Subqueries
✔ LEFT JOIN
✔ INNER JOIN
✔ CTEs
✔ Recursive CTEs
✔ Date Expressions
✔ CAST
✔ COALESCE
✔ ROUND
✔ Window Functions

…all in less than 20 minutes!


Who says a 🎉 BLACK FRIDAY SALE 🎉 has to wait until the end of November?!
Because we know that e-learning isn’t one-size-fits-all, we’ve got some awesome options for you to choose from:
👉 25% off your first 3 months!
👉 50% off for the whole year!
👉 50% off for LIFE!
All Maven memberships include:
✓ Unlimited access to ALL courses & paths
✓ Customized learning plans
✓ Guided projects
✓ Skills assessments
✓ Showcase portfolio builder
✓ Free practice data sets
✓ Private student dashboard
✓ Live instructor chat support
If you're looking to build expert-level data skills, or if you've considered joining our Excel, SQL, Power BI, Tableau, or Python courses in the past, NOW is the time to get on board!
SIGN UP TODAY: https://bit.ly/47rTfP9

Hope to see you there!

🔗 Helpful links:

👉 Downloadable project file: https://maven-datasets.s3.us-east-1.amazonaws.com/YouTube+Downloads/maven_advanced_sql_demo.sql

👉 Advanced SQL Querying Course:
Maven: https://bit.ly/4amQMqA
Udemy: https://bit.ly/40A6ZVW

👉 MySQL Specialist Path: https://bit.ly/4gghp1L

👉 Follow us on LinkedIn:

Alice: https://www.linkedin.com/in/alicexzhao/

Maven Analytics: https://www.linkedin.com/company/maven-analytics

⏱️Timestamps ⏱️
0:00 Intro
01:05 UNION vs UNION ALL
03:01 Subqueries
04:14 LEFT JOIN vs INNER JOIN
06:44 CTEs
10:02 Recursive CTEs
11:16 Date Expressions
12:16 CAST
14:28 COALESCE
15:55 ROUND
16:33 Window Functions (ROW_NUMBER, LAG & LEAD)
19:35 Final Query
21:09 Outro

At Maven Analytics, we empower everyday people with life-changing data & AI skills.

Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE!

Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: https://mavenanalytics.io/guided-projects