Join Unit Testing Experts Steve Jones and Sebastian Meine for this exciting opportunity to learn how to effectively use Unit Testing and the tSQLt framework to improve your T-SQL code quality and maintainability.

Abstract

We all want to build better code faster. That’s the mandate many of us are faced with in today’s fast paced world. One of the ways that many of the top developers in the world have improved their code is with the addition of quick unit tests that check their programming logic and prevent them from making the same mistake twice.

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

This one-day class introduces tSQLt, the framework for automated unit testing in SQL Server. You’ll learn techniques to write T-SQL code that is resilient to defects and is easy to change and maintain.

You will walk away with examples for testing your tables, views, stored procedures, and functions for ensuring calculations are correct and error handling is implemented.

Outline

This class is fast paced and hands on, with exercises to help you learn to write unit tests for your own applications. Here is an outline of what we will cover in seven action-packed hours.

Introduction to Unit Testing
What is tSQLt?
Your First Test
Executing Tests correctly
Effective use of Assertions
Separation of Concerns
Testing Exceptions
Test Case Heuristics
Dealing with Test Data
Other Types of Testing
How Unit Testing fits into your Development Process

The day will have you building and running multiple tests that cover a variety of scenarios to prepare you to implement Unit Testing successfully in real life.

Pricing

Super Early Bird $99.99 (available until 5/8/2015 4:00 AM EDT) Early Bird $124.99 (available until 5/22/2015 4:00 AM EDT) Standard Admission $149.99

(All sales are final.)

Unit Testing in SQL Server with tSQLt