Database Training with Visual Studio 2010 Ultimate

To sign up for any of these courses, please contact Notion Solutions at 972.607.4830 or via email at sales@notionsolutions.com.

Next Scheduled Class: Dallas, TX - (Please Call 972.607.4830 for Available Dates) - 8:30am-5:00pm ($1795 USD)

This four-day instructor-led course provides students with the knowledge and skills to manage database objects using source control management, a configurable build process, and tools that aid in database testing, test data generation and deployment all integrated directly into Visual Studio 2010. By the end of the course, students are equipped to use managed techniques for testing, versioning and deploying databases to create high-quality databases with a minimal change in overall effort.

Audience Profile

This course is intended for Enterprise IT Staff who actively participate in building and changing SQL Server databases for software development projects. They participate in database design, development, stored procedure writing, database testing or deployment management.

At Course Completion

After completing this course, students will be able to:

Course Topics and Labs

Introducing Visual Studio 2010 Ultimate
Overview of Application Lifecycle Management
Visual Studio 2010 Ultimate in the enterprise
Overview of targeted roles and capabilities
New architecture and administration in 2010
Work Tracking Overview
Work Item States
Work Item Links
Custom link types
Hierarchical Work Item Management
Labs
  • Creating and managing Requirements
  • Working with Visual Studio 2010 Ultimate Web Access
  • Working with Team Explorer
  • Working with hierarchical Work Items
Retrieving Work Items
Work Item Queries
Work Item Query folders
Hierarchical Work Item queries
Link queries
Managing Work Items with Excel and Project
Labs
  • Creating flat Work Item queries
  • Managing Work Item data in Excel
  • Creating hierarchical Work Item queries
  • Managing hierarchical data in Project and Excel
Management and Reporting
Team Project Dashboard
Visual Studio 2010 Reports (Reporting Services)
Reporting with Excel Reports
Labs
  • Working with the Team Project Dashboard
  • Working with Excel Agile Reports
Version Control Overview
Description and Team Foundation Server version control concepts
Parallel development
Architecture overview and changes in Visual Studio 2010
Storage and reverse-delta storage
Changesets and Pending Changes
Workspaces
Adding files to version control
Check-Out/Check-In
Deleting files from version control
Labs
  • Adding projects to Team Foundation Server version control
  • Checking changes work into Team Foundation Server version control
  • Working with unbound files in Team Foundation Server version control
Version Control Features
Viewing Version Control History
File and Version Comparison
Annotate
Labels
Working with shelvesets
Labs
  • Working with Team Foundation Server version control history
  • Working with annotate in Team Foundation Server version control
  • Working with labels in Team Foundation Server version control
  • Shelving
Build Process
Team Build Architecture
Creating Build Definitions
Executing Builds
Scheduling Builds/Continuous Integration
Gated Checkins
Private/Buddy Builds
Symbol Server Integration
Log Enhancements
Running Tests As Part Of The Build
Labs
  • Creating new build
  • Executing builds
  • Working with gated checkin
Visual Studio 2010 Database Tools Overview
Overview of database development and versioning
Overview of Visual Studio 2010 database tools
Database development with sandboxes and automated deployment
Discussion of using Visual Studio 2010 database tools with non-SQL Server platforms
Database Projects
Overview of Database Project structure
Importing existing databases
Importing options and configuration
Understanding the properties and components of a Database Project
Working with .sqlsettings, .sqlpermissions, and .sqlcmdvars configuration files
Navigating a database project using object view and schema view
Labs
  • Importing an existing database using the wizard
  • Navigating a database project
Build and Deploy Your Database Locally
Understanding the build process
Understanding the deploy process
Portable schema output
Deploying to your local sandbox
Labs
  • Building a database project
  • Configuring a local system for sandbox database deployment
  • Deploying a database to the local sandbox
Making Changes to Your Database
Modifying database schema
Making changes to views, stored procedures, etc.
Refactoring a database
Wildcard expansion
Move schema
Creating custom refactoring types and targets
Labs
  • Modifying database schema
  • Refactoring a database column
  • Adding a stored procedure and using wildcard expansion
Deploying Database Changes
Deploying databases to non-local environments
Deploying databases to production environments
Deployment workflow and managing production deployments
Setting up multiple .sqldeployment configurations
Deploying breaking changes
Labs
  • Deploying breaking changes to an external database
  • Adding configuration scripts and/or configuration data to database deployments
Managing Quality in Database Development
Using Static Code Analysis on database projects
Creating custom code analysis rules
Labs
  • Using Code Analysis to improve database code quality
  • Creating custom database code analysis rules
Schema and Data Comparison
Compare schema of different databases or database projects
Understanding the output differencing script
Compare data of different databases
Filtering options and navigation
Labs
  • Compare schemas of database projects and databases
  • Compare data between databases
Testing Databases
Unit testing databases overview
Creating unit tests with Visual Studio 2010 database tools
Creating and modifying a data generation plan
Creating a custom data generator to model complex data relationships
Testing database objects
Regression Testing
Automated data generation for the build process
Labs
  • Creating unit tests for databases
  • Creating a data generation plan
  • Modifying a data generation plan using multiple data generators
  • Using a data bound data generator
  • Generating test data during the build
  • Creating a custom data generator
Database Project - Advanced Topics
Creating and using Database Server projects
Partial Projects
Composite Projects
Labs
  • Creating a Server Project to model server-level objects
  • Working with Server Projects