Designing and Implementing SQL Server Database Indexes | 2A448F15870625363E0358921EDFF6D882EA25A6

Designing and Implementing SQL Server Database Indexes

Name	Designing and Implementing SQL Server Database Indexes	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	281.5 MB
Total Files	69
Hash	2A448F15870625363E0358921EDFF6D882EA25A6

/01. Course Overview/
01. Course Overview.mp4	3.0 MB
01. Course Overview.srt	2.5 KB
/02. General Indexing Guidelines/
01. Course Intro.mp4	7.9 MB
01. Course Intro.srt	10.6 KB
/03. Understanding Basic Index Architecture and Index Usage/
01. SQL Server Index Architecture.mp4	4.9 MB
01. SQL Server Index Architecture.srt	4.5 KB
02. How SQL Server Uses Indexes.mp4	5.9 MB
02. How SQL Server Uses Indexes.srt	5.7 KB
03. How Index Operations Appear in Execution Plans.mp4	14.2 MB
03. How Index Operations Appear in Execution Plans.srt	8.0 KB
/04. Designing Indexes to Organize Tables/
01. What Is a Clustered Index-.mp4	4.7 MB
01. What Is a Clustered Index-.srt	4.5 KB
02. Clustered Index Guidelines Narrow.mp4	3.6 MB
02. Clustered Index Guidelines Narrow.srt	4.3 KB
03. Clustered Index Guidelines Unique and Unchanging.mp4	3.5 MB
03. Clustered Index Guidelines Unique and Unchanging.srt	3.7 KB
04. Clustered Index Guidelines Ever Increasing.mp4	4.1 MB
04. Clustered Index Guidelines Ever Increasing.srt	4.0 KB
05. Demo- Effects of Different Clustered Indexes.mp4	11.0 MB
05. Demo- Effects of Different Clustered Indexes.srt	6.8 KB
06. Clustered Index Guidelines Trade Offs and Compromise.mp4	4.5 MB
06. Clustered Index Guidelines Trade Offs and Compromise.srt	5.5 KB
/05. Designing Indexes to Improve Query Performance- Part 1/
01. Introducing Nonclustered Indexes.mp4	6.3 MB
01. Introducing Nonclustered Indexes.srt	7.7 KB
02. Equality Predicates.mp4	14.3 MB
02. Equality Predicates.srt	13.6 KB
03. Inequality Predicates.mp4	10.6 MB
03. Inequality Predicates.srt	10.6 KB
04. Demo- Equality Predicates.mp4	10.5 MB
04. Demo- Equality Predicates.srt	5.6 KB
05. Demo- Inequality Predicates.mp4	12.3 MB
05. Demo- Inequality Predicates.srt	5.3 KB
06. Indexing for Predicates with ORs.mp4	3.8 MB
06. Indexing for Predicates with ORs.srt	4.2 KB
07. Demo- Predicates with ORs.mp4	12.5 MB
07. Demo- Predicates with ORs.srt	7.0 KB
/06. Designing Indexes to Improve Query Performance- Part 2/
01. Indexing for Joins.mp4	2.6 MB
01. Indexing for Joins.srt	3.5 KB
02. Demo- Indexing for Joins.mp4	7.8 MB
02. Demo- Indexing for Joins.srt	4.6 KB
03. Include Columns.mp4	5.3 MB
03. Include Columns.srt	5.8 KB
04. Demo- Include Columns.mp4	8.4 MB
04. Demo- Include Columns.srt	4.9 KB
05. Filtered Indexes.mp4	2.5 MB
05. Filtered Indexes.srt	3.5 KB
06. Demo- Filtered Indexes.mp4	7.2 MB
06. Demo- Filtered Indexes.srt	4.2 KB
07. Nonclustered Index Summary.mp4	2.5 MB
07. Nonclustered Index Summary.srt	3.5 KB
/07. Designing Indexed Views/
01. Introducing Indexed Views.mp4	2.2 MB
01. Introducing Indexed Views.srt	2.6 KB
02. Indexed View Limitations and Uses.mp4	8.5 MB
02. Indexed View Limitations and Uses.srt	8.3 KB
03. Demo- Creating and Using Indexed Views.mp4	10.1 MB
03. Demo- Creating and Using Indexed Views.srt	6.8 KB
04. Downsides of Indexed Views.mp4	2.3 MB
04. Downsides of Indexed Views.srt	3.0 KB
/08. Designing Columnstore Indexes for Analytic Queries/
01. Introducing Columnstore Indexes.mp4	7.4 MB
01. Introducing Columnstore Indexes.srt	8.3 KB
02. Demo- Creating Columnstore Indexes.mp4	12.6 MB
02. Demo- Creating Columnstore Indexes.srt	7.8 KB
03. Where to Use Columnstore Indexes.mp4	11.1 MB
03. Where to Use Columnstore Indexes.srt	13.2 KB
04. Demo- How SQL Server Uses Columnstore Indexes.mp4	19.6 MB
04. Demo- How SQL Server Uses Columnstore Indexes.srt	10.1 KB
/09. Summary and Further Reading/
01. Course Summary and Further Reading.mp4	10.5 MB
01. Course Summary and Further Reading.srt	12.8 KB
/
design-build-sql-server-indexes.zip	23.3 MB
Total files 69