Overview

Introduction

The Design T-SQL table-valued and scalar function module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Work with Scalar and Table Valued Function
  2. Implement Set based vs Procedural Approach

Exercise 1 - Work with Scalar and Table Valued Function

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Create a scalar valued function
  • Create a table valued function

Exercise 2 – Implement Set Based Vs Procedural Approach

In this exercise, you will implement set based and procedural (cursor) approach.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.