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.
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 is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. 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).