Course info
Feb 12, 2014
3h 17m

Do you work with a database as part of your development tasks? This course covers the data tools available for developers within Visual Studio. These tools, called SQL Server Data Tools (SSDT) allow you to perform database tasks, create and manage database scripts, and easily deploy database changes all from within Visual Studio. Enjoy!

About the author
About the author

Deborah Kurata is a software developer, consultant, Pluralsight author, Google Developer Expert (GDE) and Microsoft Most Valuable Professional (MVP). Follow her on twitter: @deborahkurata

More from the author
Angular Routing
4h 48m
Dec 20, 2018
Angular: Getting Started
5h 41m
Nov 8, 2018
More courses by Deborah Kurata
Section Introduction Transcripts
Section Introduction Transcripts

Scripting Data
We have seen how to create a database project that includes table and stored procedure scripts. But, what about data? There are often times that you need to pre-populate tables with reference data, such as valid customer types in a customer type table. Welcome to Visual Studio Data Tools for Developers. My name is Deborah Kurata and this module focuses on scripting and publishing data. This module covers creating insert scripts to insert data into a database table, defining a post-deployment script to include the data scripts in the deployment, and using a merge script to better control updating data in a database table. Let's script some data.

Final Words
In this age of iterative design and quick sprints, the database often needs to change as quickly as the software. As we have seen in this course, using a database project helps you manage and deploy those changes. There are two additional features of database projects that this course has not yet covered: Refactoring support and unit testing. Welcome to Visual Studio Data Tools for Developers. My name is Deborah Kurata and this module presents some final words on the Visual Studio Data Tools. Refactoring allows you to make more complex changes to a database project script over time, such as changing a column name. Unit testing allows you to write unit tests for your database objects, such as your stored procedures. Let's take a quick look at these two features.