Learn how to manage database connections, manipulate tables, query data, and deploy Azure and SQL Server databases in Visual Studio 2015.
Overview
Syllabus
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
- Explore the Microsoft databases
- The Azure data sources
- 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
- 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
- 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
- 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
- Prepare to compare databases
- Data comparison
- Schema comparison
- 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
- 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
- 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
- Next steps
Taught by
Walt Ritscher