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.
Course Outline ( Free Preview)
SQL Stored Procedures - What you need to get started
Module 00 - Class Introduction5 min.
Module 01 - What are Stored Procedures13 min.
Module 02 - Creating your first stored procedure18 min.
Module 03 - Modifying stored procedures14 min.
Module 04 - Adding parameters to stored procedures16 min.
Module 05 - Working with output parameters18 min.
Module 06 - Output parameters in Power Automate14 min.
Module 07 - Permisssions for stored procedures14 min.
Mitchell Pearson is a Solution Architect, Consultant, and Trainer with 14 years of experience at Pragmatic Works helping organizations modernize their data and analytics platforms using Microsoft Azure and Microsoft Fabric. He specializes in designing scalable, enterprise-ready data solutions that align technical architecture with real business outcomes.
Mitchell is known for helping organizations navigate some of the most complex aspects of modern data platforms. Whether guiding customers through Fabric implementations, data modernization initiatives, or enterprise analytics strategies, he has a unique ability to break down sophisticated concepts into practical, understandable frameworks. From Lakehouse architecture and data engineering to medallion architecture design and governance strategies, Mitchell helps teams understand not only what to build, but why it matters and how to implement it successfully.
As a Solution Architect, Mitchell works closely with customers to design both consulting engagements and training programs that accelerate adoption and ensure long-term success. He helps organizations create clear roadmaps for Azure and Fabric implementations, balancing technical best practices with business priorities. His experience spans data platform modernization, analytics strategy, cloud migration, AI readiness, governance, and enterprise reporting solutions.
A recognized author, speaker, and educator, Mitchell has written books on SQL Server, Power BI, and the Power Platform and regularly shares insights on modern data architecture and analytics. His technical expertise includes Microsoft Fabric, Azure data services, Power BI, and the broader Microsoft data ecosystem. Customers value his ability to make complex technologies approachable, helping technical and business teams align around a common vision and confidently move forward with modern data solutions.
Windows 7, Windows 8, or Windows 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://learning.pragmaticworkstraining.com/api/upload/get/256-sql-server-stored-procedures.zip)
