Using Functions

SQL Server 2016    |    Intermediate
  • 19 videos | 1h 28m 50s
  • Includes Assessment
  • Earns a Badge
Likes 52 Likes 52
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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 38 Likes 38  
Likes 498 Likes 498  
Course T-SQL Queries
Likes 173 Likes 173