Data Integrity & Constraints
SQL Server 2016
| Intermediate
- 11 Videos | 1h 13m 16s
- Includes Assessment
- Earns a Badge
Constraints can be used in SQL Server 2016 to ensure data integrity. Discover how to design and implement constraints for tables and columns.
WHAT YOU WILL LEARN
-
recognize the three basic forms of data integrity: domain, entity, referential
use the various mechanisms used to enforce data integrity
describe entity and referential integrity
describe the use of the PRIMARY Key constraint
use the FOREIGN KEY constraint
describe the UNIQUE constraint I -
describe the IDENTITY constraint
recognize the common considerations to be aware of when working with constraints
demonstrate how to write Transact-SQL statements to add constraints to tables
demonstrate how to identify results of DML statements given exiting tables and constraints
describe stored procedures and their benefits
IN THIS COURSE
-
1.Types of Data Integrity7m 54sUP NEXT
-
2.Enforcing Data Integrity9m 15s
-
3.Entity and Referential Integrity7m 5s
-
4.PRIMARY KEY Constraints7m
-
5.FOREIGN KEY Constraints7m 32s
-
6.UNIQUE Constraints3m 35s
-
7.IDENTITY Constraints6m 30s
-
8.Constraint Checking4m 12s
-
9.Adding Constraints to Tables8m 51s
-
10.Identifying Results Given Existing Constraints5m 34s
-
11.Exercise: Configure Constraints5m 48s
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.
