Your favorite local bookstore.
Everywhere.

Sign up for our mailing list and save! JOIN THE LIST
Database Unit Testing for SQL Server Using Tsqlt

Database Unit Testing For Sql Server Using Tsqlt


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  



  • Condition: --
    HPB condition ratings
    • New: Item is brand new, unused and unmarked, in flawless condition.
    • Fine/Like New (F): No defects, little usage. May show remainder marks. Older books may show minor flaws.
    • Very Good (VG): Shows some signs of wear and is no longer fresh. Attractive. Used textbooks do not come with supplemental materials.
    • Good (G): Average used book with all pages present. Possible loose bindings, highlighting, cocked spine or torn dust jackets. Used textbooks do not come with supplemental materials.
    • Fair (FR): Obviously well-worn, but no text pages missing. May be without endpapers or title page. Markings do not interfere with readability. Used textbooks do not come with supplemental materials.
    • Poor (P): All text is legible but may be soiled and have binding defects. Reading copies and binding copies fall into this category. Used textbooks do not come with supplemental materials.
    Conditions Guide
  • Format: Paperback
  • Sold by: --
  • Language: English
  • Publisher: Prentice Hall
  • ISBN-13: 9780133564327
  • ISBN: 0133564320
  • Publication Year: 2019
HPB pick - Available on August 15, 2019
Loading...
Loading marketplace...
HPB condition ratings
  • New: Item is brand new, unused and unmarked, in flawless condition.
  • Fine/Like New (F): No defects, little usage. May show remainder marks. Older books may show minor flaws.
  • Very Good (VG): Shows some signs of wear and is no longer fresh. Attractive. Used textbooks do not come with supplemental materials.
  • Good (G): Average used book with all pages present. Possible loose bindings, highlighting, cocked spine or torn dust jackets. Used textbooks do not come with supplemental materials.
  • Fair (FR): Obviously well-worn, but no text pages missing. May be without endpapers or title page. Markings do not interfere with readability. Used textbooks do not come with supplemental materials.
  • Poor (P): All text is legible but may be soiled and have binding defects. Reading copies and binding copies fall into this category. Used textbooks do not come with supplemental materials.
Conditions Guide
HPB condition ratings
  • New: Mint condition or still sealed (SS). Absolutely perfect in every way. New.
  • Fine/Like New (EX): No defects, little sign of use, well cared for. Plays perfectly. Close to new. Not necessarily sealed or unused, but close. Could be an unopened promotional or cut item. Sometimes called: mint-minus.
  • Very Good (VG): Will show some signs that it was played and otherwise handled by a previous owner who took good care of it.
  • Good (G): Attractive and well cared for, but no longer fresh. Minor signs of wear, scuffing or scratching, but will play almost perfectly. For vinyl: barely detectable crackles or pops.
  • Fair (FR): This item is in okay condition. For vinyl: good is not so good and the record may have low level crackles or pops when playing. CD: one or more tracks may skip.
  • Poor (P): Obviously well-worn and handled. Most vinyl collectors will not buy good or below, but some tracks on CD or vinyl will play.
Conditions Guide
HPB condition ratings
  • New: This movie is unopened and brand new.
  • Fine/Like New (EX): Near new. No defects, little sign of use. Plays perfectly. Not necessarily sealed or unused, but close. No skipping; no fuzzy or snowy frames in VHS.
  • Very Good (VG): Attractive and well cared for but no longer fresh. Minor signs of wear, but will play almost perfectly. For VHS: barely detectable distortion or very few fuzzy or snowy frames.
  • Good (G): This item is in okay condition and basically works well. There may be some minor distortion on VHS tape; slight scratching or wear on DVD.
  • Fair (FR): Basically plays, but may be obviously well-worn with some scratching or tape distortion.
  • Poor (P): Disc or tape is intact, but may be scratched or stretched. There may be skips or distortion or product defects.
Conditions Guide
×