Programming SQL Server Database Stored Procedures

Focused View

Mike McQuillan

2:05:36

141 View

1. Course Overview

1. Course Overview.mp4

02:10

2. Creating Your First Stored Procedure

1. Introduction.mp4

02:33

2. A Quick SQL Server Recap.mp4

03:46

3. What Is a Stored Procedure.mp4

05:09

4. Installing SQL Server and Setting up a Database.mp4

05:23

5. Stored Procedure T-SQL Statements.mp4

03:16

6. Creating a Stored Procedure.mp4

03:37

7. Managing Procedures Using SQL Server Management Studio.mp4

04:55

8. Summary.mp4

00:58

03. Creating Stored Procedures and Using Parameters

01. Introduction.mp4

01:11

02. The Business Requirement.mp4

04:00

03. The Insert Contact Stored Procedure.mp4

02:50

04. Executing and Testing a Stored Procedure.mp4

02:35

05. Adding Parameters to a Stored Procedure.mp4

05:32

06. Optional Parameters.mp4

02:48

07. Retrieving Record Identifiers.mp4

07:36

08. Output Parameters.mp4

04:14

09. Using SET Options.mp4

03:25

10. Calling a Procedure from Another Procedure.mp4

02:58

11. Adding Business Logic.mp4

04:05

12. Summary.mp4

01:39

4. Table-valued Parameters and Refactoring

1. Introduction.mp4

01:11

2. Inheriting a Stored Procedure.mp4

05:08

3. Alternatives to Cursors.mp4

03:03

4. User-defined Data Types.mp4

06:11

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

01:54

6. Summary.mp4

00:58

5. Debugging and Troubleshooting Stored Procedures

1. Introduction.mp4

01:13

2. The Print Statement.mp4

06:14

3. Debugging with SQL Server Management Studio.mp4

09:23

4. Handling Errors with TryCatch.mp4

04:18

5. Return Codes.mp4

02:27

6. Handling Failed Transactions.mp4

03:14

7. Defensive Coding.mp4

03:01

8. Summary.mp4

02:41

Description

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.

What You'll Learn?

Ever wondered how to create repeatable, consistent, secure code in SQL Server? If you have, it sounds like you need to learn about stored procedures. In this course, Programming SQL Server Database Stored Procedures, you will gain the ability to create and manage stored procedures in Microsoft SQL Server. First, you will learn what a stored procedure is and how to create and manage simple procedures using SQL Server Management Studio. Next, you will discover how powerful stored procedures can be when you use parameters. Stored procedures support simple parameters like strings and integers, but you’ll also see how you can use your own custom data types as parameters with a stored procedure. Then, you will return data from stored procedures, using record sets and output parameters. Finally, you will explore how to debug your stored procedures as you write them, starting off with the basic PRINT statement before moving on to stepping through code using SQL Server Management Studio. When you’re finished with this course, you will have the skills and knowledge of SQL Server needed to create and manage your own stored procedures. Software required: SQL Server Development Edition, SQL Server Management Studio

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Microsoft SQL

Mike McQuillan

Instructor's Courses

Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he's working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doesn't know why he does that either.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.