Using Functions in SQL Server 2016

Database administrators, database developers, and BI professionals

Prerequisite
None

Expected Duration
96 minutes

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

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.