Managing Database Integrity

SQL Server 2016
  • 10 Videos | 57m 30s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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

  • Playable
    1. 
    Database Consistency Checker
    4m 11s
    UP NEXT
  • Playable
    2. 
    Using Database Consistency Checker in SSMS
    4m 56s
  • Locked
    3. 
    Viewing Progress Reports for DBCC Commands
    4m 53s
    FREE ACCESS
  • Locked
    4. 
    Performing Checks on Databases
    8m 34s
    FREE ACCESS
  • Locked
    5. 
    Performing Checks on Indexes
    6m 10s
    FREE ACCESS
  • Locked
    6. 
    Consistency Check Errors
    4m 32s
    FREE ACCESS
  • Locked
    7. 
    Database Corruption
    4m 25s
    FREE ACCESS
  • Locked
    8. 
    Identifying Database Corruption
    6m 4s
    FREE ACCESS
  • Locked
    9. 
    Recovering from Database Corruption
    3m 52s
    FREE ACCESS
  • Locked
    10. 
    Exercise: Ensuring Database Consistency
    5m 24s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Database Core Concepts
Likes 96 Likes 96  
COURSE Policy-based Management & Performance Monitoring
Likes 16 Likes 16  
COURSE Encryption
Likes 69 Likes 69  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Auditing
Likes 39 Likes 39  
COURSE Backup Management
Likes 75 Likes 75  
COURSE Log Shipping & High Availability
Likes 27 Likes 27