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

Pluralsight

Automate Data Workflows with SQL Server Stored Procedures

via Pluralsight

Overview

This course will
teach you how to create, fine-tune, and secure stored procedures.

Learn to automate and optimize data workflows. In this course, Automate Data Workflows with SQL Server Stored Procedures, you'll become adept at enhancing and managing sophisticated database routines. First, you'll be introduced to the foundational concepts of SQL Server stored procedures. Next, you'll learn to modify and fine-tune existing stored procedures for improved performance. This includes mastering the strategic application of the ALTER PROCEDURE command and understanding the implications of query recompilation. Finally, you'll explore advanced strategies for error handling, optimizing stored procedure performance, and securing data access. Upon completing this course, you'll possess a comprehensive set of skills to design, implement, and optimize stored procedures in SQL Server.

Syllabus

  • Course Overview 1min
  • Understanding and Creating Stored Procedures 12mins
  • Optimizing Performance and Ensuring Data Integrity 10mins

Taught by

Pinal Dave

Reviews

Start your review of Automate Data Workflows with SQL Server Stored Procedures

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.