Using Functions
SQL Server 2016
| Intermediate
- 19 videos | 1h 28m 50s
- Includes Assessment
- Earns a Badge
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 2016work with scalar functions in SQL Server 2016describe aggregate functions in SQL Server 2016list Windows functions in SQL Server 2016describe rowset functions in SQL Server 2016work with implicit and explicit data type conversions in SQL Server 2016demonstrate how to convert a value using the CAST functiondemonstrate how to convert a value using the CONVERT functiondescribe how to convert a value using the PARSE functiondemonstrate how to convert a value using the TRY_Parse function
-
describe how to convert a value using the TRY_Convert functiondemonstrate how to validate data types using the ISNUMERIC functionwork the IIF logical function in SQL Serverwork with the CHOOSE function in SQL Server 2016describe the NULL value in SQL Server 2016demonstrate how to use ISNULL to replace NULLwork with the COALESCE function in SQL Server 2016describe how to use the NULLIF function in SQL Server 2016use functions in SQL Server 2016
IN THIS COURSE
-
1.SQL Server Built-in Function Types3m 7sUP NEXT
-
2.Scalar Functions6m 53s
-
3.Aggregate Functions3m 57s
-
4.Windows Functions4m 10s
-
5.Rowset Functions3m 39s
-
6.Implicit and Explicit Conversations6m 33s
-
7.CAST Function5m 14s
-
8.CONVERT Function6m 40s
-
9.PARSE Function3m 34s
-
10.TRY_Parse Function3m 56s
-
11.TRY_Convert Function3m 20s
-
12.ISNUMERIC Function3m 17s
-
13.IIF Function5m 28s
-
14.CHOOSE Function3m 56s
-
15.NULL Value Overview5m 51s
-
16.Convert NULL with ISNULL4m 25s
-
17.COALESCE Function4m 6s
-
18.NULLIF Function4m 17s
-
19.Exercise: Using Functions in SQL Server 20166m 29s
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.