Unit Testing T-SQL Code with tSQLt
Pluralsight
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 Description
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 the SQL developer through how to go about adding unit tests to existing as well as new database developments. We will be using the tSQLt open source framework and the Red Gate SQL Test tool to show how to easily add database unit testing to your development armoury. The methods shown in this course apply to SQL Server versions 2005 and above.
-
+
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 55sHow 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 6sIsolating Dependencies- 24m 36sWhat Can We Test For?- 39m 52sHow Do I Unit Test in My Day to Day Work?- 29m 9sAdvanced Topics- 34m 50s