Using Functions

SQL Server 2016    |    Intermediate
  • 19 Videos | 1h 28m 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 Sets & Predicate Logic
Likes 29 Likes 29  
CHANNEL Wintellect NoSQL
Likes 2 Likes 2  
COURSE Operators & Expressions
Likes 34 Likes 34  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Database Programmability Objects & Non-relational Data
Likes 22 Likes 22  
COURSE Getting Started with Python: Introduction
Likes 2989 Likes 2989  
COURSE SQL 2016 Tables
Likes 166 Likes 166