Designing and Implementing SQL Server Database Indexes

Focused View

Gail Shaw

2:11:38

20 View

00. Course Overview

00. Course Overview.mp4

01:30

01. General Indexing Guidelines

00. Course Intro.mp4

06:06

02. Understanding Basic Index Architecture and Index Usage

00. SQL Server Index Architecture.mp4

02:49

01. How SQL Server Uses Indexes.mp4

03:37

02. How Index Operations Appear in Execution Plans.mp4

04:43

03. Designing Indexes to Organize Tables

00. What Is a Clustered Index - .mp4

02:49

01. Clustered Index Guidelines Narrow.mp4

02:57

02. Clustered Index Guidelines Unique and Unchanging.mp4

02:27

03. Clustered Index Guidelines Ever Increasing.mp4

02:54

04. Demo - Effects of Different Clustered Indexes.mp4

04:10

05. Clustered Index Guidelines Trade Offs and Compromise.mp4

03:14

04. Designing Indexes to Improve Query Performance - Part 1

00. Introducing Nonclustered Indexes.mp4

04:17

01. Equality Predicates.mp4

08:28

02. Inequality Predicates.mp4

06:07

03. Demo - Equality Predicates.mp4

03:36

04. Demo - Inequality Predicates.mp4

03:26

05. Indexing for Predicates with ORs.mp4

02:31

06. Demo - Predicates with ORs.mp4

04:36

05. Designing Indexes to Improve Query Performance - Part 2

00. Indexing for Joins.mp4

02:04

01. Demo - Indexing for Joins.mp4

02:55

02. Include Columns.mp4

03:30

03. Demo - Include Columns.mp4

02:52

04. Filtered Indexes.mp4

01:59

05. Demo - Filtered Indexes.mp4

03:10

06. Nonclustered Index Summary.mp4

01:50

06. Designing Indexed Views

00. Introducing Indexed Views.mp4

01:29

01. Indexed View Limitations and Uses.mp4

04:58

02. Demo - Creating and Using Indexed Views.mp4

04:07

03. Downsides of Indexed Views.mp4

01:44

07. Designing Columnstore Indexes for Analytic Queries

00. Introducing Columnstore Indexes.mp4

05:04

01. Demo - Creating Columnstore Indexes.mp4

04:34

02. Where to Use Columnstore Indexes.mp4

07:57

03. Demo - How SQL Server Uses Columnstore Indexes.mp4

06:01

08. Summary and Further Reading

00. Course Summary and Further Reading.mp4

07:07

Description

This course is an introduction to SQL Server indexes. In this course, you will be covering common index types and discussing how to index to support your workloads.

What You'll Learn?

Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and Implementing SQL Server Database Indexes, you'll gain knowledge on how to avoid these issues through the effective use of SQL Server database indexes. First, you'll discover the main index types that SQL Server has. Next, you'll explore considerations for their use. Finally, you'll learn how to choose indexes and index keys to best support your applications. When you've finished this course, you'll be in a good position to optimize all of your SQL Server databases and improve your applications' speed and throughput.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Database Programming

Microsoft SQL

Gail Shaw

Instructor's Courses

Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related. She lives in Johannesburg, South Africa.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.