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
(124)
Level
Intermediate
Updated
Dec 10, 2013
Duration
3h 0m
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
(124)
Level
Intermediate
Updated
Dec 10, 2013
Duration
3h 0m
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 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.

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
Section Introduction Transcripts
Section Introduction Transcripts

Unit testing T-SQL code with tSQLt
Hello my name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments, giving you repeatable tests, which give you confidence in your database code. In this module we will explore the tools and techniques we will use to start unit testing.

How to Write your First Unit Test
Hello my name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments, giving you repeatable tests, which give you confidence in your database code. In this module we'll use the tools we introduced in the first module to build our first unit test.

Isolating Dependencies
Hello. My name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments, giving you repeatable tests, which give you confidence in your database code. In this module we will see what dependencies are, why we need to isolate our code from them, and how to accomplish this.

What Can We Test For?
Hello, my name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments giving you repeatable tests, which give you confidence in your database code. In this module we will see what assertions are, what we can test for, and how we can see that our test conditions are met.

How Do I Unit Test in My Day to Day Work?
Hello, my name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments giving you repeatable tests, which give you confidence in your database code. In this module we will see how to approach writing tests and how to integrate writing tests into your day to day workflow. We'll look at how to write tests that others in the team can use sensibly and how to use unit testing to give you confidence in your database code.

Advanced Topics
Hello, my name is Dave Green and I'm recording this course for Pluralsight. This course will teach you how to unit test your T-SQL database developments giving you repeatable tests, which will give you confidence in your database code. In this module we will look at some more advanced uses of tSQLt, how to handle questions that the built-in assertions don't allow you to test simply, and look at enforcing development standards.