From the course: Microsoft SQL Server 2016: Query Data
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Understanding normalization - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Understanding normalization
- [Instructor] In this lesson we'll take a look at the concept of normalization. Relational database systems use normalization to design the table structure within the database to apply certain concepts and principles in relation to the data storage. This lesson will provide a fundamental understanding of normalization only. The topic goes much deeper than what we'll cover here, but you will gain enough information to be able to understand the first three forms of normalization. Consider normalization as a means of organizing the data in your database. Now this organization will follow some rules, or forms of normalization, which will result in the creation of multiple tables and the establishment of relationships between those tables. One of the driving factors behind normalization is the reduction in the redundancy of data. Redundancy of data means that we have the same pieces of information existing in multiple locations in the same database. Likely even in the same table…
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.