Database Programmability Objects and Non-Relational Data

Database administrators, database developers, and BI professionals

Prerequisite
None

Expected Duration
117 minutes

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 20761A: Querying Data with Transact-SQL exam.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.