Hey, You Got Your TDD in MySQL DB: CodeMash

CodeMash 2020 | Hey, You Got Your TDD in MySQL DB | Jeff McKenzie
Course info
Level
Intermediate
Updated
Feb 7, 2020
Duration
44m
Table of contents
Hey, You Got Your TDD in MySQL DB
Description
Course info
Level
Intermediate
Updated
Feb 7, 2020
Duration
44m
Description

When should you test your data? From an application development perspective, a unit test against a database isn't a unit test at all, which makes sense because connected systems introduce overhead and dependency, both of which reduce stability and decrease productivity during test-driven development (TDD). If you wait for integration testing, critical functionality can get missed. In this session, Jeff McKenzie will discuss strategies for filling the data testing gap, directly within a Microsoft SQL Server environment. If you do a lot of work in T-SQL but aren't familiar with TDD, you'll learn the why and how of test-first development. If you're accomplished with unit tests but never tried them in your database, you'll learn how to apply familiar concepts like setup, mocking, and assertion. The majority of this session will focus on walking through a solution based on a real-world project, specifically using the open source tSQLt database unit testing framework.

About the author
About the author

CodeMash is a conference for developers. We eat, drink, and learn about all things code. Do it all in shorts and sandals by a pool.

More from the author
Test-driven Development: CodeMash
Intermediate
50m
Feb 9, 2020
Postman Delivers: CodeMash
Intermediate
49m
Feb 7, 2020
What's New in Xamarin Forms 4.0: CodeMash
Intermediate
53m
Feb 7, 2020
More courses by CodeMash