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

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

Get started Preview course

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.

Try this course for free

Access this course and other top-rated tech content with a free trial.

Free individual trial Free team trial

Have questions?

Get them answered now.

Start a live chat

Course Info

Rating

(60 reviews)

Level

Intermediate

Last updated

Nov 01, 2023

Duration

2h 36m 56s

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

Why a Good Database Structure Matters 16m 18s

Translating Business Requirements 40m 14s

Designing Physical Database and Object Placement 31m 37s

Designing the Right Index Strategy 39m 11s

Designing the Right Partitioning Strategy 29m 34s