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

Поделиться
HTML-код
  • Опубликовано: 21 ноя 2024

Комментарии • 25

  • @maneeshkbishnoi5481
    @maneeshkbishnoi5481 8 месяцев назад +4

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

  • @alessiotucci0
    @alessiotucci0 10 месяцев назад +10

    That's amazing content available for free on RUclips! 💰💰
    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! 👍

  • @vijayasruthi1637
    @vijayasruthi1637 8 месяцев назад +4

    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

  • @AmineHamdaoui-e6v
    @AmineHamdaoui-e6v 2 месяца назад +1

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

  • @justinwilkinson6300
    @justinwilkinson6300 9 месяцев назад +2

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

  • @vitorcosta8805
    @vitorcosta8805 9 месяцев назад +1

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

  • @matthiasnott
    @matthiasnott 9 месяцев назад +1

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

  • @MrAnmol1980
    @MrAnmol1980 9 месяцев назад +1

    Thank you for your contribution to better refined learning

  • @murilloandradef
    @murilloandradef 9 месяцев назад +1

    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
    @1622roma 2 месяца назад +1

    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
    @Funeral1000 8 месяцев назад +1

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

  • @LMGaming0
    @LMGaming0 4 месяца назад +1

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

  • @urvxfvdzrnp
    @urvxfvdzrnp 4 месяца назад +1

    Excellent 👌 ❤❤

  • @gralleg9634
    @gralleg9634 10 месяцев назад +1

    thanks from France

  • @Cahangir
    @Cahangir 7 месяцев назад +1

    Useful video, thanks.

  • @TechyBuild
    @TechyBuild 8 месяцев назад +1

    Amazing video!

    • @EcZachly_
      @EcZachly_  8 месяцев назад

      Thanks! What should I make next?

    • @TechyBuild
      @TechyBuild 8 месяцев назад +1

      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.

  • @scholaeinternational6063
    @scholaeinternational6063 8 месяцев назад +2

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

  • @necati.arslan
    @necati.arslan 10 месяцев назад +1

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

    • @EcZachly_
      @EcZachly_  10 месяцев назад

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

  • @alexoldfield373
    @alexoldfield373 8 месяцев назад +2

    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_
      @EcZachly_  7 месяцев назад

      Thanks for the feedback!

  • @RZhere21
    @RZhere21 8 месяцев назад +3

    Tbh worst explanation of these important concepts