Database Unit Testing for SQL Server Using tSQLt
Pearson (Publisher)
Published on 28. June 2024
Other
Undefined
978-0-13-356436-5 (ISBN)
Description
Using Test-Driven Development (TDD), thousands of agile developers are delivering software that is more rigorously tested, better designed, more robust, and easier to maintain. Until recently, however, database developers have been stymied by the unique characteristics of SQL code and the scarcity of useful tools. If you're an SQL Server developer who wants to use TDD, solutions now exist. In Database Unit Testing for SQL Server Using tSQLt, two pioneering database developers introduce those solutions and show you exactly how to apply them. Dennis Lloyd, Jr. and Sebastian Meine introduce their powerful new tSQLt open source unit testing framework for SQL Server, and show how to take full advantage of it.
Lloyd and Meine first explain the key TDD concepts that have made unit testing of non-database projects so effective, including isolating functions under test, using mocks to break up dependencies, and incrementally guiding designs. Next, they explain why these concepts haven't translated neatly to database development, and show how to overcome those disconnects. Then, building on this foundation, they introduce tSQLt and show you how to use it to create higher quality SQL Server code. Coverage includes:
Why TDD can be as valuable in database development as it is in object-oriented development
Writing effective unit tests for SQL Server T-SQL code
Quick, time-saving heuristics for identifying test cases
Advanced use cases for tSQLt and TDD
Applying TDD to new code
Refactoring existing database code through TDD
Integrating tSQLt and TDD with other development processes
Building and deploying databases in continuous improvement environments
Lloyd and Meine first explain the key TDD concepts that have made unit testing of non-database projects so effective, including isolating functions under test, using mocks to break up dependencies, and incrementally guiding designs. Next, they explain why these concepts haven't translated neatly to database development, and show how to overcome those disconnects. Then, building on this foundation, they introduce tSQLt and show you how to use it to create higher quality SQL Server code. Coverage includes:
Why TDD can be as valuable in database development as it is in object-oriented development
Writing effective unit tests for SQL Server T-SQL code
Quick, time-saving heuristics for identifying test cases
Advanced use cases for tSQLt and TDD
Applying TDD to new code
Refactoring existing database code through TDD
Integrating tSQLt and TDD with other development processes
Building and deploying databases in continuous improvement environments
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Weight
1 gr
ISBN-13
978-0-13-356436-5 (9780133564365)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions

Dennis Lloyd | Sebastian Meine
Database Unit Testing for SQL Server Using tSQLt
Book
07/2024
Pearson
€37.40
The article will not be published
Content
1. Introduction
2. Using tSQLt to write Unit Tests
3. Test Driven Design
4. How to Fit This in With the Rest of the App Development Process
5. Appendices
2. Using tSQLt to write Unit Tests
3. Test Driven Design
4. How to Fit This in With the Rest of the App Development Process
5. Appendices