Visual Studio Data Tools for Developers

By Deborah Kurata
This course covers the data tools available for developers within Visual Studio.
More
Start free trial now
By Deborah Kurata
This course covers the data tools available for developers within Visual Studio.
More
Expand all
Introduction
5m 9s
Introduction 5m 9s
Managing SQL Server Objects from Visual Studio
40m 33s
Introduction 2m 33s Connecting and Exploring 6m 35s Databases and Tables 13m 8s Stored Procedures 13m 9s Data 4m 23s Summary 0m 43s
Managing Scripts with a Database Project
29m 24s
Introduction 5m 35s Creating a Database Project 4m 55s Importing a Database 4m 43s Editing Scripts 7m 10s Setting Project Settings 5m 40s Summary 1m 18s
Publishing Database Scripts
43m 1s
Introduction 7m 36s Publishing to a Connected Database 6m 31s Using a Publish Profile 6m 51s Creating a New Database 3m 6s What is a DACPAC? 5m 36s Deploying with a DACPAC 10m 5s Summary 3m 13s
Scripting Data
29m 30s
Introduction 0m 53s Creating Insert Scripts 7m 11s Defining a Post-Deployment Script 10m 21s Using Merge Scripts 9m 34s Summary 1m 30s
Working with the SQL Menu Options
30m 13s
Introduction 2m 13s Schema Comparison 9m 40s Data Comparison 5m 42s Query 10m 8s Summary 2m 28s
Final Words
19m 24s
Introduction 1m 0s Refactoring 4m 1s Unit Testing 11m 4s Summary 3m 17s
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!
Table of Contents
Expand all
Introduction
5m 9s
Introduction 5m 9s
Managing SQL Server Objects from Visual Studio
40m 33s
Introduction 2m 33s Connecting and Exploring 6m 35s Databases and Tables 13m 8s Stored Procedures 13m 9s Data 4m 23s Summary 0m 43s
Managing Scripts with a Database Project
29m 24s
Introduction 5m 35s Creating a Database Project 4m 55s Importing a Database 4m 43s Editing Scripts 7m 10s Setting Project Settings 5m 40s Summary 1m 18s
Publishing Database Scripts
43m 1s
Introduction 7m 36s Publishing to a Connected Database 6m 31s Using a Publish Profile 6m 51s Creating a New Database 3m 6s What is a DACPAC? 5m 36s Deploying with a DACPAC 10m 5s Summary 3m 13s
Scripting Data
29m 30s
Introduction 0m 53s Creating Insert Scripts 7m 11s Defining a Post-Deployment Script 10m 21s Using Merge Scripts 9m 34s Summary 1m 30s
Working with the SQL Menu Options
30m 13s
Introduction 2m 13s Schema Comparison 9m 40s Data Comparison 5m 42s Query 10m 8s Summary 2m 28s
Final Words
19m 24s
Introduction 1m 0s Refactoring 4m 1s Unit Testing 11m 4s Summary 3m 17s
Description
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!
Course info
Level
Intermediate
Rating
(500)
Duration
3h 17m
Released
12 Feb 2014
Course authors
Deborah Kurata

Deborah Kurata is an independent consultant who specializes in designing and developing successful Microsoft .NET applications as well as mentoring software developers. She has authored several technical books and speaks at conferences. For her work in support of software developers, she has been recognized with the Microsoft MVP award.

Share course