SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

Archives for 2018

August 11, 2018 by Joey Blue Leave a Comment

SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF

Learn how to normalize your relational tables.

  • 1st Normal Form and Atomic Values
  • 2nd Normal Form (2NF) and Partial Dependence
  • 3rd Normal Form (3NF) and Transitive Dependence
  • 4th Normal Form (4NF) and Multi-Valued Facts

The first half of the video discusses the normal forms with smaller examples.  The second half of the video goes into a little more complex example.

Video: Database Normalization Tutorial


1NF, 2NF, 3NF, 4NF

The following Microsoft Excel file is used throughout the training to demonstrate the normal forms:

Normalization Excel File

See the original Normalization in SQL. 1NF, 2NF, 3NF, and 4NF video.

Filed Under: SQL Tip, SQL Training Tagged With: 1NF, 2NF, 3NF, 4NF, Database Normalization

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join

Have Questions? Connect with me.

Link to my Facebook Page
Link to my Pinterest Page
Link to my Rss Page
Link to my Twitter Page
Link to my Youtube Page
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com