- Course
- Data
Write Reliable and Reusable T-SQL Code
SQL Server is one of the most popular database systems out there being used by enterprises of all sizes, verticals, and regions. This course will teach you how to improve your T-SQL code by making it reusable and more reliable.
What you'll learn
Complex business requirements in SQL Server often require individual code so they can be fulfilled in an efficient and performant way. In this course, Write Reliable and Reusable T-SQL Code, we’ll look into ways how you can make your T-SQL code more stable.
First, you’ll explore what ways of creating reusable code exist in T-SQL.
Next, you’ll discover the difference between functions and stored procedures and when to use which. Finally, you’ll learn how to handle errors in your code, making it more reliable.
When you’re finished with this course, you’ll have the skills and knowledge of the basics on writing reliable and reusable T-SQL code.
Table of contents
About the author
Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, author and speaker at data events around the world.