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

Channel Avatar
Comment
X
Share
Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online
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
http://www.sqltrainingonline.com/SQLNormalizationExcel

READ THE ORIGINAL ARTICLE WITH EXCEL FILE HERE
http://www.sqltrainingonline.com/sql-database-normalization/

YOUTUBE NEWS UPDATES
http://www.youtube.com/user/sqltrainingonline

VISIT SQLTRAININGONLINE.COM FOR VIDEOS & TIPS
http://www.sqltrainingonline.com

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_center?add_usersqltrainingonline

SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com

LET’S CONNECT!
Facebook: http://facebook.com/SQLTrainingOnline
Twitter: http://twitter.com/sql_by_joey
Linkedin: http://linkedin.com/in/joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *