Visual Studio includes a number of data-specific tools in the default installation. There are some additional tools, part of the SQL Server Data Tools (SSDT) suite, that need to be installed for this course. This video looks at how to install the SSDT features for Visual Studio 2017.
- [Instructor] We're here to look at how to install the SQL Server data tools in Visual Studio 2017. The first step is to run the installer. I've searched for the Visual Studio installer in my Start menu and I'll choose this desktop app. On this screen, you'll see your installed versions of Visual Studio. In my case, I have Enterprise, so I'll click on Modify. Then let's go take a look at the Individual Components. These are the tools that you want to have installed for the course and they're in this Cloud, Database, and Server section.
We don't need all these tools, but we will need ones like the SQL Server Data Tools. It's nice to have the LocalDB available, so you'll want to install this SQL Server Express 2016 LocalDB. It's good to have the SQL Server Native Client for deploying your database on client machines or the Command Line Utilities. And you could add these individually if they're not selected in your install, but another way to add them is to go to Workloads and you can get all of them by putting a check mark here in Azure Development.
You will also get a lot of these components when you add some other workloads. For instance, you can get them in the ASP.NET and Web Development if you add this workload. You also get most of the tools when you do Universal Windows Platform Development. For this one, make sure you do have the Azure Development checkbox checked, because we'll be using Azure during the course. Next, you'd click on Modify, wait until the install's done, and then you're ready to follow along.
- Exploring integration with Azure data sources and other Microsoft databases
- Working with SQL Server Express LocalDB
- Connecting to databases with Server Explorer
- Working with database tables
- Manipulating tables with the SQL Server Object Explorer
- Creating queries and custom views
- Creating stored procedures
- Comparing databases
- Building a data project in Visual Studio
- Refactoring a database object
- Deploying the database
- Connecting to Azure databases
- Deploying data projects to Azure
- Integrating Visual Studio with Entity Framework
Skill Level Beginner
Q: This course was updated on 08/23/2017. What changed?
A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.