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