Intermediate T-SQL - Programming Functions
- Buy now
- Learn more
- Discussions
- Lesson 00 - Introduction
- DISCLAIMER
- Lesson 00 - Introduction Video
- Lesson 01 - What is a Function?
- Lesson 01 - What is a Function - Video?
- Lesson 02 - Functions versus Stored Procedures
- Lesson 02 - Functions versus Stored Procedures VIDEO
- Lesson 03 - Scalar Functions
- Lesson 03 - Scalar Functions VIDEO
- Lesson 04 - Table Valued Functions
- Lesson 04 - Table Valued Functions VIDEO
- Lesson 05 - Aggregate Functions
- Lesson 05 - Aggregate Functions VIDEO
- Lesson 06 – Functions and Common Table Expressions
- Lesson 06 - Functions and CTEs VIDEO
- Lesson 07 – Passing Tables to Functions
- Lesson 07 - Passing Tables to a Function VIDEO
- Lesson 08 – Summary
- Lesson 08 - Summary VIDEO
Functions - Module Lesson Code

M3L01 - What is a function.sql
M3L02 - Stored procedure versus Function.sql
M3L03 - Scalar Functions.sql
M3L04 - Table Values Functions.sql
M3L05 - Aggregate Functions.sql
M3L06 - Funcations and CTEs.sql
M3L07 - Passing Tables to Functions.sql
BONUS - System Function Examples
Create HOBBY_SHOP database
Create HOBBY_SHOP database tables and other objects
Load HOBBY_SHOP_TABLEs with BCP script
HOBBY_SHOP BCP ZIP File
Homework Solutions and Starter Templates

MODULE 03 - LESSON HOMEWORK SOLUTIONS.sql
MODULE 03 - LESSON HOMEWORK STARTER TEMPLATES.sql

Lesson 00 - Introduction

This free, short lesson introduces the other lessons that comprise the module.