Join Walt Ritscher for an in-depth discussion in this video What you should know before watching, part of Visual Studio Essential Training: 11 Data Tools.
- [Voiceover] So what should you know before beginning this course? This is an introduction to the data tools available in Visual Studio. That means we'll spend the majority of the course working inside the Visual Studio application. Therefore some experience with Visual Studio, the full-featured Microsoft Developer IDE, is a plus. In this course, I'll be working with Visual Studio 2015, but the data tools are also available for Visual Studio 2013 and earlier versions. To be clear, the older versions of Visual Studio can be very different in what tools are available.
So if you have to use a older version, at least you'll be able to apply some of the principles in this course. Just be aware that there could be differences in location of the tools and how they work. There are number of courses available to help you learn how to work with Visual Studio. This playlist is available on our site. It lists all the Visual Studio 2015 courses in our catalog. The example application code for the course is C#. So, naturally, I'll be working with solutions and projects that contain code. I usually program in C#, so that's the language I'll use in the course.
I assume that you know .NET and C#. If you want to learn more about C#, there is a playlist on our website that lists all of the relevant C# courses. I'll be working with relational databases like SQL Server, so there will be some Structured Query Language, or SQL, used in the course. SQL is the classic language used with relational databases, most often used to query the underlying data store. So if SQL is new to you, I suggest you search our site for some courses to help you learn this important data language. There is a chapter in this course covering Microsoft's Entity Framework, which is their version of an object relational mapper, or ORM.
Entity Framework is a big subject. I'll only provide an overview of some of the Visual Studio tools that help build Entity Framework applications. During that chapter, I'll show some Language-Integrated Query, or LINQ examples. LINQ is a fantastic way to query data from within the C# code. I know we have some courses on LINQ. Check them out.
- 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.