From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Ensure data integrity

Ensure data integrity - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Ensure data integrity

“

- [Narrator] Ensuring data integrity partly falls on the database administrator, but also on developers who are accessing and consuming the data. But what is data integrity? I like to think of it as data that has been validated against a set of criteria to ensure that it is correct, error-free, and applicable to the usage required. Enforcing data integrity guarantees the quality of the data in your database, and it helps to ensure that the data you have is actually valid for the use that you intended. As an example, if we think about an employee table, and we have an employee entry with a specific ID value, let's say 49576, the database shouldn't permit another employee to be entered or to exist in that database with that same ID value. This would be a violation of some form of data integrity. Likewise you might have a rating column for a specific piece of data that has a range, say valid values are only from one to five. So you would want to put a constraint or some type of integrity…

Contents