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, referentialuse the various mechanisms used to enforce data integritydescribe entity and referential integritydescribe the use of the PRIMARY Key constraintuse the FOREIGN KEY constraintdescribe the UNIQUE constraint I
-
describe the IDENTITY constraintrecognize the common considerations to be aware of when working with constraintsdemonstrate how to write Transact-SQL statements to add constraints to tablesdemonstrate how to identify results of DML statements given exiting tables and constraintsdescribe 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.