This video tutorial introduces database administrators to the concept of test-driven development. Creating a database schema means building an interface to help applications manage data. Then, once you've built the interface, you need to know how well it works. You'll use pgTAP (Test Anything Protocol) to create a database design with an intuitive, useful interface for managing application data.

Derive more intuitive table structures, keep an eye to the beauty of your views, and let your procedures make your application more productive -- all through the power of Test-Driven Database Development.

"Test-Driven Database Development" captures one of the popular tutorial sessions presented at OSCON 2010, the O'Reilly Open Source Convention held in Portland, Oregon in July. Other videos of OSCON 2010 sessions include:

• Automated Infrastructure is on the Menu with Chef
• Building a NoSQL Data Cloud
• Cooking with jQuery
• Django Deployment Workshop
• Hands-on Cassandra
• Introduction to Django
• Observing and Optimizing your Application with DTrace
• Practical Python Programming: Callbacks
• The Productive Programmer
• Scalable Internet Architectures
• The Seductions of Scala

1. Test Driven Database Development Part 1 1 hour 22 minutes  
2. Test Driven Database Development Part 2 1 hour 35 minutes