Learn 12 Advanced SQL Concepts in 20 Minutes (project files included!)

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