If you write code to SQL Server then you might be interested in this: at the end of 2017 I wrote a tSQLt tdd training course which has helped over 300 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club. The course is free if you are happy to wait 10 weeks to complete it, with 1 lesson being made available per week - if you are in more of a hurry or you would like to help support the project you can purchase the course which makes it instantly available to you.
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art of writing repeatable, using unit tests for even the most complicated T-SQL code
UPDATE: I thought that if I got a certain number by October 1st I would run the course but in two days I had three times the number of people subscribe than my initial target so I have closed the first course, sign up if you want to join the waitlist or the next course!
NEW UPDATE: Enroll in the course here: https://courses.agilesql.club/p/unit-testing-sql-server-code-using-tsqlt
Unit testing helps us to write better code, make rapid changes to our code and has been generally seen as a good idea for about 10 years. Writing tests for T-SQL code is made much easier by using tSQLt but there is quite a high barrier to entry both in terms of the technical skills in getting tSQLt running and also how to approach large code bases of, sometimes, unfriendly T-SQL code and taming the code with unit tests.
I have successfully unit tested T-SQL code in a number of different environments including clean greenfield environments as well as legacy projects and I have written this course to help people get started with unit testing but also help them to turn unit testing into a part of their development process that they can use every day to improve the quality of their work and the speed at which deployments can be made.
Are you any of these people?
- An application developer experienced with other testing frameworks for testing application code?
- A T-SQL developer with no testing experience?
- A -TSQL developer with testing experience in other languages or frameworks?
If you are then you should sign up (https://courses.agilesql.club/p/unit-testing-sql-server-code-using-tsqlt) and let me help you learn tSQLt unit testing for SQL Server.
Why an email course?
I thought it would be an interesting way to provide actionable information regularly and to allow a level of assistance and feedback that I don’t think is possible with blogging or writing articles.
How do I sign up?
Run over to: https://courses.agilesql.club/p/unit-testing-sql-server-code-using-tsqlt and pop in your details.
The course is going to start on the 1st of October and as it is the first one I am limiting the amount of people who can start it. If the first one is a success then I will run it again but it won’t be until at least 2018. available https://courses.agilesql.club/p/unit-testing-sql-server-code-using-tsqlt
What will be the format?
The course will be one email a week which will include an overview of the weeks topic, some detail into the parts that need it and an excercise for the week which can be done on a demo database or any SQL Server database code you have.
and it is free?
yep, gratis. I am not open sourcing yet - maybe in the future but the course itself is free, aka “no service charge”, you can pay if you want to be able to just sit down and do the course but free if you are happy to wait
September 11, 2017 - 19:42