• Online, Self-Paced
Course Description

By carefully managing aspects of your database like indexes and statistics, you are able to better tune performance and identify potential issues. This course teaches you about index management tasks, such as identifying and repairing fragmentation, identifying and creating missing indexes, identifying and dropping underused indexes, and managing existing columnstore indexes. In addition, this course covers statistic management topics, such as identifying and correcting outdated statistics, using Auto Update Statistics, and statistics for large tables. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Learning Objectives

Managing Indexes

  • start the course
  • describe the types of indexes available in SQL Server and the importance of managing them properly
  • detect fragmented indexes and determine the degree of fragmentation
  • repair index fragmentation using SQL Server Management Studio
  • repair index fragmentation using Transact-SQL
  • use the Missing Indexes feature to identify missing indexes and to create them, if needed
  • find and remove underutilized indexes

Managing Columnstore Indexes

  • describe the purpose of columnstore indexes, as well as why and when to use them
  • improve columnstore index performance
  • defragment columnstore indexes

Implementing Statistics

  • identify and correct outdated statistics
  • describe the purpose and characteristics of the auto_update_statistics option
  • implement Auto Update Statistics
  • implement statistics for large tables

Practice: Managing Indexes

  • manage indexes in SQL Server 2016

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.