- Prepare to maintain SQL Server-based databases on Azure
At the end of this module, you will be able to:
Understand the role of Azure Database Administrator as it fits in with other data platform roles.
Describe the key differences between the SQL Server-based database options in Azure.
Describe other features for Azure SQL platforms available.
- Deploy IaaS solutions with Azure SQL
After completing this module, you will be able to:
Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
Learn the available options for provisioning and deployment
Deploy SQL Server into an Azure Virtual Machine
- Deploy PaaS solutions with Azure SQL
After completing this module, you will be able to:
Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
Understand PaaS provisioning and deployment options
Understand elastic pools
Examine Azure SQL Managed Instances
Configure a template for PaaS deployment
- Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.
In this module, you'll:
Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
Migrate databases using Azure Database Migration Service with Azure CLI and tracking database migration activities.
Use transactional replication as an online method to migrate to Azure SQL Database.
Explore several other methods for migrating SQL Server databases to Azure SQL Database.
- Migrate SQL Server workloads to Azure SQL Managed Instance
In this module, you'll:
- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.
- Learn how Log Replay Service works to migrate to Azure SQL Managed Instance.
- Understand how Managed Instance link feature works in a migration scenario.
- Load and move data to and from Azure SQL Managed Instance.
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.
