Write Reliable and Reusable T-SQL Code
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 36m | 104 MB
Instructor: Ben Weissman
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 36m | 104 MB
Instructor: Ben Weissman
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.