2013
Pluralsight
Dave Green
3h 0m
English

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.

01. Unit testing T-SQL code with tSQLt
01. Introduction.wmv
02. What is a unit test .wmv
03. What does a unit test give me .wmv
04. When should I write unit tests .wmv
05. An introduction to tSQLt.wmv
06. tSQLt Walkthrough.wmv
07. An Introduction to SQL Test.wmv
08. SQL Test Walkthrough.wmv
09. Anatomy of a Test Run.wmv
10. Summary.wmv

02. How to Write your First Unit Test
01. Introduction.wmv
02. Introducing the CustomerManagement Database.wmv
03. Installing the CustomerManagement Database.wmv
04. Installing tSQLt to the Database.wmv
05. Failing at First.wmv
06. Our First Requirement.wmv
07. A First Unit Test.wmv
08. Testing our Output.wmv
09. Summary.wmv

03. Isolating Dependencies
01. Introduction.wmv
02. What is a dependency .wmv
03. Why isolate from other areas of code .wmv
04. Isolating from Tables.wmv
05. Faking our Tables.wmv
06. Testing no Data.wmv
07. Using Setup Routines.wmv
08. Converting our Tests to use a Setup Procedure.wmv
09. Isolating from Stored Procedures.wmv
10. Testing other Stored Procedures are Called Correctly.wmv
11. Isolating from Functions.wmv
12. Limitations of Isolation.wmv
13. Summary.wmv

04. What Can We Test For
01. Introduction.wmv
02. What is an Assertion .wmv
03. Combining Assertions in a Test.wmv
04. Testing data in Tables.wmv
05. Demo - AssertEqualsTable.wmv
06. Checking for Empty Tables.wmv
07. Checking Meta Data.wmv
08. Demo - AssertResultSetsHaveSameMetaData.wmv
09. A Review of Table Assertions.wmv
10. Checking Strings.wmv
11. Demo - AssertEqualsString.wmv
12. Checking Patterns in Strings.wmv
13. Demo - AssertLike.wmv
14. Checking Values.wmv
15. Demo - AssertEquals.wmv
16. A Review of Strings and Values.wmv
17. Testing for the Existance of Objects.wmv
18. Demo - AssertObjectExists.wmv
19. Exception Handling.wmv
20. Demo - ExpectException.wmv
21. Demo - ExpectNoException.wmv
22. A Review of Objects and Exceptions.wmv
23. Summary.wmv

05. How Do I Unit Test in My Day to Day Work
01. Introduction.wmv
02. How to Approach Writing Tests.wmv
03. Setting up a Scenario.wmv
04. Testing Tests.wmv
05. Do I need to test everything .wmv
06. What if my test fails .wmv
07. Do you work alone .wmv
08. Deciding on Conventions.wmv
09. Naming test Classes.wmv
10. Naming Tests.wmv
11. Understandable Tests.wmv
12. Sharing Tests.wmv
13. Source Controlling Tests.wmv
14. Where do tests belong .wmv
15. Removing Tests from the Database.wmv
16. When should I run tests .wmv
17. Summary.wmv

06. Advanced Topics
01. Introduction.wmv
02. Insert Exec Behaviour.wmv
03. Getting a Specific Result Set.wmv
04. Insert Exec use in Stored Procedures.wmv
05. What are we missing .wmv
06. Checking Constraints.wmv
07. Checking Foreign Keys.wmv
08. More Complex Requirements.wmv
09. Using tSQLt to Enforce Development Standards.wmv
10. Breaking out of the Transaction.wmv
11. Summary.wmv

http://pluralsight.com/

Download File Size:545.75 MB

---