I noticed recently that my friends, Dennis Lloyd (blog | twitter) and Sebastian Meine (blog | twitter) are running some one day workshops on TDD and agile practices in SQL to coincide with Red-Gate’s US SQL In the City tour.
I’ve seen Dennis and Sebastian present, not to mention having had various deep technical discussions over beer or dinner and these guys really know their stuff. As the authors of tSQLt, the leading unit testing framework for SQL 2005+, they really understand both the patterns and practices of test-driven development and how to apply agile techniques, including TDD, to the database development paradigm.
The course covers test-driven development practices and how they can be applied to databases including how to isolate test dependencies and mock database objects. These last two are critical to being able to successfully implement TDD for databases without wasting time on unnecessary setup – the usual reason why people give up with TDD in the SQL space. The course also covers continuous integration and source control as they relate to database development. At the end of this one day program you should have a much better understanding of a range of agile patterns and practices and how to apply them in the real world.
Dennis and Sebastian are running this pre-con at just four of the six SQL In The City events and the price includes free or reduced-cost licences for selected products from the Red-Gate developer suite. The venues are San Francisco, Chicago, Boston and Seattle and my advice is go here as soon as possible to book your place before they fill up. I should point out that I get no payment if you book on any of these days, I just think it’s a great opportunity to learn from two of the foremost experts in this field. In fact, if I could get away from the UK I’d be going to one of them myself.