Course Certificate | The Agile Sql Club

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Unit testing SQL Server code using tSQLt ** Note this hasn't been updated in a number of years so although the concepts are still relevent some details might not be correct

Course Introduction

Start Here...

Up & Running

Introduction
Installing tSQLt
Running Tests
Where should you install tSQLt?
What makes a test, a test in tSQLt?
What sort of code can tSQLt test?
Lesson 1: Key Takeaways

Testing without data

The theory
Implementing this in practice

Write a test walkthrough

Introduction
Writing a test from requirements through to passing test
Extra Assert Types

Isolating Objects

Introduction
FakeFunction
SpyProcedure
Summary

Testing the harder objects

Introduction
Using FakeTable and keeping identity columns
Keeping Computed Columns
Defaults
ApplyTrigger
ApplyConstraint
Exceptions
Summary

Real Life Case Studies

Introduction
Case Study One: tSQLt was extensively used
Case Study Two: Unit testing wasn't appropriate
Summary

Limitations & workarounds

Introduction
Transactions
Schema Binding
Cross DB Calls
Summary

Code Coverage

Introduction
What is Code Coverage
SQLCover
Summary

Using tSQLt as part of your CI/CD build process

Introduction
Creating a CI / CD Process in VSTS
Summary

Summary

Introduction
Core Concepts
Course Certificate
Finish

Teach online with

Course Certificate

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock