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.

1. Course Overview

1. Course Overview

02. Exploring the Benefits of Stored Procedures

01. Version Check

02. Introduction

03. What Is a Stored Procedure

04. Comparing Data Fetching Options

05. Primary Stored Procedure Benefits

06. Demo - Creating Test Environment

07. Demo - Minimizing Modifications

08. Exploring Security Benefits

09. Demo - Limiting User Access

10. Exploring Performance Gains

11. Demo - Execution Plan Reuse

12. Disadvantages of Stored Procedures

13. Summary

03. Creating Our First Stored Procedure

01. Introduction

02. Creating Our Stored Procedure

03. Exploring New Syntax and Executing

04. Naming Stored Procedures

05. Demo - Creating and Executing

06. Demo - Scripting Stored Procedures

07. Exploring Parameters

08. Demo - Adding Parameters

09. Exploring Debugger

10. Demo - Debugging Code

11. Reviewing Best Practices

12. Summary

04. Setting up Queries in Stored Procedures

01. Introduction

02. Building Queries in Stored Procedures

03. Reviewing Temporary Objects

04. Creating Temporary Objects

05. Demo - Adding Queries to Stored Procedures

06. Demo - Using Temporary Objects

07. Exploring Table Valued Parameters

08. Demo - Table Valued Parameters

09. Examining Sp executesql

10. Demo - Using Sp executesql

11. Implementing a Debug Flag

12. Demo - Adding a Debug Flag

13. Summary

5. Optimizing Stored Procedure Performance

1. Introduction

2. Creating a Baseline

3. Demo - Gathering Baseline Stats

4. Busting Performance Myths

5. Demo - Temp Table Myth

6. Demo - Select 1 Versus Select

7. Exploring Parameter Sniffing

8. Demo - Parameter Sniffing

9. Summary

6. Building Stored Procedures in the Real World

1. Introduction

2. Defining Stored Procedure Templates

3. Demo - Creating Templates

4. Exploring Key Takeaways

5. Continuing the Journey

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight