Data is hard to manage and databases are hard to test. Database deployments are far more complicated than application deployment, since you cannot redeploy your code from scratch every time. Database automation is tough and more often it’s the fear of messing up the critical data that can pause the forward development and slow down business delivery.

Writing SQL Unit Tests is an integral part of the database lifecycle and gives more confidence to developers to push a change to Production. Unit Testing, done right, can save you from burning midnight oil and fighting production issues after a deployment.

Come join me in this session to learn how to effectively test your database code, isolate external dependencies with mock objects, gain in-depth understanding of mocking and assertion frameworks, write data driven tests and also running automated tests as part of the Continuous Integration process. This will be a demo intensive session and I will explain the various challenges we faced in our organization while writing automated tests for our database code and how we successfully resolved them.