Data Normalization vs Denormalization - Which is better when ?

Data Normalization vs Denormalization - Which is better when ?
#data #normalization #denormalization
Hi Friends, I am Anshul Tiwari, and welcome to your youtube channel "IT k Funde" where we make I.T. interesting for everyone (Tech or No-Tech).
More about this video -
While designing the data models we often get confused while deciding whether to normalize or denormalize data. But most importantly do we know what is data normalization vs denormalization?
In this video, we will explore these two concepts and understand the difference between normalization vs denormalization and when to use which technique.
I hope after watching this video, you will have a better understanding of this very crucial data concept.
PLEASE WATCH OTHER VIDEOS FROM THE POPULAR PLAYLISTS GIVEN BELOW. EVERY SINGLE LIKE, COMMENT AND SHARE MEANS THE WORLD TO ME!
#itkfunde #keeplearning #keepsharing #keephustling
Credits & Resources -
images - pixabay.com
**Social Channels**
RUclips - / itkfunde
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Instagram - / itkfunde
**Do check out our popular playlists**
1) Networking and Infra Concepts - • Networking & Infra Con...
2) Data Analytics & Insights - • Learn - Data Engineeri...
3) Google Cloud Platform Beginner Series -
• Google Cloud Platform ...
4) Latest technology tutorial (2021) -
• What is a Data Vault ?...
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

[@Mark-wi9ov]

I may not have money to donate but I will not skip ads for every video i watch in your channel. Great video! 😊

[@ITkFunde]

Thanks Marky that means a lot man thankyou 🙏🙏☺️

[@srutipatnaik7194]

Thank you for this video. Simple and Easy to follow!

[@sateeshreddy3313]

Nice Explanantion i have learnt about DATA ENGINEERING by watching your videos, I truly appreciate your work...Keep Making Videos!!!!!

[@ayushbansal9341]

Nice Explain Sir, Thank You

[@petartsvetanov5577]

Very well explained, thank you.

[@pranabmishra7283]

Very nice explanation. Really interesting facts and explanation . Easy to understand and remember. You really make IT interesting as you say. This is not only for this - rather for all your videos . Thanks a lot for spreading knowledge .

[@gauravmishra8994]

Awesome video

[@narinderthapa3204]

Superb🙏

[@sammedpatil3907]

nice explanation sir...

[@harshparikh7898]

Brilliantly explained

[@BA-ve7xp]

great video thank you

[@thegrinchCAPO]

Great video I’ve been watching for a while and I’ve learnt so much thanks a lot your a amazing teacher never stop

[@KAJlogic]

Is Normalized = better write performance
De-Normalized = better read performance
always true or a rule of thumb?
So, I have been exploring efficiency increases in normalizing sometimes due to better indexing performance. Is it possible to actually increase read efficiency by normalizing and allowing better indexing?

[@Rhysee473]

Great video 🤙🏽

[@kellyfitzpatrick3468]

Great video!!

[@musafirq]

Very intuitive way to explaining things. it will help data people to remember this by the shop example. teaching by example is the only way to teach effectively.

[@jayanth1376]

👌👌👌

[@twinkletiwari8820]

👏👏👏

[@jatinshah7780]

Thank you buddy ..... 😊

[@nickgogan6654]

Thank you for the video! I’d like to also put forward document-based db’s like MongoDB as as a sweet spot between traditional RDBMS and NoSQL db’s (like the wide-column store you described in the denormalized scenario). Mongo data models are typically more denormalized than not, and it can ingest millions of writes/sec without issue

[@Ikilledthebanks]

Until you have to ingest all that deeply nested crap into a relational database

[@techkid358]

thannks man

[@payalkhedkar1869]

Thanks 😊

[@sandipansarkar9211]

finished watching

[@jenbac.s1858]

Thank you for this clear explanation.

[@ITkFunde]

Thanks

[@bluerays5384]

well explained Sir..Thank you..

[@ITkFunde]

thanks

[@Ikilledthebanks]

This is great, thank you very much

[@ITkFunde]

Thanks

[@sidneymikalgrey]

New fan. I like your style.

[@ITkFunde]

Thanks Sidney

[@ismailkhan9594]

sir meinay ek banday ka mobaile apnay wifi say connect kia hay ab wo appna mobaile hotspot on kar kay dosro ko internet deta hay .mein cahta hon wo net istemal karay leken hotspot kam nakaray. is ka koye settings ho to mera help karay. mehrobani hoge

[@hp0806]

Can we say Denormalization process is followed by normalization ? Instea of which is better

[@amansdav]

Sir, why is write easy in a Normalized DB? Any example, pls? Thanks for your video. 🙏

[@ITkFunde]

Read this 👉 link.medium.com/K7ivyOiTsxb

[@petebell271]

AMAZON DB2 --- Best example for DENORMALIZATION Data

[@ashfaqmohammad1086]

Good stuff for beginners, obviously every aspect could not be covered in a limited timeframe.

[@shalakakarkare8495]

Can you pls explain SDWAN concepr

[@ITkFunde]

thanks for suggestion

[@mallikarjunt29]

Topic starts from 1:28

[@mairajamil001]

Video starts at @1:08