In this course, Designing and Implementing SQL Server Tables and Views, you will gain the foundational knowledge you need to match business requirements to the objects to be created in your database. First, you will learn about data types and which ones to use for your data. Next, you will discover data normalization and how to transform a basic design into third normal form. Following that, you will learn how to maximize data integrity by using constraints. Finally, you will explore three types of views and when to use each one. When you’re finished with this course, you will have the skills and knowledge of table and view design needed to create great databases.
Author Name: Gerald Britton
Author Description:
Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Table of Contents

• Course Overview
  1min
• Introducing Tables and Views
  7mins
• Designing and Implementing Tables
  27mins
• Improving Table Design Through Normalization
  25mins
• Ensuring Data Integrity with Constraints
  30mins
• Designing View to Meet Business Requirements
  15mins
• Implementing Indexed Views
  14mins
• Implementing Partitioned Views
  12mins
• Summary
  9mins