-
Course
- Data
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.
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.
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
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 Courses by Dave