Functions

SQL Server 2016    |    Intermediate
  • 7 Videos | 38m 13s
  • Includes Assessment
  • Earns a Badge
Likes 26 Likes 26
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

  • Playable
    1. 
    User-defined Functions Overview
    3m 17s
    UP NEXT
  • Playable
    2. 
    User-defined Functions Components
    2m 18s
  • Locked
    3. 
    Scalar-valued Functions
    8m 18s
    FREE ACCESS
  • Locked
    4. 
    Table-valued Functions
    6m 11s
    FREE ACCESS
  • Locked
    5. 
    Built-in Functions
    7m 42s
    FREE ACCESS
  • Locked
    6. 
    Deterministic Functions
    5m 21s
    FREE ACCESS
  • Locked
    7. 
    Nondeterministic Functions
    5m 8s
    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 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

CHANNEL Wintellect SQL Server
Likes 1 Likes 1  
COURSE Introduction to SQL Bootcamp: Session 4 Replay
Likes 77 Likes 77  
BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL 2016 Tables
Likes 405 Likes 405  
COURSE Index Design Guidelines
Likes 33 Likes 33  
COURSE Data Types & Normalization
Likes 67 Likes 67