Designing and Implementing Cloud and Data Platform Solutions - Exam 70-473
In this learning path, you will learn how to build and architect SQL focused solutions in Microsoft Azure. Topics will include SQL Server in Azure IaaS, SQL Database and SQL Data warehouse. This course will help you prepare for exam 70-473 Implementing Cloud Data Platform Solutions and prepare for your Microsoft certification.
In this module, attendees will learn how to design solutions using Azure Infrastructure as a Service Components. This module will focus on core capabilities, use cases, and general best practices as well as discuss peripheral services such as Azure Backup and Site Recovery.
In this lab, you will create a virtual network that will allow the virtual machines you create to securely connect with each other. You will then create two virtual machines and specify the virtual network configuration and the availability set configuration along with storage for the virtual machin...
In this hands-on course, students will learn about running SQL Server in Azure. This course will review basic Azure networking and storage using the Azure Resource Manager architecture to prepare students for building SQL Server solutions in Azure. The primary focus of this course is SQL Server clou...
In this lab, you learn about deploying SQL Server on Azure virtual machines. This lab will walk you through some common setup and configuration tasks for running SQL Server in Azure infrastructure as a service.
In this lab, you learn about leveraging Azure storage with SQL Server. You will learn how to leverage Azure storage for backup to URL and snapshot backup with SQL Server 2017.
In this hands-on course, students will learn about Azure SQL Data Warehouse. This course will review basic architecture of Azure SQL Data Warehouse. We will cover tools used with Azure SQL Data Warehouse, loading SQL Data Warehouse and basic workload management in SQL Data Warehouse.
In this lab you will create an Azure SQL Database using the Azure Portal and connect to it using SQL Server Management Studio. You will then migrate a SQL Server database hosted on a virtual machine to an Azure SQL Database.
In this lab, we will walk through management and monitoring of an Elastic Pool. First, we will create an Elastic Pool and add our databases to the pool. Then we will monitor the performance of our pool using TSQL Scripts and the Azure Portal.
This course will be a deep dive into Azure SQL Database performance. We will look at designing an Azure SQL Database architecture for performance. We will look at performance specific features of Azure SQL Database. We will also cover monitoring and troubleshooting.