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! 🔗 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 🎉👀 IT’S HAPPENING!!! 👀🎉 Our January Jumpstart event is officially LIVE!!! Here's what you can expect this month… 🔓 FREE ACCESS TO 6 MAVEN EXCLUSIVE COURSES! During January Jumpstart, Free Users will have unlimited access to our Data Career Roadmap Learning Path! 📅 LIVE WORKSHOPS! Workshop your resume, portfolio, and LinkedIn profile with industry leaders! 🏆 WIN AWARDS! Join live sessions, engage with the community, and showcase the improvement you’ve made for your chance to earn the coveted January Jumpstart MVP award! 🛠️ LIMITED OFFER: BONUS CAREER COACHING SESSIONS! Be one of the first 50 people to purchase lifetime access or the cohort immersive 4-pack bundle during January Jumpstart, and receive a bonus offer of private, one-on-one career coaching from some of the biggest names in data! Are YOU ready to Jumpstart your January?! 👉 https://bit.ly/4fUE5o1 Hope to see you there! ⏱️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