Unit Testing T-SQL Code with tSQLt

Covering how and why to unit test, examples and potential pitfalls, this course leads the SQL developer through using an open source framework to add unit tests to existing as well as new database developments.
Course info
Rating
(132)
Level
Intermediate
Updated
Dec 10, 2013
Duration
3h 50s
Table of contents
Unit testing T-SQL code with tSQLt
How to Write your First Unit Test
Isolating Dependencies
What Can We Test For?
How Do I Unit Test in My Day to Day Work?
Advanced Topics
Description
Course info
Rating
(132)
Level
Intermediate
Updated
Dec 10, 2013
Duration
3h 50s
Description

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 use tSQLt when going 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 armory. The methods shown in this course apply to SQL Server versions 2005 and above.

Learn more about tSQLt today!

About the author
About the author

Dave is a data management specialist with more years' experience within the IT industry than he likes to admit. Dave focuses on databases and good development practices.

More from the author