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 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
-
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.
