From the course: Querying Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding normalization

Understanding normalization - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2012

Start my 1-month free trial

Understanding normalization

Up until this point in time, throughout the course we've been focusing all of our queries on a single table. Now, granted, if you look at some of the queries we've executed, yes, we've used different tables throughout the examples, but, only ever during one query have we been pulling data from one table. Coming up, we'll be looking at querying multiple tables. Before we get to that point, we have to understand a little bit about the table structure in the database through something called normalization, which helps us understand why the data is split into multiple tables. So we'll focus on, understanding what normalization is and then looking at how the multiple tables are separated and how we bring them back together, through the use of joins, as we take a look at querying those multiple tables. So in this first one, we'll take a look at understanding normalization itself. Now, normalization is, in its simplest definition, it's organizing your data but, more accurately, it's…

Contents