Database Normalization Simplified
4.6 (73 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
370 students enrolled

Database Normalization Simplified

Database Normalization Explained in Simple English for MySql, Oracle, SQL Server, and PostgreSQL
Highest Rated
4.6 (73 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
370 students enrolled
Created by Kris Wenzel
Last updated 11/2018
English
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Know the reasons why a relational database is organized into many separate tables.
  • Gain confidence in understanding formal database normalization rules.
  • Be able to express and communication database design concepts with others.
  • Be prepared to answer interview questions.
  • Determine whether a database table is a good design.
  • Restructure spreadsheet like data into good database form.
Course content
Expand all 15 lectures 01:00:04
+ Introduction
4 lectures 18:43

Welcome to Database Normalization Simplified.  My goal is to help take the mystery out of database normalization and explain to you the definitions in simple to use English!

By the time you have completed the course, you will have a thorough understanding of the three normal forms, be able to use them to answer interview questions, take an exam or certification, or design a database.

Preview 03:13

Database normalization can be really abstract.  Before we get into some of the definitions, let's look at a practical view.

Preview 03:53

You may wonder what's all the fuss about database normalization.  Let me show you some good reasons you'll want to understand it.

Preview 07:05

The three normal forms are guide lines we can used to help use determine how to design tables.  The help use know whether columns should be include in a table or should be separated.  The forms build upon one another.  In order for a table to be in the second form, if must first meet the criteria for the first.


For those that are impatient check out the our Five Minute Guide to Database Normalization within the downloadable resources.

The Three Main Normal Forms
04:32
+ Database Tables and Modeling Ideas
2 lectures 05:58

A database  table must meet some simple rule such as having rows and columns and a primary key.  Know about this definition is important, as this is the first requirement for a table to be in the first normal form.

What is a Database Table?
03:57

I put this article together to help you understand some of the diagram I use when teaching database normalization.  I recommend reading it so you understand the notation I use throughout the course.

Keep it Simple: Easy To Understand Data Modeling Concepts
02:01

Covers questions around database tables and fundamental modeling concepts

Database Tables and Modeling Ideas
6 questions
Create database tables as described in my article and then relate them together.
Table Relationship Assginment
2 questions
+ Database Normalization
7 lectures 34:08

Once a table is in the first normal form, the table is considered a relational database table, and it doesn't contain any repeating values.

First Normal Form
04:44

To better understand the first normal form, lets go over some examples.

First Normal Form Design Review
05:49
In this assignment you'll identify several data modification anomalies within a table and then redesign the table into the first normal form.
Data Modification Anomalies and First Normal Form Assignment
4 questions

When a table is in the second normal form the table serves a single purpose.

Second Normal Form
05:55

Let's transform our first normal form tables into the second normal form.

Second Normal Form Design Review
06:58
In this assignment we'll work with a table and redesign it so it conforms to second normal form guidelines.
Second Normal Form Assignment
3 questions

Tables in the third normal form have columns that aren't calculated, that is they don't rely on other column values from within the table.

Third Normal Form
06:03

In this lesson we'll transform our tables from 2nd to 3rd normal form.

Third Normal Form Design Review
01:57

Some rules are mean to be broken.  The database rules for normalization of generally mean to be followed, but not always!

Can Normalization Get Out of Hand?
02:42

This quiz covers topic related to database tables, 1st, 2nd, and 3rd normal forms.

Database Normalization Quiz
12 questions
+ Wrap-up
2 lectures 01:14

If at any time you have a question about this course, please let me know.

Wrap-up
00:42

Be sure to check out my other courses and grab a coupon so you can get the best deal on your next course.

Bonus Lecture: Additional Resources and Course Coupons
00:32
Requirements
  • Interest in a class hyper-focused on database normalization -- nothing else!
  • Appreciate basic database concepts such as knowing about columns, rows, and tables.
  • No prior knowledge of MySQL, SQLServer, PostgreSQL or Oracle is required!
Description

This course is perfect if you're running low on time, and need to cram for a test or certification.  Its singular purpose is to teach you database normalization.


In this Course you will Learn to:

  • Appreciate and design around data modification anomalies.

  • Identify a properly formed database table.

  • Answer common interview questions related to normalization

  • Spot a poorly designed table.

  • Communicate with others about table design.

  • Finally understand those confounding normalization rules!

Nothing is worse than

  • Being excited to learn something new but not knowing where to start.

  • Wasting time learning the wrong features.

  • Being overwhelmed with options and not know which to use.

Imagine Having...

  • Knowledge - Knowing how to quickly understand table relationships to take your SQL to the next level.

  • Confidence - Feeling good that you’re on the right track.

  • Accomplishment - Having a sense of accomplishment that you've learned something most cannot.

  • Fun - Having fun learning databases!


By the time you’ve completed this course you’ll have an appreciation of database normalization, overcome your fear of normal form definitions, and make sense of the the most used database normal forms.   

Who this course is for:
  • Students baffled by their professor's database normalization explanations
  • DBAs seeking common sense definitions of database normal forms.
  • Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer.
  • People preparing for SQL related job interviews.
  • Anyone looking to take a class whose singular purpose is to teach you database normalization
  • Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations.