MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Unit Testing T-SQL Code with tSQLt

Course Summary

SQL Server developers have, until recently, been unable to benefit from unit testing to produce reliable code which can be properly regression tested at the unit level. Covering how and why to unit test, examples and potential pitfalls, this course leads

  • +

    Course Syllabus

    ● Unit testing T-SQL code with tSQLt
        ◦ Introduction
        ◦ What is a unit test?
        ◦ What does a unit test give me?
        ◦ When should I write unit tests?
        ◦ An introduction to tSQLt
        ◦ tSQLt Walkthrough
        ◦ An Introduction to SQL Test
        ◦ SQL Test Walkthrough
        ◦ Anatomy of a Test Run
        ◦ Summary
    ● How to Write your First Unit Test
        ◦ Introduction
        ◦ Introducing the CustomerManagement Database
        ◦ Installing the CustomerManagement Database
        ◦ Installing tSQLt to the Database
        ◦ Failing at First
        ◦ Our First Requirement
        ◦ A First Unit Test
        ◦ Testing our Output
        ◦ Summary
    ● Isolating Dependencies
        ◦ Introduction
        ◦ What is a dependency?
        ◦ Why isolate from other areas of code?
        ◦ Isolating from Tables
        ◦ Faking our Tables
        ◦ Testing no Data
        ◦ Using Setup Routines
        ◦ Converting our Tests to use a Setup Procedure
        ◦ Isolating from Stored Procedures
        ◦ Testing other Stored Procedures are Called Correctly
        ◦ Isolating from Functions
        ◦ Limitations of Isolation
        ◦ Summary
    ● What Can We Test For?
        ◦ Introduction
        ◦ What is an Assertion?
        ◦ Combining Assertions in a Test
        ◦ Testing data in Tables
        ◦ Demo - AssertEqualsTable
        ◦ Checking for Empty Tables
        ◦ Checking Meta Data
        ◦ Demo - AssertResultSetsHaveSameMetaData
        ◦ A Review of Table Assertions
        ◦ Checking Strings
        ◦ Demo - AssertEqualsString
        ◦ Checking Patterns in Strings
        ◦ Demo - AssertLike
        ◦ Checking Values
        ◦ Demo - AssertEquals
        ◦ A Review of Strings and Values
        ◦ Testing for the Existance of Objects
        ◦ Demo - AssertObjectExists
        ◦ Exception Handling
        ◦ Demo - ExpectException
        ◦ Demo - ExpectNoException
        ◦ A Review of Objects and Exceptions
        ◦ Summary
    ● How Do I Unit Test in My Day to Day Work?
        ◦ Introduction
        ◦ How to Approach Writing Tests
        ◦ Setting up a Scenario
        ◦ Testing Tests
        ◦ Do I need to test everything?
        ◦ What if my test fails?
        ◦ Do you work alone?
        ◦ Deciding on Conventions
        ◦ Naming test Classes
        ◦ Naming Tests
        ◦ Understandable Tests
        ◦ Sharing Tests
        ◦ Source Controlling Tests
        ◦ Where do tests belong?
        ◦ Removing Tests from the Database
        ◦ When should I run tests?
        ◦ Summary
    ● Advanced Topics
        ◦ Introduction
        ◦ Insert Exec Behaviour
        ◦ Getting a Specific Result Set
        ◦ Insert Exec use in Stored Procedures
        ◦ What are we missing?
        ◦ Checking Constraints
        ◦ Checking Foreign Keys
        ◦ More Complex Requirements
        ◦ Using tSQLt to Enforce Development Standards
        ◦ Breaking out of the Transaction
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top