SQL Window Functions (LEAD/LAG and RANK) and Common Table Expressions in 60 minutes on DataExpert.io

[@alessiotucci0]

That's amazing content available for free on KZbin! 💰💰 Thank you for sharing these SQL lectures for free. The clarity in your explanations and the practical examples you provide make complex SQL concepts easy to understand. I'm looking forward to more educational content from your channel. Keep up the great work! 👍

[@maneeshkbishnoi5481]

What an insightful video! As someone deeply involved in data engineering, it's refreshing to find such high-quality content. Thanks Zach.

[@AmineHamdaoui-e6v]

Super useful thanks, it works even without using the LAG/LEAD function here thanks to the streak identifier, did it and it worked

[@vitorcosta8805]

Tyvm Zach, I’m a swe and I love to follow your content

[@matthiasnott]

Zach, cool. Would be great to see the complete sql you wrote, to get the pattern of consecutive CTEs syntactically right.

[@murilloandradef]

you are lit, Zach. i wish the best for you and your journey. hope you can still teaching us for a long time, thx for it

[@1622roma]

It is amazing content and I enjoyed listening to you. Could you please do another video, but this time mini step by step. This one went by too fast.

[@Funeral1000]

Hi Zach I like the video thank you .I am new in this data discipline .

[@vijayasruthi1637]

This explanation has helped me gain a clear understanding; I don't think I will ever forget or get confused now. Thank you so much Zach

[@Cahangir]

Useful video, thanks.

[@urvxfvdzrnp]

Excellent 👌 ❤❤

[@scholaeinternational6063]

great teacher great tutorial but we could not see your coding area which was very important and would have made the tutorial more enjoyable

[@TechyBuild]

Amazing video!

[@EcZachly_]

Thanks! What should I make next?

[@TechyBuild]

Your post on Building a data pipeline and automating it really helped me to build a stock data pipeline using REST API and storing it to CSV. Maybe a complete project on automation would help. Thanks so much for all you do! I am transitioning to data engineering from data analyst.

[@necati.arslan]

Zak what was the tech stack you used in this session ?

[@EcZachly_]

DataExpert.io uses Trino for querying and Apache Iceberg for storage

[@alexoldfield373]

at 30:50 the query is so long, the query box is so small, and you jump all over the place it becomes super hard to follow. Otherwise great video.

[@EcZachly_]

Thanks for the feedback!

[@justinwilkinson6300]

Great lesson Zach! Very informative and easy to follow along with.

[@LMGaming0]

Amazing video, always learning a lot from you, thanks!

[@MrAnmol1980]

Thank you for your contribution to better refined learning

[@gralleg9634]

thanks from France

[@RZhere21]

Tbh worst explanation of these important concepts

[@EcZachly_]

Thanks!