DP-203: 34 - Common data transformations

Поділитися
Вставка
  • Опубліковано 2 лис 2024

КОМЕНТАРІ • 31

  • @mathiasphillips6842
    @mathiasphillips6842 6 місяців тому +3

    Thank you, Piotr, for all the hard work and dedication you've put into these videos. I passed DP-203 a while back, but I still find your new videos incredibly useful and relevant for real-life scenarios.

    • @TybulOnAzure
      @TybulOnAzure  6 місяців тому +1

      Thanks, that's super nice!

  • @DrDryEyez
    @DrDryEyez 6 місяців тому +4

    Dzięki wielkie za poświęcony czas na tą playlistę, fajnie tłumaczysz zagadnienia. Super też, że dodajesz rzeczy spoza samego egzaminu, ale użyteczne do roli. Subskrypcja i czekam na następne filmy, pozdrawiam!

  • @Kennyackrman
    @Kennyackrman 6 місяців тому +1

    Amazing work on this playlist, love how you share the practical examples from your work experience and the hands on teaching. Kudos!

  • @Ef-sy4qp
    @Ef-sy4qp 6 місяців тому +1

    As usual, thanks for the course!!

  • @heljava
    @heljava 5 місяців тому

    Thank you Piotr. Amazing as always.

  • @soumikmishra7288
    @soumikmishra7288 3 місяці тому

    Yes indeed it was super useful, and i could relate to it easily since this is what i work with every now and then in sql while debugging any sql issue and finding root cause. windows functions like ROW_NUMBER, RANK, DENSE_RANK etc are always handy.
    Can you suggest any book for this data transformation phase only? which covers getting data in df, different data transformation scenarios and logics to deal with, best practices and so on?
    Thanks again :)

    • @TybulOnAzure
      @TybulOnAzure  3 місяці тому

      Unfortunately, I don't recall any good book on this topic.

    • @soumikmishra7288
      @soumikmishra7288 3 місяці тому

      @@TybulOnAzure its alright, thank you!

  • @priyeshgupta1866
    @priyeshgupta1866 6 місяців тому +1

    hey there... just wanted to know that will you adding more videos in this playlist.. if yes how many more videos you are planning to add... I am preparing for DP 203 and i found your videos so helpful.. Im going through all your videos could you confirms by when this Playlist will end so that I can schedule the exam accordingly

    • @PhiNguyen-iz9go
      @PhiNguyen-iz9go 6 місяців тому

      I have the same question as @priyeshgupta. Hope to see your response, Piotr.
      Again I want to thank you for your efforts making this playlist, your explaination is super easy to follow which hardly to find elsewhere.

    • @TybulOnAzure
      @TybulOnAzure  6 місяців тому +1

      Yes! Definitely there will be more videos coming to the playlist as I'm still recording them. There's about 20 more videos that I plan to record so assuming weekly schedule it means 5 months for everything to be ready.
      If it is too long time for you - don't wait for me and just take the exam. In the worst case you would just retry it later.

    • @PhiNguyen-iz9go
      @PhiNguyen-iz9go 6 місяців тому

      @@TybulOnAzure
      Hope you're doing well Piotr.
      I'm wondering that if you can make a short-video showing all the topics that will be covered in this playlist (like an agenda)?
      So that we can find from other resources to learn ahead for the exams (and also prepare for DE interviews in my case) while waiting for your records. It would be a huge help and I'm really really appreciate that xD

    • @TybulOnAzure
      @TybulOnAzure  6 місяців тому +1

      The thing is that I don't have a final agenda created yet - it is kind of dynamic. I know more or less the areas I would like to cover, but it might change:
      1. Writing data to ADLSg2 from Azure Databricks.
      2. Azure Databricks Autoloader.
      3. Orchestrating Databricks notebooks.
      4. Introduction to DBT.
      5. Unity Catalog.
      6. Synapse Spark Pool.
      7. ADF Data Flows.
      8. Synapse Dedicated SQL Pool.
      9. SQL security topics.
      10. Databricks SQL Warehouse.
      11. Synapse Serverless SQL Pool.
      12. Streaming.
      13. Azure Stream Analytics.
      14. Purview.

    • @PhiNguyen-iz9go
      @PhiNguyen-iz9go 6 місяців тому

      Thank you for the preview, this helps me enough. Can't wait see the upcoming episodes xD

  • @kvsharish
    @kvsharish 3 місяці тому

    Amazing videos so far.. do you have similar tutorials for people who want to learn in depth SQL programming?

    • @TybulOnAzure
      @TybulOnAzure  3 місяці тому

      Thanks! Unfortunately, I don't have anything on SQL.

  • @stephenlewis9159
    @stephenlewis9159 Місяць тому

    Good set of videos on AZ data. The only improvement is that you stay zoomed in on parts of the Azure or Databricks portal windows so I sometimes got lost for which part you were using. When you make the video it is easy for you to see because its all in front of you, but not for us. You have a given us a restricted VIEW (joke).

    • @TybulOnAzure
      @TybulOnAzure  Місяць тому

      Oh, actually I was making those zooms on purpose so you can see the content better, especially on mobiles.

  • @chillvibe4745
    @chillvibe4745 6 місяців тому +1

    To the people who already attempted the exam - is it mostly Synapse?
    On Microsoft Learn - the learning path for DP-203 consists of mostly Azure Synapse.

    • @bakhtiyarjanmullajonov8838
      @bakhtiyarjanmullajonov8838 6 місяців тому +1

      Hello. I took my exam on 1 of May. It is not only about Azure Synapse. It involves everything mentioned in the DP -203 exam page.

    • @TybulOnAzure
      @TybulOnAzure  4 місяці тому +1

      Guys, please don't discuss exam questions as it violates Candidate Agreement: learn.microsoft.com/en-us/credentials/support/certification-exam-candidate-agreement

    • @bakhtiyarjanmullajonov8838
      @bakhtiyarjanmullajonov8838 4 місяці тому

      @@TybulOnAzure OK. Sorry for that.

  • @michaelbyron1426
    @michaelbyron1426 6 місяців тому

    nearly finished the sql book reading up on the t-sql now

    • @TybulOnAzure
      @TybulOnAzure  6 місяців тому

      And what do you think about this book? Is it useful?

    • @michaelbyron1426
      @michaelbyron1426 6 місяців тому

      @@TybulOnAzure it's pretty advanced, some of the concepts are hard to grasp but it is very extensive and the exercises help a lot

  • @chillvibe4745
    @chillvibe4745 6 місяців тому

    Hi Piotr
    Sorry if I keep asking stupid questions lol
    I started following along, I'm still on the videos with Azure Data Factory.
    I don't have the free one month anymore, I have the Pay as you go subscription.
    Is it a good idea after I'm done with some exercise to just delete the resource group and then next time deploy everything again?
    Or should I just leave the resource group?
    I just don't want to wake up one day and have to pay 300 eur for example or is this highly unlikely haha

    • @TybulOnAzure
      @TybulOnAzure  6 місяців тому

      I've just checked my bill for last three months (Jan - March 2024) for my DP-203 resource group and in total it was €57.
      Three most expensive components:
      1. ADF - €20.
      2. Virtual network (private endpoints) - €20.
      3. SQL DB - €13.
      So I would say that deleting and recreating resources is not that important.