Microsoft SQL Server 2016: Managing Database Integrity

Database administrators and database professionals

Prerequisite
None

Expected Duration
57 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.