How to Normalize a Database Table

Start learning cybersecurity with CBT Nuggets. courses.cbt.gg/security
In this video, CBT Nuggets trainer Garth Schulte covers normalizing database tables, a set of rules that help reduce redundancy and improve data integrity.
If you apply the rules of normalizing database tables to your database design, you can help eliminate redundant data, reduce modification anomalies, and ensure dependencies are logical. There are five normal forms in total - watch to learn them all, and which three most database designers aim to achieve.
📁 Download the Ultimate Sysadmin Cert Guide: blog.cbt.gg/koin
⬇️ 4-Week Study Plan: MD-100 & MD-101: blog.cbt.gg/r638
Start learning with CBT Nuggets:
• Intro to Databases | courses.cbt.gg/vlz
• Microsoft MTA: Database Fundamentals (98-364) | courses.cbt.gg/9ix
• Microsoft MCSE: Data Management and Analytics | courses.cbt.gg/ezw
• Microsoft SQL Server 2012/2014 Database Solutions (70-465) | courses.cbt.gg/vaa

[@Ray-xl9iz]

I've been trying to understand how to identify the rules. This is by far the only thing ive seen that made it easy to understand normalizing databases and how to break them down. Thank you sir!

[@JKarle]

A fantastic and easy to understand explanation of normalization as a whole, and how each level of normalization (1st to 3rd) differs. Thank you very much.

[@nenadsavanovic8628]

Best video I have been able to find on Normalization. Love it!

[@PaperRaines]

This video was savage! Explained so many things that eluded me for years, thanks so much 😊

[@UvanSankar]

Great work man!

[@jamesbell8861]

Thanks !!! You explained it way better than the textbook !!!

[@user-oc1fe4dv3n]

Thank you so much. You can’t imagine how much it is helpful

[@tadeob_UB]

Amazing video! packed with helpful information and easy to understand. thanks a lot

[@hcetc]

Wow man! Wonderful explanation.

[@ereh_yeager]

Thanks for this, helped me understand normalization easily

[@Veikkuu]

Super clear tutorial, well done!

[@MaxMineur]

Thanks, very helpful!

[@nathankirklambo1986]

Totally rad, dude!!

[@brunoggdev6305]

What an amazing video, great work

[@Ex-Clamation]

This is the source that made it make sense for me. Thanks.

[@sardorabdirayimov]

Great tutorial. I wonder if you can tell which app did used for visualization of database notation in the end of the video :)

[@PetrosMengsteab]

Great video.

[@nniiiluuu]

Orderitems stores the quantity and price per unit. Orders stores ordertotal, which is a derived attribute (sum of the ordered items*quantity). I'm curious why you chose to store the ordertotal in the table, should we not remove derived values in 1nf?

[@hasanmougharbel8030]

Hello there, glad to meet again.
I have a simple enquiry..
In what case it would be convenient to apply BCNF form of normalization to my data?
Thanks for taking care of this.

[@o-o857]

I swear every video on this topic has different definitions for 1NF

[@shuumo453]

legit lmao

[@thebulletkin8393]

isn't the third normal form just the second but done again? Since it just has you checking through to make sure that all the non key values depend on the primary?

[@JoLynch0]

around 5:00 mark, wouldn't you say that "Address" is not yet an atomic value, thus not meeting 1NF?

[@mateuszmiskiewicz3823]

Not the best example. If you don't have a composite key, then your table already is in 2NF. Instead, what you're showing here is basically 3NF, not 2NF.

[@LeEnnyFace]

Exactly. He basically did 3NF twice