Using Functions

SQL Server 2016    |    Intermediate
  • 19 videos | 1h 28m 50s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
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

  • 3m 7s
    Upon completion of this video, you will be able to list the built-in function types used in SQL Server 2016. FREE ACCESS
  • 6m 53s
    In this video, find out how to work with scalar functions in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Aggregate Functions
    3m 57s
    After completing this video, you will be able to describe aggregate functions in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Windows Functions
    4m 10s
    After completing this video, you will be able to list Windows functions in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Rowset Functions
    3m 39s
    Upon completion of this video, you will be able to describe rowset functions in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Implicit and Explicit Conversations
    6m 33s
    Find out how to work with implicit and explicit data type conversions in SQL Server 2016. FREE ACCESS
  • Locked
    7.  CAST Function
    5m 14s
    In this video, you will learn how to convert a value using the CAST function. FREE ACCESS
  • Locked
    8.  CONVERT Function
    6m 40s
    In this video, you will learn how to convert a value using the CONVERT function. FREE ACCESS
  • Locked
    9.  PARSE Function
    3m 34s
    Upon completion of this video, you will be able to describe how to convert a value using the PARSE function. FREE ACCESS
  • Locked
    10.  TRY_Parse Function
    3m 56s
    In this video, you will learn how to convert a value using the TRY_Parse function. FREE ACCESS
  • Locked
    11.  TRY_Convert Function
    3m 20s
    After completing this video, you will be able to describe how to convert a value using the TRY_Convert function. FREE ACCESS
  • Locked
    12.  ISNUMERIC Function
    3m 17s
    In this video, you will learn how to validate data types using the ISNUMERIC function. FREE ACCESS
  • Locked
    13.  IIF Function
    5m 28s
    In this video, you will work with the IIF logical function in SQL Server. FREE ACCESS
  • Locked
    14.  CHOOSE Function
    3m 56s
    In this video, you will learn how to work with the CHOOSE function in SQL Server 2016. FREE ACCESS
  • Locked
    15.  NULL Value Overview
    5m 51s
    Upon completion of this video, you will be able to describe the NULL value in SQL Server 2016. FREE ACCESS
  • Locked
    16.  Convert NULL with ISNULL
    4m 25s
    In this video, you will learn how to use ISNULL to replace NULL values. FREE ACCESS
  • Locked
    17.  COALESCE Function
    4m 6s
    In this video, you will learn how to work with the COALESCE function in SQL Server 2016. FREE ACCESS
  • Locked
    18.  NULLIF Function
    4m 17s
    Upon completion of this video, you will be able to describe how to use the NULLIF function in SQL Server 2016. FREE ACCESS
  • Locked
    19.  Exercise: Using Functions in SQL Server 2016
    6m 29s
    In this video, you will learn how to use functions 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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Database Programmability Objects & Non-relational Data
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Encryption
Rating 4.5 of 104 users Rating 4.5 of 104 users (104)
Course Working with Functions, Times, Dates, & Intervals
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)