Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Integrating Functions and Procedures in SQL Server Workflows

via Pluralsight

Overview

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

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.

Syllabus

  • Course Overview 1min
  • Automating Processes with Functions and Procedures 15mins
  • Solving Common Data Management Problems 13mins

Taught by

Gerald Britton

Reviews

Start your review of Integrating Functions and Procedures in SQL Server Workflows

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.