Data Integrity & Constraints

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 13m 16s
  • Includes Assessment
  • Earns a Badge
Likes 49 Likes 49
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

  • 7m 54s
    After completing this video, you will be able to recognize the three basic forms of data integrity: domain, entity, and referential. FREE ACCESS
  • 9m 15s
    In this video, find out how to use the various mechanisms used to enforce data integrity. FREE ACCESS
  • Locked
    3.  Entity and Referential Integrity
    7m 5s
    Upon completion of this video, you will be able to describe entity integrity and referential integrity. FREE ACCESS
  • Locked
    4.  PRIMARY KEY Constraints
    7m
    Upon completion of this video, you will be able to describe the use of the PRIMARY KEY constraint. FREE ACCESS
  • Locked
    5.  FOREIGN KEY Constraints
    7m 32s
    During this video, you will learn how to use the FOREIGN KEY constraint. FREE ACCESS
  • Locked
    6.  UNIQUE Constraints
    3m 35s
    Upon completion of this video, you will be able to describe the UNIQUE constraint. FREE ACCESS
  • Locked
    7.  IDENTITY Constraints
    6m 30s
    Upon completion of this video, you will be able to describe the IDENTITY constraint. FREE ACCESS
  • Locked
    8.  Constraint Checking
    4m 12s
    Upon completion of this video, you will be able to recognize common considerations to be aware of when working with constraints. FREE ACCESS
  • Locked
    9.  Adding Constraints to Tables
    8m 51s
    In this video, you will learn how to write Transact-SQL statements to add constraints to tables. FREE ACCESS
  • Locked
    10.  Identifying Results Given Existing Constraints
    5m 34s
    In this video, you will learn how to identify results of DML statements given existing tables and constraints. FREE ACCESS
  • Locked
    11.  Exercise: Configure Constraints
    5m 48s
    Upon completion of this video, you will be able to describe stored procedures and their benefits. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel SQL Database Development & Design
Likes 316 Likes 316  
Course SQL 2016 Tables
Likes 405 Likes 405  
Course Working with tables in Excel 365
Likes 11 Likes 11  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Index Design Guidelines
Likes 33 Likes 33  
Course Designing & Implementing Views
Likes 105 Likes 105  
Course Stored Procedures
Likes 61 Likes 61