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 the ins and outs of designing and optimizing stored procedures.
What you'll learn
Perhaps you’re starting or have been working with stored procedures for years. Maybe you want to take your understanding of stored procedures in SQL Server to the next level. In this course, Capturing Logic with Stored Procedures in T-SQL, you will learn foundational knowledge for developing powerful stored procedures. First, you will learn why utilizing stored procedures in SQL Server is paramount to executing maintainable code, and why using temporary objects might reduce complexity. Next, you will discover methods for adding queries to your stored procedures. Finally, you will explore several techniques to optimize the performance of your stored procedures. When you’re finished with this course, you will have the skills and knowledge necessary to consistently deliver optimal stored procedures in SQL Server.
Table of contents
- Introduction 3m
- What Is a Stored Procedure? 3m
- Data Fetching Options 2m
- Comparing Views and Stored Procedures 3m
- Stored Procedure Benefits 1m
- Maintaining Code 2m
- Demo: Creating Your Environment 6m
- Demo: Maintaining Business Logic 3m
- Security Benefits 2m
- Demo: Securing Tables 2m
- Performance Gains 2m
- Demo: Plan Reuse 4m
- Reviewing Disadvantages 2m
- Summary 2m
- Introduction 2m
- Creating Your First Stored Procedure 2m
- Exploring New Syntax and Executing 3m
- Naming Stored Procedures 2m
- Demo: Creating and Executing 5m
- Demo: Scripting Stored Procedures 3m
- Exploring Parameters 2m
- Demo: Adding Parameters 4m
- Demo: Finding Dependencies 3m
- Best Practices 3m
- Summary 1m
- Introduction 2m
- Working with Queries 2m
- Reviewing Temporary Objects 3m
- Creating Temporary Objects 2m
- Demo: Adding Queries to Stored Procedures 4m
- Demo: Using Temporary Objects 7m
- Exploring Table Valued Parameters 3m
- Demo: Table-valued Parameters 3m
- Examining SP_EXECUTESQL 3m
- Demo: Using SP_EXECUTESQL 4m
- Implementing a Debug Flag 2m
- Demo: Adding a Debug Flag 3m
- Summary 2m
About the author
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv... more