-
Course
- Data
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 the ins and outs of designing and optimizing stored procedures.
What you'll learn
Perhaps you’re starting or have been working with stored procedures for years. Maybe you want to take your understanding of stored 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, and why using temporary objects might reduce complexity. Next, you will discover methods for adding queries to your stored procedures. Finally, you will explore several techniques 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.
Table of contents
- Introduction | 2m 34s
- What Is a Stored Procedure? | 2m 38s
- Data Fetching Options | 1m 42s
- Comparing Views and Stored Procedures | 3m 19s
- Stored Procedure Benefits | 1m 16s
- Maintaining Code | 2m 7s
- Demo: Creating Your Environment | 5m 42s
- Demo: Maintaining Business Logic | 2m 32s
- Security Benefits | 2m 19s
- Demo: Securing Tables | 2m 13s
- Performance Gains | 2m 11s
- Demo: Plan Reuse | 3m 57s
- Reviewing Disadvantages | 1m 52s
- Summary | 1m 34s
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 Courses by Jared