|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-the-complete-course-on-indexes-3-h-of-class/
课程评论：没有评论
**课程名称：SQL Server 索引完全指南** **课程时长：4小时** **课程简介：** 您是否正饱受SQL Server性能缓慢的困扰，并怀疑是索引配置不当所致？您是否因为不了解聚集索引和非聚集索引的区别而未在表上设置索引？本课程将时长4小时，带领您深入探索为表配置良好索引的重要性。在不必大肆采购磁盘存储之前，请先检查您的索引设置是否存在问题！简单来说，索引是提升SQL Server性能的首要途径。 **课程内容详情：** * 聚集索引和非聚集索引的结构 * 表扫描（Table SCAN）与表查找（Table SEEK） * 覆盖索引（Covering Index）以及为何不应索引整个表（过度索引 Over indexing） * 移除重复索引，并理解“单一索引”（SINGLE index）的定义 * 索引合并（Consolidation）与列存储索引（Columnstore index） * 过滤索引（Filtered indexes）及其关联的缓存计划（Cache Plan），以及“SARGABLE”一词的含义 * 如何选择正确的聚集索引 * 索引碎片化（Fragmentation）的重要性及如何移除 * 跟踪页拆分（Page Splits）与FILLFACTOR的定义 * 索引重建（Rebuild Index）与索引重组（REORGANIZE）的区别，以及ABORT_AFTER_WAIT选项 **目标学员：** 所有DBA和开发人员，尤其是那些负责性能优化并希望利用索引来提升服务器性能的专业人士。 **课程亮点：** * 平均评分4.4/5，保证课程质量。 * 助您在同事中脱颖而出，或在求职面试中占据优势。 * 视频时长不超过10分钟，避免枯燥乏味。
You have problems of slowness on your SQL servers, and you suspect the implementation of your indexes? You haven't set up indexes on your tables, because you don't know the differences between a clustered and a non-clustered index? In this 4 hour course, come and discover the importance of a good index setup on your tables. Don't go on a spending spree buying disk storage, when it may be the index setup that is wrong! It's simple, indexes are the first reason, of your performance improvements on a SQL server. The training in detail:The structure of a clustered and a non-clustered index.The Table SCAN and the Table SEEK The covering index and Why you should not index the whole table (Over indexing).Remove duplicate indexes, and see the definition of a SINGLE index.Remember to consolidate indexes, and the columnstore index.Beware of filtered indexes and their associated cache plan, and see what is the term SARGABLE?How to choose the right Clustered Index Why fragmentation is important, and how to remove itTracking page splits and the FILLFACTOR definitionRebuild Index Vs REORGANIZE and the ABORT_AFTER_WAIT optionThis course is for all DBAs and developers who deal with performance optimization and want to use indexes to improve server performance.Look at the average of my other courses (4.4/5), and you will see that my courses are quality courses:)Take this course, will help you to stand out technically from your colleagues, or during a job interview.I also made sure that the videos are not longer than 10 minutes, so that it's not too boring:)
