Database Unit Testing for SQL Server Using tSQLt | Agenda Bookshop Skip to content
Selected Colleen Hoover Books at €9.99c | In-store & Online
Selected Colleen Hoover Books at €9.99c | In-store & Online
A01=Dennis Lloyd
A01=Sebastian Meine
Age Group_Uncategorized
Age Group_Uncategorized
Author_Dennis Lloyd
Author_Sebastian Meine
automatic-update
Category1=Non-Fiction
Category=UNSJ
COP=United States
Delivery_Delivery within 10-20 working days
Language_English
PA=Available
Price_€20 to €50
PS=Active
softlaunch

Database Unit Testing for SQL Server Using tSQLt

English

By (author): Dennis Lloyd Sebastian Meine

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

 

See more
Current price €37.04
Original price €38.99
Save 5%
A01=Dennis LloydA01=Sebastian MeineAge Group_UncategorizedAuthor_Dennis LloydAuthor_Sebastian Meineautomatic-updateCategory1=Non-FictionCategory=UNSJCOP=United StatesDelivery_Delivery within 10-20 working daysLanguage_EnglishPA=AvailablePrice_€20 to €50PS=Activesoftlaunch
Delivery/Collection within 10-20 working days
Product Details
  • Weight: 1000g
  • Dimensions: 10 x 10mm
  • Publication Date: 05 Jul 2024
  • Publisher: Pearson Education (US)
  • Publication City/Country: United States
  • Language: English
  • ISBN13: 9780133564327
We use cookies to ensure that we give you the best experience on our website. If you continue we'll assume that you are understand this. Learn more
Accept