Design a Database Structure with SQL Server 2014 (70-465)

Course

Libraries: If you want this course, consider one of these libraries.
Data

Design a Database Structure with SQL Server 2014 (70-465)

Learn how to design a database structure with SQL Server 2014.

Get started

What you'll learn

This course focuses on designing a database structure using SQL Server 2014. You will learn how to translate business requirements into which SQL Server components are needed, how to design a physical database, and how to develop an index and partitioning strategy.

Course Introduction | 1m 18s
What Is a Database Structure? | 2m 35s
Performance and Maintenance Issues | 2m 35s
Demo: Database Structure Issues | 9m 14s
Module Summary | 34s

Module Introduction | 1m 26s
What Type of Application Is the Database Used For? | 4m 49s
Difference Between Logical and Physical Design | 11m 8s
Demo: Physical Design | 6m 42s
Normalization and Denormalization | 7m 35s
Demo: Denormalization | 7m 41s
Module Summary | 49s

Design a Database Structure with SQL Server 2014 (70-465)

What you'll learn

Table of contents

Get started with Pluralsight

Design a Database Structure with SQL Server 2014 (70-465)

What you'll learn

Table of contents

Why a Good Database Structure Matters 16m

Translating Business Requirements 40m

Designing Physical Database and Object Placement 31m

Designing the Right Index Strategy 39m

Designing the Right Partitioning Strategy 29m

Get started with Pluralsight