Unit Testing T-SQL Code with tSQLt

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.

• 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