SQL Pocket Guide author Alice Zhao compares the advantages of CTEs vs subqueries vs temp tables, introduces recursive CTEs and shares practical tips for when to use each one.

Helpful Links:

MySQL Specialist Learning Path:
https://mavenanalytics.io/path/mysql...

Follow Alice:
  / alicexzhao  

Follow Maven Analytics:
  / mavenanalytics  

Looking to learn (Excel/SQL) this summer? Join our upcoming Immersives and build jobready skils in just 10 weeks!
https://bit.ly/3wPwoPw

⏱ Timestamps ⏱
0:00: Intro
0:19: CTE basics
3:29: CTEs vs subqueries
4:11: More complex CTE examples
8:22: CTEs vs temp tables
9:10: Recursive CTEs
11:20: Window function example
12:09: Practical tips for when to use each one

At Maven Analytics, we empower everyday people with lifechanging data & AI skills.

Head to http://mavenanalytics.io and master indemand 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, expertled guided projects: https://mavenanalytics.io/guidedproj...