From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Implement domain integrity - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Implement domain integrity
- [Instructor] Maintaining the validity of data at the point that it's attempted to be stored in the database, is the responsibility of domain integrity techniques. Domain integrity is specifically concerned with the validity of data at the column level of a table. By enforcing domain integrity, you're ensuring that the data present to the column meets certain criteria dictated by the business rules of your organization, or some other constraints within the system. You can apply domain integrity to your tables in a number of ways. The first and foremost method of protecting the validity of data in a column is by applying an appropriate data type. When you choose a data type, you're specifying what will not be allowed in the table as much as you're specifying what will be allowed. Making sure that your data types are as targeted as possible will eliminate a large number of potential data entry mistakes right off the bat.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.