Course Details

Previous Page


Programmability Objects


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Constraints can be used in SQL Server 2016 to ensure data integrity. This covers how to design and implement constraints for tables and columns. This course also covers stored procedures, a SQL Server feature that allows you to reuse the code over and over, providing advantages such as performance, productivity, and ease of use. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Programmability Objects

  • start the course
  • 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
  • design stored procedures components and structure based on business requirements
  • describe how to use the input and output parameters
  • demonstrate how to use table-valued parameters
  • implement return codes
  • streamline existing stored procedure logic
  • implement error handling and transaction control logic within stored procedures
  • alter a stored procedure using the Transact-SQL ALTER PROCEDURE statement
  • obfuscate stored procedures using the WITH ENCRYPTIONS clause
  • configure constraints in SQL Server 2016
  • Course Number:
    df_sqld_a04_it_enus