Programming SQL Server Database Stored Procedures

سرفصل های دوره

So, you use SQL Server. But are you using stored procedures? No? Then you're not using SQL Server's full potential! Watch this course to learn how to reduce code, maximize performance, and simplify security in your databases with stored procedures.

1. Course Overview

1. Course Overview

2. Creating Your First Stored Procedure

1. Introduction

2. A Quick SQL Server Recap

3. What Is a Stored Procedure

4. Installing SQL Server and Setting up a Database

5. Stored Procedure T-SQL Statements

6. Creating a Stored Procedure

7. Managing Procedures Using SQL Server Management Studio

8. Summary

03. Creating Stored Procedures and Using Parameters

01. Introduction

02. The Business Requirement

03. The Insert Contact Stored Procedure

04. Executing and Testing a Stored Procedure

05. Adding Parameters to a Stored Procedure

06. Optional Parameters

07. Retrieving Record Identifiers

08. Output Parameters

09. Using SET Options

10. Calling a Procedure from Another Procedure

11. Adding Business Logic

12. Summary

4. Table-valued Parameters and Refactoring

1. Introduction

2. Inheriting a Stored Procedure

3. Alternatives to Cursors

4. User-defined Data Types

5. Calling a Stored Procedure with a Table-valued Parameter

6. Summary

5. Debugging and Troubleshooting Stored Procedures

1. Introduction

2. The Print Statement

3. Debugging with SQL Server Management Studio

4. Handling Errors with TryCatch

5. Return Codes

6. Handling Failed Transactions

7. Defensive Coding

8. Summary

45,900 تومان

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

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

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

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