- Building and deploying of database changes
- Generate test data in various scenarios
- Tests using test lists, ordered tests and categories
- Agile and Scrum roles to traditional roles and responsibilities.
- Data from two SQL Server instances for differences
- Schemas from two SQL Server instances for differences
- Waterfall to Agile.
- Database projects
- Manage test plans, test suites, test cases and manual test steps
- Applications meet Quality of Service (QoS) requirements
- VSTS by building your own test data generators
- VSTS by building your own unit test assertions
- Scripts to reconcile differences in schemas and data
- Identify testing support in Visual Studio 2010
- Import existing schemas and scripts
- Install and use the MSSCCI provider
- Integrate test data generation with T-SQL unit testing
- Daily Scrum Meeting.
- Sprint review and retrospective.
- Agile can fail and how to avoid pitfalls.
- Sprint Planning and task estimating.
- Agile Lifecycle.
- Agile values and principles.
- Methods for prioritizing and sizing stories.
- Identify good stories.
- Plan your release and build the backlog.
- Scrum , the roles involved, and the process.
- Agile and Scrum are adopted.
- Database projects under Team Foundation Version Control
- Software quality early in the lifecycle
- Identify performance issues
- Run, record and automate manual tests
- Test software on an Agile team using Visual Studio 2010
- Effective T-SQL unit tests
- Database refactoring correctly
- VSTS supports an agile database development life cycle
- Parallel development
- Software quality assurance and quality control concepts in Visual Studio 2010
- Team Foundation Build controller and agent architecture
- Team Foundation Server's support for parallel development
- Architecture of a process template and modify an existing process template
- Areas of integration with Team Foundation Server
- Capabilities of the VSTS Database Edition
- Visual Studio agents, specifically test controllers and test agents
- Branching, merging, shelving, and unshelving effectively
- Global lists to share selection data between fields and team projects
- MSBuild and Team Build to manage build and deployment
- Team Foundation Build to perform automated builds and testing
- TF command line utility and the TF Rollback command
- Visualize branch hierarchies and changeset merges
- Work offline so changes don't impact actual servers