This course explores how to plan and implement data platform resources specifically with regards to Azure SQL offerings. In particular, we will explore the benefits and features of the SQL PaaS offerings along with billing models, service tiers, and high availability options. We'll also cover migration scenarios and provide a demo that migrates a sample database from an on-premise SQL Server to an Azure SQL managed instance using DMS.
If you have any feedback relating to this course, feel free to contact us at support@cloudacademy.com.
Learning Objectives
- Get a general understanding of Azure SQL databases
- Learn how to deploy Azure SQL databases
- Understand business continuity and security tie in with SQL databases
- Learn how to scale, upgrade, and partition your databases
- Learn how to migrate a database from an on-premise SQL Server to an Azure SQL instance
Intended Audience
- Anyone who wants to learn about Azure SQL Offerings
- Those preparing for Microsoft’s DP-300 exam
Prerequisites
To get the most out of this course, you have should a general understanding of the fundamentals of Microsoft Azure. Experience using databases — especially SQL Server — would also be beneficial.
If you are currently running your database on premise, then you will need to migrate your data to the Azure cloud. Microsoft provides tools for data migration that cover various source and destination scenarios. Azure Database Migration Service or DMS enables easy migrations from multiple on-premise or other cloud provider databases to Azure-hosted databases.
DMS offers both offline and online migration methods. When migrating offline, the data will become unavailable as soon as the migration process begins. Online migration can help reduce downtime by using continuous synchronization between source and destination databases.
Microsoft recommends testing the amount of time an offline migration will take. And if the service interruption is unacceptable, use the online migration method. The Data Migration Assistant tool helps you assess on-premise SQL server databases. Informing you of compatibility issues, will hamper your migration to the Azure environment.
As with an on-premise situation, you can back up a database, copy it to blob storage and restore it to an Azure SQL server, depending on whether your destination is SQL server running on a VM, An SQL managed instance, or an Azure SQL server you may still need to check your database for compatibility.
You can also use transactional replication to move data between on-premise and an Azure SQL or managed instance database.
Lectures
Course Introduction - Azure SQL Databases Overview - Deployment Options - ARM Templates Deployment - DEMO: Deploying Azure SQL Databases - Business Continuity - Security Database Services - Scale and Performance - DEMO: Scaling Azure SQL Databases - Partitioning Data - Migration Scenarios - DEMO: DMS Azure SQL Database Migration Process - Upgrade Scenarios - Summary
Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.