Data Integrity & Constraints

SQL Server 2016
  • 11 Videos | 1h 18m 16s
  • Includes Assessment
  • Earns a Badge
Likes 19 Likes 19
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

  • Playable
    1. 
    Types of Data Integrity
    7m 54s
    UP NEXT
  • Playable
    2. 
    Enforcing Data Integrity
    9m 15s
  • Locked
    3. 
    Entity and Referential Integrity
    7m 5s
  • Locked
    4. 
    PRIMARY KEY Constraints
    7m
  • Locked
    5. 
    FOREIGN KEY Constraints
    7m 32s
  • Locked
    6. 
    UNIQUE Constraints
    3m 35s
  • Locked
    7. 
    IDENTITY Constraints
    6m 30s
  • Locked
    8. 
    Constraint Checking
    4m 12s
  • Locked
    9. 
    Adding Constraints to Tables
    8m 51s
  • Locked
    10. 
    Identifying Results Given Existing Constraints
    5m 34s
  • Locked
    11. 
    Exercise: Configure Constraints
    5m 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.

YOU MIGHT ALSO LIKE

Likes 23 Likes 23  
Likes 39 Likes 39  
Likes 166 Likes 166  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 34 Likes 34  
Likes 61 Likes 61