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

Pluralsight

Securing and Maintaining Stored Procedures in T-SQL

via Pluralsight

Overview

Do you build and maintain stored procedures? Well, this course is for you! Take your skills to the next level by learning all the ins and outs of securing and maintaining stored procedures.

Often, security and maintenance are the last thoughts on a developer's mind. But in today's data-driven world, keeping data secure is more relevant than ever! If you want to keep data protected and highly available, it's time to take your understanding of stored procedures in SQL Server to the next level. In this course, Securing and Maintaining Stored Procedures in T-SQL, you'll learn all about ensuring procedures are secure and performing optimally. First, you'll explore why developing a security and maintenance strategy is the first step towards progress. Next, you'll discover why granting the least privileges to a user is often the best course of action. Finally, you'll learn how to track the performance of stored procedures over time. After measuring performance, you'll be better equipped to implement tuning techniques. When you're finished with this course, you'll have the skills and knowledge required to secure and maintain stored procedure performance needed to ensure your company's data is protected and highly available.

Syllabus

  • Course Overview 1min
  • Building a Security and Maintenance Strategy 26mins
  • Granting Permissions 25mins
  • Executing Stored Procedures 20mins
  • Encrypting and Signing Stored Procedures 22mins
  • Maintaining Performance 23mins

Taught by

Jared Westover

Reviews

4.5 rating at Pluralsight based on 11 ratings

Start your review of Securing and Maintaining Stored Procedures in T-SQL

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.