Database Normalization|Database Normalisation|database normalization tutorial for beginners|1NF,2NF

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 พ.ย. 2024

ความคิดเห็น • 29

  • @TechCoach
    @TechCoach  4 ปีที่แล้ว +4

    I missed 1 point ,If the data set size can be reduced considerably by normalization you should go for it. Snowflakes schema is based on similar premise where we normalize a dimension table in case it becomes too large because of frequent updates.

  • @surajpatil3579
    @surajpatil3579 3 ปีที่แล้ว +2

    Splendid explanation 👌 cleared my all doubts

  • @mousumibanerjee733
    @mousumibanerjee733 3 หลายเดือนก่อน +1

    Amazing explanation man , thanks a lot 🍻

    • @TechCoach
      @TechCoach  3 หลายเดือนก่อน

      I am glad I could help :)

  • @daniloalvaro2088
    @daniloalvaro2088 6 หลายเดือนก่อน +1

    the explanation is clear thank you

    • @TechCoach
      @TechCoach  6 หลายเดือนก่อน

      I am glad I could help :)

  • @mrarpitmore6189
    @mrarpitmore6189 4 ปีที่แล้ว

    Very important topic nice explanation

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว +1

      Thanks a lot buddy for the kind words, please share it with people who may find it helpful

    • @mrarpitmore6189
      @mrarpitmore6189 4 ปีที่แล้ว

      @@TechCoach sure.. Sir..

  • @mokshadakothari1265
    @mokshadakothari1265 3 ปีที่แล้ว

    Very clean and good presentation !

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks a lot for the kind words :)

  • @amitkumar-ev8im
    @amitkumar-ev8im 4 ปีที่แล้ว

    Very nice explanation,Could you please send the link of Denormalization

  • @narasimharaochlv3177
    @narasimharaochlv3177 4 ปีที่แล้ว

    Super explanation

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks a lot buddy for the kind words:)

  • @ramesh6176
    @ramesh6176 3 ปีที่แล้ว

    You are Awesome Boss... Take a bow. I just love your presentation.. Do you make power BI videos

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Hi Ramesh,
      I will be making them soon.

    • @ramesh6176
      @ramesh6176 3 ปีที่แล้ว

      @@TechCoach where do you stay. do you have Power BI experience and Data modelling..

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว +1

      Yes I do work on powerbi

    • @ramesh6176
      @ramesh6176 3 ปีที่แล้ว

      @@TechCoach Hi Vivek.. I have denormalized excel data source... Which also contain many slowly changing dimensions. Can you help me create perfect data modelling in power bi.. I need to create metrics and graphs on top of it

  • @sireeshaas7680
    @sireeshaas7680 4 ปีที่แล้ว +1

    Can you explain briefly about the initial terms you used in the video like - Functional transitive dependency,Multi value attribute ? We didn't get those even after video completion.

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว +2

      Hi Sireesha,
      I am working to complete this video series .
      I will be uploading video on each of the normal forms shortly

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว +2

      Hi Sireesha,
      I have uploaded the next video of the normalization series. will upload the remaining videos soon.

    • @sireeshaas7680
      @sireeshaas7680 4 ปีที่แล้ว

      @@TechCoach Sure, will check it out right now😊

  • @abheshkumar2232
    @abheshkumar2232 4 ปีที่แล้ว +1

    can you make a video bulk collect and forall statement plz

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Sure Abhesh, I will work on it.

  • @arunabhrana6087
    @arunabhrana6087 3 ปีที่แล้ว +1

    Please make a video on Denormalisation also, very good explanation

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      @ Arunabh,
      Sure I will complete this series soon.
      please consider subscribing to my new channel it will really help me
      th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

  • @nitinhellrider
    @nitinhellrider 4 ปีที่แล้ว

    Can you please also male video on all the normal forms.?

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Sure Nitin, I will be working on them this week