Programmability Objects

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

---

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

Expertise Level
Expert