Database Testing and Code Management

This course is included in our On-demand training solution.


recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005

Target Audience

Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005; individuals looking to pass the 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path.


Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types, writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, iImplementing databases at the physical level, and gathering business requirements.

Expected Duration

135 min.

Course Objectives

Database Testing and Code Management

  • recognize how different versions of a file are implemented using source control.
  • recognize how to manage different versions of a project by using the source control system.
  • recognize the concept of unit testing and the process of designing unit tests.
  • recognize how to perform unit tests for various parameters on queries executed in SQL server 2005.
  • recognize how to identify and formulate a plan to monitor the performance of SQL Server 2005.
  • recognize how to monitor and improve the performance of SQL Server 2005.
  • determine the design strategy for testing and performance.