Making the Case for Unit Testing Database Code

Pluralsight

Course Summary

This course discusses the reasons why you would want to unit test databases, how to go about justifying this to the business, and how to start unit testing your databases.

+
Course Description

This course is aimed at technical leads, development or project managers who are looking after database development projects. It discusses both why database unit testing is a best practice, and how to get the business buy-in necessary to adopt it. This is a less technical course, which helps show why gaining business buy-in to new processes such as database unit testing is important, and can be a key enabler for adoption of best practices.

Course Description

This course is aimed at technical leads, development or project managers who are looking after database development projects. It discusses both why database unit testing is a best practice, and how to get the business buy-in necessary to adopt it. This is a less technical course, which helps show why gaining business buy-in to new processes such as database unit testing is important, and can be a key enabler for adoption of best practices.

+
Course Syllabus

Introduction
- 10m 46s

—Introduction 1m 35s
—Defining Terms 3m 28s
—Standard Test Design 1m 41s
—Developer Workflow 1m 48s
—Aims in Unit Testing 1m 37s
—Summary 0m 34s

Business Focus
- 27m 15s

—Introduction 0m 58s
—Types of Testing 2m 21s
—Why Test Databases? 2m 18s
—Why Invest in Database Unit Testing? 4m 49s
—Cost Comparison 3m 16s
—Answering the Estimation Question 3m 39s
—Business Champions 4m 29s
—Automated Testing 3m 52s
—Summary 1m 29s

Implementation Considerations
- 23m 9s

—Introduction 0m 38s
—Choosing a Framework 5m 42s
—Existing Code 3m 42s
—New Developments 3m 53s
—What to Test First 1m 30s
—Writing Supportable Tests 3m 43s
—Evaluation 2m 41s
—Summary 1m 16s

Conclusions and Next Steps
- 9m 55s

—Conclusions 1m 53s
—Types of Testing 5m 8s
—Why Test Databases? 2m 53s