Using Functions

SQL Server 2016
  • 19 Videos | 1h 37m 50s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
SQL Server 2016 offers built-in functions that provide data type conversion, comparison, and NULL handling. Explore the various types of built-in functions and how to write queries using built-in functions.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 20 Likes 20  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 21 Likes 21