Using Functions in SQL Server 2016


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


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

Target Audience
Database administrators, database developers, and BI professionals

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

Using Functions in SQL Server 2016

  • 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
  • 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
  • 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
  • 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
  • use functions in SQL Server 2016

    • Course Number:
    df_sqlq_a04_it_enus

    Expertise Level
    Expert