Database Programmability Objects and Non-Relational Data


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


Overview/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.

Target Audience
Database administrators, database developers, and BI professionals

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Database Programmability Objects and Non-Relational Data

  • 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
  • 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
  • use database programmability objects in SQL Server 2016

    • Course Number:
    df_sqlq_a08_it_enus

    Expertise Level
    Expert