SQL Server Functions Fundamentals: Building Your First Functions
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 a programmability feature called functions, which allows you to create reusable code.
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, SQL Server Functions Fundamentals: Building Your First Functions, we’ll look into a feature set called functions.
First, you’ll explore what functions are and which types of functions exist in SQL Server.
Next, you’ll discover the best practices on how and when to apply them.
Finally, you’ll learn how functions can impact your database’s performance.
When you’re finished with this course, you’ll have the skills and knowledge of the basics of functions in SQL Server needed to know how and when to use them.
Table of contents
- What Are Functions and Which Types Exist? 3m
- Demo: Building Your First Functions in SQL Server 3m
- Use Cases and Practical Examples for Functions 1m
- Demo: Use Cases and Practical Examples for Functions in SQL Server 8m
- Functions and Performance 2m
- Demo: Functions and Performance in SQL Server 2m
- Summary 1m
About the author
Ben Weissman, a Microsoft Data Platform MVP, has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. Besides his Pluralsight courses, Ben is also the co-author of multiple books on data and kubernetes including "SQL Server on Kubernetes ", "Azure Arc-enabled Data Services", "SQL Server Big Data Clusters" and "The Biml Book". He is also a regular speaker at international events. Ben and his team at Solisyon have been involved in more than 200 Business I... more