Azure SQL fundamentals

Learn how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. After completing this learning path, you will have a foundational knowledge of what to use when, as well as how to configure, secure, monitor, and troubleshoot Azure SQL.

Prerequisites

  • Experience working with, maintaining, and developing with SQL Server
  • Experience with Azure, such as deploying and managing resources

Get started with Azure

Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.

Modules in this learning path

Azure SQL is a family of managed, secure, and intelligent products in the Azure cloud that use the same SQL Database Engine as SQL Server. In this module, you'll learn about the benefits of moving to the cloud with the capabilities and technical characteristics of the three products in the Azure SQL family: Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs.

In this module, you learn about the process of deploying and configuring Azure SQL. Through hands-on exercises, you deploy and configure Azure SQL Database specifically. You also see comparisons to both Azure SQL Managed Instance and SQL Server. In addition to the Azure portal, work with SSMS, Azure Data Studio including SQL notebooks, and the Azure CLI.

In this learning path, you've deployed and configured a secure, performant, and highly available solution by using Azure SQL. There are many elements in a single solution. In this module, you'll learn how to take the business scenario and determine the best resources and processes to satisfy requirements while considering the constraints within the scenario. You'll also learn what else you should consider with Azure SQL and opportunities in the cloud.