Agile Database Development Using Visual Studio 2010

    

Summary:
This course provides students with the knowledge and skills to properly manage the SQL Server 2005/2008 database development lifecycle in an Agile environment. The student will learn how to manage changes to the database schema, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases. Intended for developers and administrators already comfortable with the concepts of designing, programming, testing and deploying SQL Server databases, this course focuses on using Visual Studio 2010 Premium/Ultimate edition to maximize productivity while minimizing mistakes.

Duration:
3 Days/Lecture & Lab

Audience:
This course is intended for SQL Server 2005/2008 database developers and administrators. Application developers who are involved with writing and testing T-SQL code and working with test data will also gain value from this course.

Topics:

• Agile Database Development
• Database Projects
• Change Management
• Unit Testing
• Refactoring
• Data Generation
• Build and Deploy

Prerequisites:
Before attending this course, the student should have experience developing and administering SQL Server 2005/2008 databases. It would also be beneficial if the student has worked on a team-based software development project and is familiar with their organization's development lifecycle and practices

Last Update: May 20, 2012