Deploying Applications to Microsoft Azure SQL Databases Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. This course covers the considerations for each, as well as the requirements and processes involved in migrating data to Azure SQL Databases. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.
Target Audience
SQL Server database administrators and application developers
Prerequisites
None
Expected Duration (hours)
1.6
Lesson Objectives Deploying Applications to Microsoft Azure SQL Databases
start the course
explain the difference between single-tenant and multi-tenant data architectures
recognize the architectural considerations that influence choosing between a single vs multi tenant
explain considerations, such as economic, security, tenant, relating to multiple tenants
describe how to manage multi-tenant data in SQL Server 2016
describe the benefits of partitioning and isolating tenant data
demonstrate how to manage deployments that support multiple tenants
recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure
recognize the tools available to test for SQL Database compatibility
describe how to migrate a non-SQL Server database
demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard
compare the bacpac export and transactional replication migration methods
demonstrate how to create a BACPAC file to use in a database migration
explain the Azure data factory
describe the data transformation activities supported by Azure data factory
discuss how to install the data management gateway
create linked services that connect to data sources in Azure data factory
define and create tables to specify how to access datasets
demonstrate how to define, create, and start the pipeline
manage data using the Azure Data Factory
Course Number: df_sqlp_a08_it_enus
Expertise Level
Intermediate