Designing and Implementing SQL Server Tables and Views
Every great database starts with a great design and tables and views are the bedrock of that design. This course will show you how to create tables and views that use the right data types, constraints, and indexes to meet all business requirements.
What you'll learn
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.
Table of contents
- Introduction 2m
- Identifying Problems with Unnormalized Data 2m
- Setting Objectives for Normalization 1m
- Demo 1 - Discovering Anomalies with Unnormalized Data 2m
- Understanding First Normal Form 1m
- Demo 2 - Transforming the Design to 1NF 6m
- Understanding Second Normal Form 1m
- Demo 3 - Transforming the Design to 2NF 3m
- Understanding Third Normal Form 1m
- Demo 3 - Transforming the Design to 3NF 3m
- Considering Other Normal Forms 3m
- Summary 1m
- Introduction and Overview 2m
- Using NULL and DEFAULT Constraints 3m
- Demo 1 - NULL and DEFAULT Constraints 3m
- Implementing the PRIMARY KEY Constraint 2m
- Using Index Types and the UNIQUE Constraint 2m
- Demo 2 - Implementing PRIMARY KEY and UNIQUE Constraints 3m
- More About Foreign Key Constraints 2m
- Demo 3 - Using FOREIGN KEY Constraints 4m
- Introducing CHECK Constraints 2m
- Demo 4 - Using CHECK Constraints 4m
- Options for Defining CHECK Constraints 2m
- Summary 2m
About the author
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).