Unit testing SQL Server code using tSQLt

Learn how to unit test your T-SQL code with the premier SQL Server unit testing tool tSQLt

  Enroll in Course


If you write code for SQL Server, you have probably the most critical code to write in the most mission-critical applications. TDD or at least unit testing with application code is ubiquitous however unit testing T-SQL code is hard.

Wouldn’t it be nice to know that you can write code knowing that it does what it is supposed to do and when you make changes to your code you (or whoever makes the changes) does not break any other code?

How about being able to prove that some of the uglier things like recursive triggers or pages and pages of stored procedure code are covered by a good suite of unit tests?
In this course we will show you how to:
  • Get tSQLt installed
  • Create unit tests
  • Run your unit test suite
  • Simplify T-SQL testing by isolating the schema from the code
  • Learn where, when AND how to write effective unit tests to help make your development experience both less risky and more fun
  • Understand the trickier parts of unit testing and ensure that you have the skills to develop a useful set of tests that can help you deliver your code faster.


Class Curriculum


  Course Introduction
Available in days
days after you enroll
  Testing without data
Available in days
days after you enroll

Your Instructor


Ed
Ed
Ed has been working with SQL Server for over ten years and has been promoting development excellence and DevOps practices for SQL Server, at his blog https://the.agilesql.club, Simple-Talk https://www.red-gate.com/simple-talk/author/edward... as well as speaking at various events in the UK such as "SQL Relay", "SQL Supper", "London .Net UG" and WinOps London.
Ed is an active member of the "Microsoft Visual Studio ALM | DevOps Rangers" programme: https://blogs.msdn.microsoft.com/visualstudioalmrangers/
Ed has implemented unit testing for SQL Server in a number of different environments and seen the benefits that it can apply to even the most complicated databases and environments.

Ed Elliott https://www.linkedin.com/in/edelliottuk


Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
I don't want to pay, can I have the course for free?
Yes, you are welcome to sign-up for the weekly version of the course.

The course will give you the skills you need to be able to unit test SQL Server, T-SQL code with tSQLt but you will need to be a little bit patient, plus you miss out on an expert pairing session where we can write unit tests for your actual code or answer any questions you have.

To sign up for the weekly course just choose the free plan when you signup!
What happens in the expert pairing session?
The goal of the expert session is to make sure you have understood the core concepts of unit testing with tSQLt and to offer guidance on how to write effective unit tests for your code. It will be a two-hour session, most likely over skype but in person can be arranged depending on location.
Can I have a course certificate?
If you pay for a plan and answer a question correctly and can demonstrate that you can write a tSQLt test then you can of course get a certificate to show you have completed the course.

Get started now!