Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Integrating Functions and Procedures in SQL Server Workflows

This course will teach you how to use functions and procedures apart and together to build robust data management systems.

Gerald Britton - Pluralsight course - Integrating Functions and Procedures in SQL Server Workflows
by Gerald Britton

What you'll learn

Managing data in a complex SQL Server environment can be challenging when coding is done using standard DML queries. In this course, Integrating Functions and Procedures in SQL Server Workflows, you’ll gain the ability to use functions and procedures together in a data management environment to build robust systems. First, you’ll explore how to automate common processes using functions and procedures. Next, you’ll discover how to use transactions effectively to maintain the principles of ACID. Finally, you’ll learn how to handle typical errors in code to reduce manual intervention. When you’re finished with this course, you’ll have the skills and knowledge of SQL Server functions and stored procedures needed to combine them efficiently in complex data workflows.

Table of contents

About the author

Gerald Britton - Pluralsight course - Integrating Functions and Procedures in SQL Server Workflows
Gerald Britton

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More Courses by Gerald