Save 40% on Coursera Plus Annual

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Designing and Implementing SQL Server Tables and Views

via Pluralsight

Write review
Coursera Ad

All Coursera Certificates 40% Off

Learn More → GetSmarter Ad

Most AI Pilots Fail to Scale. MIT Sloan Teaches You Why — and How to Fix It

Learn More →

Overview

Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it


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.

Syllabus

  • 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

Taught by

Gerald Britton

Reviews

4.1 rating at Pluralsight based on 160 ratings

Start your review of Designing and Implementing SQL Server Tables and Views

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.