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 tutorial looks at how to install the SSDT features.
- [Voiceover] This course focuses on the data tools that are included in Visual Studio 2015. Most of these tools are part of a feature called the SQL Server Data Tools, or SSDT. When you install Visual Studio, some of the SSDT tools are part of the default install. In this video, I'll look at how to install the entire SSDT Suite. First I'll look at the scenario where you don't have Visual Studio installed. I went to the VisualStudio.com website and clicked on the Download Community 2015 button.
This gives me a copy of the Installer for the free Community Edition. Here it is on my desktop. Double-click on this executable file, and after a few seconds, you'll see this dialog. I don't want to do a default install, because that won't include the SSDT tools I'm looking for, so I'll click on Custom, then click on Next, and then in this section, the Windows and Web Development section, put a checkmark here for Microsoft SQL Server Data Tools. And when you hover over this, you'll see that there's a number of tools there included here, including the Entity Framework tools, some SQL Server Data Tools, and some SQL Server 2000 Native Client Tools.
You'll click on the Next button, and then, if you click on the Install button, after about 30 minutes to an hour, you'll have Visual Studio installed with your Data Tools. Now I'll switch to another computer that already has Visual Studio installed. There it is. You see it's installed, so I'll run the Programs and Features Tool. Then I'll search for Visual Studio. There it is. On this computer, I have Visual Studio Enterprise 2015, but the steps I'm showing here are the same if you're using the Professional Edition or the Free Community Edition.
Choose Change, and after a few seconds, I see this screen. I'll click on Modify. Here in this section, I can see that there's already a checkmark next to Microsoft SQL Server Data Tools. That means it's already installed on this computer, but if you don't see this checkmark here, all you need to do, of course, is put a checkmark here, and then click on the Update button. This video looked at installing the SQL Server Data Tools. There are additional tools that I'll look at during the course. I'll cover the installation of them when appropriate in the other chapters.
- 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.