Functions
SQL Server 2016
| Intermediate
- 7 videos | 38m 13s
- Includes Assessment
- Earns a Badge
Functions in SQL Server 2016 are sets of reusable code that enact operations on a database. Examine functions, including scalar-valued, table-valued, deterministic, and non-deterministic.
WHAT YOU WILL LEARN
-
recognize the various components of user-defined functions
use scalar-valued functions
use table-valued functions
use built-in functions -
use deterministic functions
use nondeterministic functions
configure triggers in SQL Server 2016
IN THIS COURSE
-
3m 17sUpon completion of this video, you will be able to recognize the various components of user-defined functions. FREE ACCESS
-
2m 18sFind out how to use functions that return a scalar value. FREE ACCESS
-
3. Scalar-valued Functions8m 18sFind out how to use table-valued functions. FREE ACCESS
-
4. Table-valued Functions6m 11sIn this video, you will learn how to use built-in functions. FREE ACCESS
-
5. Built-in Functions7m 42sFind out how to use deterministic functions. FREE ACCESS
-
6. Deterministic Functions5m 21sDuring this video, you will learn how to use non-deterministic functions. FREE ACCESS
-
7. Nondeterministic Functions5m 8sDuring this video, you will learn how to configure triggers in SQL Server 2016. FREE ACCESS
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.
