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/SQLN...
READ THE ORIGINAL ARTICLE WITH EXCEL FILE HERE
http://www.sqltrainingonline.com/sql-...
YOUTUBE NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR VIDEOS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com
Watch video Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online online without registration, duration hours minute second in high quality. This video was added by user Joey Blue 11 August 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 196,855 once and liked it 3.4 thousand people.