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.
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
Table of contents
- Introduction 1m
- The Business Requirement 4m
- The Insert Contact Stored Procedure 3m
- Executing and Testing a Stored Procedure 3m
- Adding Parameters to a Stored Procedure 6m
- Optional Parameters 3m
- Retrieving Record Identifiers 8m
- Output Parameters 4m
- Using SET Options 3m
- Calling a Procedure from Another Procedure 3m
- Adding Business Logic 4m
- Summary 2m
Course FAQ
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system.
SQL is used to manage and organize data in all sorts of systems in which various data relationships exist.
In this course, you will learn about input parameters, output parameters, and table-valued parameters (TVPs). By the end of this course, you will know how to create stored procedures that insert data and return data.
This course is for anyone who wants to learn stored procedures in SQL Server. If you want to create repeatable, consistent, secure code in SQL Server, this course is for you.
Software required for this course is SQL Server Development Edition and Server Management Studio.
About the author
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 doe... more