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 -

***Social Channels***

***Do check out our popular playlists***

3) Google Cloud Platform Beginner Series -

4) Latest technology tutorial (2021) -

***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-wiov]

I may not have money to donate but I will not skip ads for every video i watch in your channel. 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.

[AhmdsYT]

Thank you man! It was a helpful video for my coming interview! Subscribed + Liked! 🤙🏼

[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?

[sateeshreddy]

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

[nickgogan]

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

[srutipatnaik]

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

[pranabmishra]

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 .

[amansdav]

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

[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

[petebell]

AMAZON DB2 --- Best example for DENORMALIZATION Data

[hp]

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

[ashfaqmohammad]

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

[ismailkhan]

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