Simple play icon Course

SQL Server Functions Fundamentals: Building Your First Functions

by 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 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.

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

Ready to upskill? Get started