Implementing Azure SQL Databases

This lesson 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 lesson, 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 lesson, you have should a general understanding of the fundamentals of Microsoft Azure. Experience using databases — especially SQL Server — would also be beneficial.