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

Pluralsight

Unit Testing T-SQL Code with tSQLt

via Pluralsight

Overview

This tSQLt course covers how and why to unit test, examples, and potential pitfalls using an open source T-SQL unit testing framework.

SQL Server developers have, until recently, been unable to benefit from unit testing to produce reliable code which can be properly regression tested at the unit level. Covering how and why to unit test, examples and potential pitfalls, this course leads the SQL developer through how to go about adding unit tests to existing as well as new database developments. We will be using the tSQLt open source framework and the Red Gate SQL Test tool to show how to easily add database unit testing to your development armoury. The methods shown in this course apply to SQL Server versions 2005 and above.

Syllabus

  • Unit testing T-SQL code with tSQLt 24mins
  • How to Write your First Unit Test 28mins
  • Isolating Dependencies 24mins
  • What Can We Test For? 39mins
  • How Do I Unit Test in My Day to Day Work? 29mins
  • Advanced Topics 34mins

Taught by

Dave Green

Reviews

4.1 rating at Pluralsight based on 139 ratings

Start your review of Unit Testing T-SQL Code with tSQLt

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.