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

Covering how and why to unit test, examples and potential pitfalls, this course leads the SQL developer through using an open source framework to add unit tests to existing as well as new database developments.

  • +

    Course Syllabus

    Unit testing T-SQL code with tSQLt
    - 24m 6s

    —Introduction 0m 23s
    —What is a unit test? 2m 42s
    —What does a unit test give me? 3m 18s
    —When should I write unit tests? 1m 58s
    —An introduction to tSQLt 1m 32s
    —tSQLt Walkthrough 4m 47s
    —An Introduction to SQL Test 1m 14s
    —SQL Test Walkthrough 4m 20s
    —Anatomy of a Test Run 2m 57s
    —Summary 0m 55s
    How to Write your First Unit Test
    - 28m 22s

    —Introduction 0m 23s
    —Introducing the CustomerManagement Database 1m 59s
    —Installing the CustomerManagement Database 1m 38s
    —Installing tSQLt to the Database 3m 4s
    —Failing at First 5m 14s
    —Our First Requirement 2m 10s
    —A First Unit Test 6m 20s
    —Testing our Output 6m 28s
    —Summary 1m 6s
    Isolating Dependencies
    - 24m 36s
    What Can We Test For?
    - 39m 52s
    How Do I Unit Test in My Day to Day Work?
    - 29m 9s
    Advanced Topics
    - 34m 50s

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