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 - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2012
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.