Managing Database Integrity
SQL Server 2016
| Intermediate
- 10 videos | 53m
- Includes Assessment
- Earns a Badge
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 11sAfter completing this video, you will be able to describe the purpose of the Database Consistency Checker. FREE ACCESS
-
4m 56sDuring this video, you will learn how to use the Database Consistency Checker in SQL Server Management Studio. FREE ACCESS
-
3. Viewing Progress Reports for DBCC Commands4m 53sLearn how to use the catalog view to see information about progress and the current phase of execution. FREE ACCESS
-
4. Performing Checks on Databases8m 34sUpon completion of this video, you will be able to describe the types of consistency checks appropriate for databases. FREE ACCESS
-
5. Performing Checks on Indexes6m 10sIn this video, you will learn how to perform consistency checks on indexes. FREE ACCESS
-
6. Consistency Check Errors4m 32sUpon completion of this video, you will be able to recognize common consistency check errors and their resolutions. FREE ACCESS
-
7. Database Corruption4m 25sAfter completing this video, you will be able to recognize possible causes of database corruption. FREE ACCESS
-
8. Identifying Database Corruption6m 4sLearn how to detect corruption in a SQL Server database. FREE ACCESS
-
9. Recovering from Database Corruption3m 52sFind out how to recover from database corruption. FREE ACCESS
-
10. Exercise: Ensuring Database Consistency5m 24sIn 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.
