SQL WITH Clause | Clearly Explained | CTEs vs Subqueries vs Temp Tables | Recursive CTEs

preview_player
Показать описание
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:

👉 Follow Alice:

👉 Follow Maven Analytics:

👀 Looking to learn (Excel/SQL) this summer? Join our upcoming Immersives and build job-ready skils in just 10 weeks!

⏱️ 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 life-changing data & AI skills.

Рекомендации по теме
Комментарии
Автор

I was watching other videos before this one, and I just couldn't wrap my head around it, and this video was clear as crystal

longinos
Автор

This is an awesome video. the material she covers clearly in 30 minutes will take one hours to study on their own

sambacarlson
Автор

This is so clearly explained and concise. Thanx a bunch ma'am!

torpedoe
Автор

Wow! Thank you so much for the explanation, definitely helped me understand everything much better

Valeria-vfbx
Автор

Amazing explanation as always! The most complete and clear video about this topic. Thank you Alice!

rodrigochavez
Автор

Hi, this video was really helpful, despite is not i'm My mother language, the logic that You provide is clearly than in spanish

JoelPasapera
Автор

Finally, I can now see and understand subqueries. Thank you.

momohtimothy
Автор

Awesome tutorial, crystal clear a d concise. Well done.
1. CTE is elegant. I would go for CTE when the first query returns a table, and go for subquery when the result set of the first query goes into select or where clauses as sclares or list/tuple.
2. Can get access to the dataset used here.
3. I quickly took a glance. At your SQL trainning program and it seems you dive deep and cover quite a lot than most SQL trainning programs in the market. Please advise the rate.
Thank u

osoriomatucurane
Автор

WOW!!!! that was amazing, I learned a lot. Thank so much. Got a new sub here.

gospelmoto
Автор

Hello, very clear explantion !! what software do you use ?

SM-vzek
Автор

At long last, I have met a good teacher 😂. Thank you so much ma'am 🎉

Dadzie.emmanuel
Автор

Where can I find your SQL courses? Where you're teaching as a instructor.

Bhaskar_Joshi_there
Автор

a CTE must be advanced because I'm confused.... I'll have to re-watch a bunch of times until I understand

diamondsandlipgloss
welcome to shbcf.ru