Functions

SQL Server 2016    |    Intermediate
  • 7 videos | 38m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
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 17s
    Upon completion of this video, you will be able to recognize the various components of user-defined functions. FREE ACCESS
  • 2m 18s
    Find out how to use functions that return a scalar value. FREE ACCESS
  • Locked
    3.  Scalar-valued Functions
    8m 18s
    Find out how to use table-valued functions. FREE ACCESS
  • Locked
    4.  Table-valued Functions
    6m 11s
    In this video, you will learn how to use built-in functions. FREE ACCESS
  • Locked
    5.  Built-in Functions
    7m 42s
    Find out how to use deterministic functions. FREE ACCESS
  • Locked
    6.  Deterministic Functions
    5m 21s
    During this video, you will learn how to use non-deterministic functions. FREE ACCESS
  • Locked
    7.  Nondeterministic Functions
    5m 8s
    During 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.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Prompt Engineering to Work with Advanced SQL Operations
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course MySQL Database Development: Working with Functions
Rating 4.7 of 41 users Rating 4.7 of 41 users (41)
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Embracing a Customer-obsessed Mentality
Rating 4.6 of 4940 users Rating 4.6 of 4940 users (4940)
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)