Planning for Source Control, Unit Testing, and Deployment Using SQL Server„˘ 2005(3181)


In this 2-hour premium course, you will learn various strategies that you can use to keep a manageable database environment during development. Topics range from incorporating source control and unit testing to performance baselining and deployment. In the lab, you will apply these strategies.

Using these techniques will allow you to provide a more stable environment for developing and deploying your database applications.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.



  • Design a Source Control Strategy
    • Integrate Source Control with Management Studio
    • Create a Source Control Plan
    • Encrypt Source Code
  • Design a Unit Test Plan
    • Identify Benefits and Limitations
    • Explain Unit Testing vs. Functional Testing
    • Perform a Unit Test
    • Create a Unit Test Plan
  • Create a Performance Baseline and Benchmarking Strategy
    • Identify Performance Objectives
    • Establish Performance Benchmarks
    • Measure Performance
    • Create a Performance Change Strategy
  • Design a Deployment Strategy
    • Explain the Need for a Deployment Strategy
    • Explain the Process of Designing a Deployment Strategy
    • Identify guidelines for Designing a Deployment Strategy
    • Plan a Deployment Strategy
    • Identify considerations for Deploying Notification Services


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-PSC-DUS
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend