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
Schema Binding
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock