Basic SQL Training - 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_user=sqltrainingonline 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