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.
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
Course Overview Hello there. Welcome to Pluralsight. My name is Mike McQuillan, and this course is programming SQL Server Database Stored Procedures. Writing database code in an ad hoc fashion can be tiring, inefficient, and worst of all, plain boring! But stored procedures are here to help make things far more exciting. This course will show you just how wonderful stored procedures in SQL Server are and how they can help you greatly improve your database development practices. You'll be introduced to the do's and don'ts of stored procedure development, learning how a stored procedure used in the right manner can lead to more efficient and secure code. Along the way, you will see how SQL Server Management Studio can be used to create, edit, and manage your stored procedures. The best stored procedures allow users to control them via parameters. You can use parameters to dynamically change the output of the stored procedure, maybe as a filter on a report, for instance. The course goes into detail about parameters, and not just input parameters. You'll also see more complex parameters used, such as output parameters and table-valued parameters, also known as TVPs. TVPs are amazing, offering a fantastic way of sending multiple records to a stored procedure in a single call. It's like magic! Throughout all of this, we'll be creating plenty of stored procedures to demonstrate the techniques, including procedures that insert data and return data. Some of them might even do both. After learning about refactoring code, the course finishes up with a detailed look at debugging stored procedures. This ranges from using simple print statements to stepping through code line-by-line. I wonder if you knew you could do that with SQL Server Management Studio? Along the way, you'll see many tips and tricks for making the most of your stored procedures. Thanks for watching. See you at the course.