Capturing Logic with Stored Procedures in T-SQL

Do you have experience writing T-SQL but want to start creating stored procedures? Well, this course is for you! Take your skills to the next level by learning all the in and outs of designing and optimizing stored procedures.
Course info
Rating
(34)
Level
Intermediate
Updated
Oct 24, 2019
Duration
3h 6m
Table of contents
Course Overview
Exploring the Benefits of Stored Procedures
Creating Our First Stored Procedure
Setting up Queries in Stored Procedures
Optimizing Stored Procedure Performance
Building Stored Procedures in the Real World
Description
Course info
Rating
(34)
Level
Intermediate
Updated
Oct 24, 2019
Duration
3h 6m
Description

Perhaps you’re starting out or have been working with stored procedures for years. Maybe you want to take your understanding of store procedures in SQL Server to the next level. In this course, Capturing Logic with Stored Procedures in T-SQL, you will learn foundational knowledge for developing powerful stored procedures. First, you will learn why utilizing stored procedures in SQL Server is paramount to executing maintainable code. Along the way, learning why using temporary objects might reduce complexity. Next, you will discover methods for adding queries to your stored procedures. Finally, you will explore several methods to optimize the performance of your stored procedures. When you’re finished with this course, you will have the skills and knowledge necessary to consistently deliver optimal stored procedures in SQL Server.

About the author
About the author

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

More from the author
Implementing SSRS Report Layouts
Beginner
2h 15m
Aug 28, 2020
More courses by Jared Westover
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Jared Westover, and welcome to my course, Capturing Logic with Stored Procedures in T-SQL. I'm a SQL architect and Microsoft-certified solutions expert in data management and analytics. Most importantly, I love working with data. If you've worked in a database environment where ad hoc queries were the primary method of executing code, you know how problematic that can be. It's easy to run obsolete scripts, especially if you're working on a large team of developers. No one wants their email to be the primary source of truth when it comes to executing code. In this course, we're going to explore all of the possibilities which exist for executing your queries using stored procedures. Having knowledge of SQL Server and prior experience writing queries will be helpful as you go through the course. Some of the major topics that we will cover include the benefits of using stored procedures, incorporating input and output parameters, establishing a baseline for performance, and finally methods for optimizing your stored procedures. By the end of this course, you will have a solid foundation to start creating and optimizing stored procedures. From here, you should feel comfortable diving into other SQL courses on Overcoming Parameter Sniffing, Advanced Query Tuning, and Plan Cache Analysis. I hope you'll join me on this journey to learn stored procedures with Capturing Logic with Stored Procedures in T-SQL course, at Pluralsight.