• Online, Self-Paced
Course Description

SQL Server 2016 offers various database programmable objects, such as stored procedures and functions, used to enhance and increase your database performance as well as ease administrative workload. This course will demonstrate how to implement various database programmability objects, as well as how to work with temporal and non-relational data in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.

Learning Objectives

Database Programmability Objects

  • start the course
  • describe stored procedures in SQL Server 2016
  • use and create stored procedures in SQL Server 2016
  • demonstrate how to input parameters in SQL Server 2016
  • demonstrate how to output parameters in SQL Server 2016
  • recognize table-valued functions in SQL Server 2016
  • describe scalar-valued user-defined functions in SQL Server 2016
  • demonstrate TRY…CATCH error handling
  • demonstrate how to use RAISERROR in SQL 2016

Temporal and Non-relational Data

  • describe temporal data types in SQL Server 2016
  • work with temporal tables in SQL Server 2016
  • describe XML data
  • describe JSON data
  • demonstrate how to query and output JSON data in SQL Server 2016
  • demonstrate how to query and output XML data in SQL Server 2016

Practice: Implementing Database Programmability Objects

  • use database programmability objects in SQL Server 2016

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.