Grumpy Old IT Guy/Intermediate T-SQL - Programming Functions

  • $5.98

Intermediate T-SQL - Programming Functions

  • Course
  • 33 Lessons

SQL Server functions are crucial for writing clean, reusable, and efficient code. In this course, we will explore the various types of functions, their applications, and how they compare to other SQL mechanisms, such as stored procedures and triggers. This course includes homework assignments that allow you to apply what you have learned to real-world SQL problems

Contents

Lesson 00 - Introduction
Preview
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
Preview
Lesson 08 - Summary VIDEO

Functions - Module Lesson Code

This section contains the T-SQL files used in each lesson

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

This section contains the homework starter templates and the homework solutions template.

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