Using Functions

SQL Server 2016    |    Intermediate
  • 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

COURSE Database Programmability Objects & Non-relational Data
Likes 22 Likes 22  
COURSE Filtering Data
Likes 31 Likes 31  
COURSE T-SQL Queries
Likes 173 Likes 173  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Using GROUP BY, PIVOT, & UNPIVOT
Likes 25 Likes 25  
COURSE Querying & Manipulating Data
Likes 61 Likes 61  
COURSE Getting Started with Python: Introduction
Likes 1602 Likes 1602