Visual Studio Essential Training: 11 Data Tools

Course Overview

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

Course Circullum

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

Walt Ritscher

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: