This video looks at how to configure and open a connection to an Access database file.
- [Voiceover] I'm back in Server Explorer.…I'm ready to add a second connection.…I'll click on this Connect to Database button again.…And you see that it remembers…from the last time I was in here…that I had picked the SQL Server Database file,…so it's already selected.…I don't have to click on the Change button…and select it here anymore.…It's ready.…So this time, I'll go ahead and browse out…to the same location on my hard drive.…This is the V13 folder,…and I'll click this NorthwindV13.MDF file.…Then test the connection, and then click OK.…
Northwind is a sample database that Microsoft has provided…for I dunno, a long time, 15 years, 20 years.…It's been around for a long time.…Once this is available, I can click on this…and look at the tables, and look at things…like the Stored Procedures that are inside that database.…You can connect to different kinds of databases.…So far I've only connected to SQL Server databases,…but I can also click here and choose to connect…to Access Database File.…Click on the Browse button.…
- 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.