• Online, Self-Paced
Course Description

SQL Server 2016 offers various built-in functions that provide data type conversion, comparison, and NULL handling. This course covers the various types of built-in functions, as well as demonstrates how to write queries using built-in functions. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.

Learning Objectives

Built-in Functions

  • start the course
  • list the built-in function types used in SQL Server 2016
  • work with scalar functions in SQL Server 2016
  • describe aggregate functions in SQL Server 2016
  • list Windows functions in SQL Server 2016
  • describe rowset functions in SQL Server 2016

Conversion Functions

  • work with implicit and explicit data type conversions in SQL Server 2016
  • demonstrate how to convert a value using the CAST function
  • demonstrate how to convert a value using the CONVERT function
  • describe how to convert a value using the PARSE function
  • demonstrate how to convert a value using the TRY_Parse function
  • describe how to convert a value using the TRY_Convert function

Logical Functions

  • demonstrate how to validate data types using the ISNUMERIC function
  • work the IIF logical function in SQL Server
  • work with the CHOOSE function in SQL Server 2016

Functions to Work with NULL

  • describe the NULL value in SQL Server 2016
  • demonstrate how to use ISNULL to replace NULL
  • work with the COALESCE function in SQL Server 2016
  • describe how to use the NULLIF function in SQL Server 2016

Practice: SQL Server 2016 Functions

  • use functions in SQL Server 2016

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration