Mastering Stored Procedures in SQL Server

At the core of every successful real-life database application is modular and robust code. In this course, Mastering Stored Procedures in SQL Server, you'll gain the ability to create and implement efficient and scalable stored procedures using T-SQL. First, you'll explore the basics of stored procedures and their syntax. Next, you'll discover why it is of key importance to understand execution context and data encapsulation. Finally, you'll learn how to implement stored procedures to support complex business logic. When you're finished with this course, you'll have the skills and knowledge to create stored procedures in SQL Server needed to manipulate the data from SQL Server in the most efficient and modular way.
Homepage

https://www.pluralsight.com/courses/sql-server-mastering-stored-procedures