The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 4, 2014

Edward E. Baptist: IMG The Two Bodies of The Half Has Never Been Told: Slavery and the Making of American Capitalism



My new book, The Half Has Never Been Told: Slavery and the Making of American Capitalism, is the story of two bodies. The first body was the new... Continue »
  1. $24.50 Sale Hardcover add to wish list

spacer

Coming Soon!

Preorder
$38.50
New Trade Paper
Available July 2015
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Database- Design

Database Unit Testing for SQL Server Using Tsqlt (Robert C. Martin)

by

Database Unit Testing for SQL Server Using Tsqlt (Robert C. Martin) Cover

 

Synopses & Reviews

Publisher Comments:

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

 

Synopsis:

Test-driven development (TDD) is an agile programming technique that leads to code that is rigorously tested, better designed, and easier to maintain over the course of a development project. Applying TDD to database development is a challenge for programmers. The authors of this book have created a unit testing framework for database programming in SQL Server to overcome these challenges. This framework, tSQLt, is unique among database unit testing frameworks and encourages users to apply TDD to SQL Server development.

 

This book moves database programming into the TDD era and helps SQL Server developers create higher-quality, easier-to-maintain database code with tSQLt. It presents the core concepts that make unit testing of non-database projects possible and effective; and then shows how they can be applied to specific problems in the database. These concepts include:

  • Isolating the function under test
  • Using mocks to break up dependencies
  • Moving in small steps to guide the design

Table of Contents

1 Introduction — Why unit testing in SQL Server is important and timely and why to use the Test-Driven approach

2 Using tSQLt to write Unit Tests

i Anatomy of a test

ii Isolating Dependencies

iii Advanced uses of tSQLt

3 Test Driven Design

i Understanding the benefits of TDD

ii Applying TDD to New Code

iii Legacy Code

4 How to fit this in with the rest of the app development process

i Continuous Integration

ii Team Building, Knowledge Sharing

iii Thin Slicing Features

5 Appendix

i Heuristics for identifying test cases

Product Details

ISBN:
9780133564327
Author:
Lloyd, Dennis
Publisher:
Prentice Hall
Author:
Meine, Sebastian, PhD.
Subject:
Database Management - General
Subject:
sql; sql server; tsqlt; sql server 2146885628; sql server g; Microsoft certifications; sql tutorial; sql server management studio; database software; sql server express; sql server 2008; learn sql; Microsoft training
Subject:
SQL Server + TDD; SQL Server + test-driven development; tSQLt framework; RedGate + SQL; agile + SQL Server; agile + database; SQL unit testing
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Robert C. Martin Series
Publication Date:
20141011
Binding:
Paperback
Language:
English
Pages:
288

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Database Unit Testing for SQL Server Using Tsqlt (Robert C. Martin) New Trade Paper
0 stars - 0 reviews
$38.50 Backorder
Product details 288 pages Prentice Hall - English 9780133564327 Reviews:
"Synopsis" by ,

Test-driven development (TDD) is an agile programming technique that leads to code that is rigorously tested, better designed, and easier to maintain over the course of a development project. Applying TDD to database development is a challenge for programmers. The authors of this book have created a unit testing framework for database programming in SQL Server to overcome these challenges. This framework, tSQLt, is unique among database unit testing frameworks and encourages users to apply TDD to SQL Server development.

 

This book moves database programming into the TDD era and helps SQL Server developers create higher-quality, easier-to-maintain database code with tSQLt. It presents the core concepts that make unit testing of non-database projects possible and effective; and then shows how they can be applied to specific problems in the database. These concepts include:

  • Isolating the function under test
  • Using mocks to break up dependencies
  • Moving in small steps to guide the design
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.