• Online, Self-Paced
Course Description

Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. This course teaches you how to implement database consistency checks, as well as how to identify and recover from database corruption. 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

Checking Database Consistency

  • start the course
  • describe the purpose of the Database Consistency Checker
  • use the Database Consistency Checker in SQL Server Management Studio
  • use the catalog view to see information about progress and current phase of execution
  • describe the types of consistency checks appropriate for databases
  • perform consistency checks on tables and indexes
  • recognize common consistency check errors and their resolutions

Managing Corruption

  • recognize possible causes of database corruption
  • detect corruption in a SQL Server database
  • recover from database corruption

Practice: Checking Database Consistency

  • use SQL Server 2016 tools to ensure database consistency

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.