SQL Server Stored Procedures

Our SQL Server Stored Procedures course covers creation, modification, input/output parameters, required permissions, and error handling with Try..Catch.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Our SQL Server Stored Procedures course covers creation, modification, input/output parameters, required permissions, and error handling with Try..Catch.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

The SQL Server Stored Procedures course is designed to teach students what stored procedures are and why the are necessary. This course demonstrates how to create stored procedures, add input and output parameters and how to modify stored procedures. The class also covers permissions necessary for working with stored procedures as well as error handling techniques with Try..Catch.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

SQL Stored Procedures - What you need to get started

Module 00 - Class Introduction 5 min.

Module 01 - What are Stored Procedures 13 min.

Module 02 - Creating your first stored procedure 18 min.

Module 03 - Modifying stored procedures 14 min.

Module 04 - Adding parameters to stored procedures 16 min.

Module 05 - Working with output parameters 18 min.

Module 06 - Output parameters in Power Automate 14 min.

Module 07 - Permisssions for stored procedures 14 min.

Module 08 - Error handling with Try..Catch 14 min.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Mitchell Pearson

Data Engineer (Azure) Trainer

Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.

Learn More

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

Windows 7, Windows 8, or Window 10 - 1 GHz or faster CPU - 1 GB of available RAM (recommended 2 GB) - 20 GB of free hard drive space - SQL Server Management Studio - https://aka.ms/ssms **Download Details** Please download the following file, which includes all material covered during class Unzip these files to your root directory in a folder called SQL Server Stored Procedures. (Ex: C:\SQL Server Stored Procedures) [Click to download](https://pragmaticworksonline.sharepoint.com/:u:/s/FileShare/EfQA1QoLSBNNnYrO-j4SCVYBzOIe6QN3u7A5uPyMtrhj7w?e=dsdYlY&Download=1)

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion