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.

Course Curriculum

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

Your Instructor

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, Simple-Talk 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:
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

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. If I ever migrate away from teachable then you will be emailed a pdf of the entire course
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.
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.
What is the difference between the plans?
You can either pay less and get a lesson a week or pay more to get access to all the content straight away
I paid for the instant access course but I can't see all the content
Ping [email protected] and I will make sure you are granted full access to the course. Upgrading is a manual process because of limitations with teachable. I do endeavour to do it as quick as possible though.
Someone I know got the course for free
The original version was free for the weekly lesson but after helping over 500 people to learn tSQLt, as they say all good things must come to an end. If you literally cannot afford this or it would cause you hardship then ping me at [email protected] and we will figure something out.

Get started now!