- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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
Intermediate
Table of contents
-
Version Check | 20s
-
Introduction | 23s
-
What is a unit test? | 2m 42s
-
What does a unit test give me? | 3m 18s
-
When should I write unit tests? | 1m 58s
-
An introduction to tSQLt | 1m 32s
-
tSQLt Walkthrough | 4m 47s
-
An Introduction to SQL Test | 1m 14s
-
SQL Test Walkthrough | 4m 20s
-
Anatomy of a Test Run | 2m 57s
-
Summary | 55s
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.