Visual Studio Essential Training: 11 Data Tools

Learn how to manage database connections, manipulate tables, query data, and deploy Azure and SQL Server databases in Visual Studio 2015.

Introduction

• Welcome
• What you should know before watching
• How to use the exercise files
• Understanding the SQL Server Data Tools (SSDT)
• Install the SSDT features
• Install the SSDT features for Visual Studio 2017

1. Database and Data Integration

• Explore the Microsoft databases
• The Azure data sources

2. SQL Server Express LocalDB

• Why LocalDB is essential for developers
• Understand SQL Server named instances
• Determine the version LocalDB
• How the LocalDB on-demand feature works
• List the apps that use LocalDB

3. Server Explorer

• Compare the Server Explorer and SQL Server Object Explorer windows
• Data connections available in SQL Server
• Connect to a SQL database in Server Explorer
• Connect to another database in Server Explorer
• Manage connections
• Add a project level database
• Work with database tables
• Change database entities with Server Explorer or SQL Server Object Explorer

4. SQL Server Object Explorer

• How to access the SQL Server Object Explorer (SSOE)
• Interaction with Server Explorer from SSOE
• Copy the database for editing
• Add SQL Servers to Object Explorer
• Use Logical name to shorten a path
• Tour the Table Designer
• Add field to table
• Handling errors in table updates
• Understand the Power Buffer
• Add or modify table data
• Add and remove tables

5. Queries, Views, and Stored Procedures

• Connect to the Northwind database
• Use the Query window
• Work with existing Views
• Create a custom View
• Work with existing Stored Procedures
• Create a custom Stored Procedure

6. Compare databases

• Prepare to compare databases
• Data comparison
• Schema comparison

7. SQL Server Data Project

• Understand the data project template
• Create a data project
• Add items to project
• Import an existing database
• Change a table or other data item
• Build the project
• The sandboxed debug database
• Refactor a database object
• Compare the data project with other databases
• Deploy the database with the publish option
• Deploy the database with a DacPac file
• Work with source control

8. Azure Data

• Get an Azure account
• Connect to Azure with Server Explorer
• Create an Azure SQL database with the Azure portal
• Connect to Azure SQL Database with Server Explorer
• Deploy a Data Project to Azure
• Manage Azure SQL Database with the SQL Object Explorer

9. Entity Framework

• What is Entity Framework?
• The three approaches to modeling
• Use database-first to create an EDM
• Explore the EDM
• Use the Table Mapping window
• Use the Model Browser window
• Modify the EDM
• Use LINQ to query the EDM

Conclusion

• Next steps