Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online

Database Normal Forms with Examples.

In this video I show you how to normalize your relational database.

What is covered:
--1st Normal Form and Atomic Values
--2nd Normal Form and Partial Dependence
--3rd Normal Form and Transitive Dependence
--4th Normal Form and Multi-Value Facts

I start with smaller examples for 1NF, 2NF, 3NF, and 4NF. Then I move into a more comprehensive example that uses all of the normal forms together.

TABLE OF CONTENTS
00:00 - Intro
01:07 - 1st Normal Form
4:18 - 2nd Normal Form
9:44 - 3rd Normal Form
13:50 - 4th Normal Form
17:33 - Normalizing Customer Orders
20:35 - Customer Table (2NF)
21:55 - Product Table (2NF)
24:20 - Order Header vs Order Lines
29:05 - Product Table (3NF)
31:25 - Customer Table (1NF, 4NF)

DOWNLOAD THE EXCEL FILE HERE

READ THE ORIGINAL ARTICLE WITH EXCEL FILE HERE

YOUTUBE NEWS UPDATES

VISIT SQLTRAININGONLINE.COM FOR VIDEOS & TIPS

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!

SUBSCRIBE TO OUR EMAIL LIST!

LET'S CONNECT!

[joeyblue]

TABLE OF CONTENTS
00:00​ - Intro
01:07​ - 1st Normal Form
4:18​ - 2nd Normal Form
9:44​ - 3rd Normal Form
13:50​ - 4th Normal Form
17:33​ - Normalizing Customer Orders
20:35​ - Customer Table (2NF)
21:55​ - Product Table (2NF)
24:20​ - Order Header vs Order Lines
29:05​ - Product Table (3NF)
31:25​ - Customer Table (1NF, 4NF)

[deepashankar]

That's brilliant, confused by a textbook but fully normalised now!

[organiz-izedtravis]

This video will top the search results in youtube on "DB Normalization" going forward.

[FrogsStacked]

Great explanation! It's obvious that you actually understand the topic well, and you're not just spewing out definitions. I've had some difficulty understanding these concepts until now

[girls_game_as_well]

I have been struggling with this concept all week in class. I finally get it. Thank you so much.

[hectord.]

I'm a total noob on this topic and watched many videos about database normalization, this is the simplest explanation on the topic and the one that helped me the most improving my database structure. Thanks a lot!

[MaxProskoff]

Thank you for explaining this so clearly. I like the focus and the delivery.

[montrealbudd]

I really like this video. It was so much easier for me to understand normal forms by watching this video instead of reading my book. Thank you so much!

[harjos]

Best explaination i have seen so far in any book or video!. Hats off. Great example and walk thourgh

[alexandercato]

You did a great job teaching a complex topic in an understandable way! Just subscribed to your channel and expect you to get many more in the coming months because you’re producing quality content—it really stands out from the other videos on normalization. Keep up the great work!

[samiramirsamor]

Thank you so much, you just make it easy for me to understand, that what a perfect teacher looks like.

[richod]

Very well explained. This video tied up a loose ends for me. I already knew how to break apart one table into other tables, but this explanation really helped me to 100% confdent. Wouldn't it be a good idea to put 'Product Manufacturer Address' into it's own table in case the product is manufactured in multiple locations? If so, then what would be the key to the 'Product Manufacturer Address' table?

[chaslutterloh]

Thank you! This was an excellent format for a visual learner like me!

[skv]

Good explanation. After seeing the video, I felt like using pivot tables in Excel could speed up the process.

[jkirkwold]

In the section explaining 2NF, when deduping the Product Table, you got rid of two rows. The first I understand (Bat, Louisville Slugger) because it was a duplicate. However, you also got rid of (Basketball, Titleist) even though it wasn't a duplicate. Why? Great video!

[raytierney]

The absolute best !!!! Saving me from the land of total confusion!!!

[LenaDobrinova]

1. Thanks for your video!
2. One of the "Basketball-SP" records under the "Products" table needs to be deleted.
3. Price for "Basketball-SP" needs to be updated in the original table ( @16:49). It should be either $23 or $25.
4. Order Totals for "Customer Order ID" #1 and #4 don't look correct ("Customer Orders" table).

[vladyslavvlasenko]

Thanks a lot!
Your explanation is absolutely easy to understand, examples are perfect.

[saltech]

Your tutorials are of no doubt ....

Kindly make video(s) on "Entity Diagrams"

[wanroslinawanmusa]

Thanks. Very easy to digest explanation on normalization.