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.

Видео Learn SQL: Beyond the Big 6 | Live Instruction (Dataset included!) канала Maven Analytics