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.
Course info
Level
Intermediate
Updated
Mar 7, 2019
Duration
2h 26m
Table of contents
Course Overview
Introducing Tables and Views
Designing and Implementing Tables
Improving Table Design Through Normalization
Ensuring Data Integrity with Constraints
Designing View to Meet Business Requirements
Implementing Partitioned Views
Implementing Indexed Views
Summary
Description
Course info
Level
Intermediate
Updated
Mar 7, 2019
Duration
2h 26m
Description

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.

About the author
About the author

Gerald is 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). 

More from the author
Managing SQL Server Database Concurrency
Intermediate
1h 45m
Jun 7, 2019
Getting Started with Python on SQL Server
Intermediate
1h 25m
Apr 18, 2018
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Gerald Britton, Welcome to my course, Designing Tables and Views in SQL Server. I'm a Senior Solutions Designer specializing in SQL Server database technologies. Did you know that at any given moment, there are more than 20, 000 openings for SQL Server developers and that many of those jobs pay over $100, 000 per year? And that's just in North America. Does that sound like a field you'd like to get into. In this course, we're going to work on fundamental skills needed by everyone who wants to get ready for prime time when it comes to database design and development. We'll do it all in the context of a growing business struggling with managing customer orders. Some of the major topics that we will cover include matching datatypes to usage with an eye on storage utilization, normalizing tables to eliminate redundancy and improve integrity, leveraging the power of data constraints to keep data clean, creating higher-level objects called views to improve reusability, and building high-performance views for growing data. By the end of this course, you'll know how to design the tables and views for a new database, as well as spot problems and improvement opportunities in the databases you may already be using. Before beginning this course, you should be familiar with writing simple database queries using SQL, the structured query language. When you are done, you should feel comfortable diving into advanced database design with courses on indexing, stored procedures, functions, and triggers, and performance analysis and troubleshooting. I hope you'll join me on this journey to learn database design with the Designing Tables and Views in SQL Server course at Pluralsight.