Managing Database Integrity

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

COURSE Modern Data Management: Data Governance
Likes 0 Likes 0  
CHANNEL Database Backup & Recovery
Likes 60 Likes 60  
CHANNEL SQL Database Development & Design
Likes 156 Likes 156  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Access & Permissions
Likes 110 Likes 110  
COURSE Index & Statistical Management
Likes 22 Likes 22  
COURSE T-SQL Queries
Likes 173 Likes 173