Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
