Managing Database Integrity

SQL Server 2016    |    Intermediate
  • 10 videos | 53m
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. Explore database consistency checks and how to identify and recover from database corruption.

WHAT YOU WILL LEARN

  • 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 indexes
  • Recognize common consistency check errors and their resolutions
    Recognize possible causes of database corruption
    Detect corruption in a sql server database
    Recover from database corruption
    Use sql server 2016 tools to ensure database consistency

IN THIS COURSE

  • 4m 11s
    After completing this video, you will be able to describe the purpose of the Database Consistency Checker. FREE ACCESS
  • 4m 56s
    During this video, you will learn how to use the Database Consistency Checker in SQL Server Management Studio. FREE ACCESS
  • Locked
    3.  Viewing Progress Reports for DBCC Commands
    4m 53s
    Learn how to use the catalog view to see information about progress and the current phase of execution. FREE ACCESS
  • Locked
    4.  Performing Checks on Databases
    8m 34s
    Upon completion of this video, you will be able to describe the types of consistency checks appropriate for databases. FREE ACCESS
  • Locked
    5.  Performing Checks on Indexes
    6m 10s
    In this video, you will learn how to perform consistency checks on indexes. FREE ACCESS
  • Locked
    6.  Consistency Check Errors
    4m 32s
    Upon completion of this video, you will be able to recognize common consistency check errors and their resolutions. FREE ACCESS
  • Locked
    7.  Database Corruption
    4m 25s
    After completing this video, you will be able to recognize possible causes of database corruption. FREE ACCESS
  • Locked
    8.  Identifying Database Corruption
    6m 4s
    Learn how to detect corruption in a SQL Server database. FREE ACCESS
  • Locked
    9.  Recovering from Database Corruption
    3m 52s
    Find out how to recover from database corruption. FREE ACCESS
  • Locked
    10.  Exercise: Ensuring Database Consistency
    5m 24s
    In this video, you will use SQL Server 2016 tools to ensure database consistency. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Database Performance at Scale: A Practical Guide
Channel Database Performance Tuning
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performance Metrics
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Course Encryption
Rating 4.5 of 104 users Rating 4.5 of 104 users (104)
Course Index & Statistical Management
Rating 4.4 of 18 users Rating 4.4 of 18 users (18)