EssentialSQL: Database Normalization Simplified

Database Normalization Explained in Simple English for MySql, Oracle, SQL Server, and PostgreSQL | Database Design

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I 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 communicate 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.

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!

Target audience

• 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.