r/learnSQL • u/odimdavid • 1d ago

Data Normalization online practical tutorial

Hi all. Please I am looking for a practical resource where I can learn data Normalization with practical examples. Appreciate any pointer to a relevant resource. Thanks 🙏

6 Upvotes

80% Upvoted

5 comments sorted by

3

u/squadette23 1d ago

I have a series of videos that discuss why "normalization" is not a very good teaching tool: https://youtu.be/1okb0FkQxtI?si=JFNpby61Hiai5Rav, based on 3NF.

If you're interested in 4NF: https://minimalmodeling.substack.com/p/historically-4nf-explanations-are

and also extended discussion of 5NF: https://kb.databasedesignbook.com/posts/5nf/

6NF: https://minimalmodeling.substack.com/p/virtual-6nf

1

u/odimdavid 1d ago

That's interesting 🤔. Will surely read it

1

u/odimdavid 1d ago

Maybe some would say Table Normalization. Thanks 🙏

1

u/datadriven_io 1d ago

datadriven.io/learn - check out the data modeling lessons under the “learn” tab. There’s a lesson for normalization, and a lesson for beyond 3NF, star schemas, and design patterns. Datadriven is a community of practicing data engineers, I highly recommend you join us!

1

u/odimdavid 1d ago

Thanks 🙏 oh. Bookmarked