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

Опубликовано: 11 Август 2018
на канале: Joey Blue

196,855

3.4k

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

Смотрите видео Database Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training Online онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Joey Blue 11 Август 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 196,855 раз и оно понравилось 3.4 тысяч людям.

516