SQL Tips - Learn SQL: Beyond the Big 6 | Live Instruction (Dataset included!)

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo Dive a little deeper into SQL! In this video, Maven Instructor & author of SQL Pocket Guide Alice Zhao covers intermediate concepts including Joins, Unions, CTEs, window functions, and more. This was part of our SPRING SKILLUP event in April, featuring free access to 6 Maven Pro Courses and live learning sessions. Subscribe so you don’t miss out on future events! 🔗Helpful Resources 👉 Head to the Data Playground to download the Pixar Films Dataset: https://mavenanalytics.io/data-playground?order=date_added%2Cdesc&search=pixar%20films 👉 SQL Course Library: http://bit.ly/4eMhOtm 👉 Follow us on LinkedIn: https://www.linkedin.com/company/maven-analytics ⏱️ Timestamps: 00:00 - Intro 01:49 - Big 6 Review 05:02 - Functions — YEAR, FLOOR, REGXP 13:55 - JOIN vs UNION 19:40 - Timing Queries — EXPLAIN ANALYZE 28:30 - Subqueries vs CTEs 35:09 - Window Functions — ROW_NUMBER, LAG 41:11 - Final Takeaways 42:05 - Q&A Maven Analytics is an award-winning learning platform where individuals and teams build new skills, showcase work, and connect with experts around the world. We've helped 2M+ people build job-ready data literacy & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers. Start building life-changing skills for FREE at mavenanalytics.io.