This one day hands-on class introduces development practices utilized in Agile database development. The course will primarily focus on the use of unit testing, test driven development (TDD), version control, and continuous integration (CI).

Course Description


Course objectives:

After attending this class students will be able to:
  • Write and execute database unit test cases
  • Apply TDD to creating database objects, such as stored procedures, views, and functions
  • Explain and apply the concepts of test doubles and mocks
  • Manage their database structure and source code in a version control repository
  • Implement a CI process and explain the essential CI process parts
  • Identify where Agile database practices fit into the overall development lifecycle


Course outline:

  • Introduction to TDD
  • The first test – Assemble, Act & Assert
  • Using assertions
  • Isolating dependencies with Fakes and Spies
  • Introduction to CI
  • Source control your SQL Server
  • Automating the build
  • Schema Migrations
  • Running your Tests in CI
  • Build triggers and notifications


Is this course for me?

  • You're a developer who designs T-SQL objects, such as stored procedures, functions, and views.
  • You can use SQL Server Management Studio to write and execute simple Stored Procedures and SELECT statements.
  • You will need to bring a laptop with SQL Server installed on it. Please note both the server and client tools are required and SQL Server Express Edition is not suitable for this class.

A one-day introduction to Agile database practices with SQL Server, held between Red Gate’s SQL in the City and SQL PASS Summit 2012.

Seattle. Tuesday, November 6th 2012

Additional Information

Contact us:

If you have any questions, or would like more details about the course content, please get in touch:

These classes will follow Red Gate's SQL in the City US Tour, however are run independently by Sebastian Meine and Dennis Lloyd. This course has been designed carefully to help you get the most out of SQL in the City.

In order to attend a SQL in the City event:

Visit Red Gate's website

SQL in the City Logo
An Introduction to Agile Database Development with Sebastian Meine and Dennis Lloyd.

"If you work with SQL Server and want to introduce Agile database practices to your team, then this course is for you! You'll get a thorough, hands-on overview of Agile database development. To sign up, simply click the button for your city. "

Sebastian Meine, PHD
Principal trainer and consultant with sqlity.net