Designing and Implementing SQL Server Database Indexes

سرفصل های دوره

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.

01. Course Overview

01. Course Overview

02. General Indexing Guidelines

01. Course Intro

03. Understanding Basic Index Architecture and Index Usage

01. SQL Server Index Architecture

02. How SQL Server Uses Indexes

03. How Index Operations Appear in Execution Plans

04. Designing Indexes to Organize Tables

01. What Is a Clustered Index-

02. Clustered Index Guidelines Narrow

03. Clustered Index Guidelines Unique and Unchanging

04. Clustered Index Guidelines Ever Increasing

05. Demo- Effects of Different Clustered Indexes

06. Clustered Index Guidelines Trade Offs and Compromise

05. Designing Indexes to Improve Query Performance- Part 1

01. Introducing Nonclustered Indexes

02. Equality Predicates

03. Inequality Predicates

04. Demo- Equality Predicates

05. Demo- Inequality Predicates

06. Indexing for Predicates with ORs

07. Demo- Predicates with ORs

06. Designing Indexes to Improve Query Performance- Part 2

01. Indexing for Joins

02. Demo- Indexing for Joins

03. Include Columns

04. Demo- Include Columns

05. Filtered Indexes

06. Demo- Filtered Indexes

07. Nonclustered Index Summary

07. Designing Indexed Views

01. Introducing Indexed Views

02. Indexed View Limitations and Uses

03. Demo- Creating and Using Indexed Views

04. Downsides of Indexed Views

08. Designing Columnstore Indexes for Analytic Queries

01. Introducing Columnstore Indexes

02. Demo- Creating Columnstore Indexes

03. Where to Use Columnstore Indexes

04. Demo- How SQL Server Uses Columnstore Indexes

09. Summary and Further Reading

01. Course Summary and Further Reading

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight