Lesson 00 - Introduction | Intermediate T-SQL - Programming Functions | Products | Grumpy Old IT Guy

Lesson 00 - Introduction

Lesson 00 - Introduction

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

Intermediate T-SQL - Programming Functions

Buy nowLearn more

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