Azure SQL Database and SQL DW

In this learning path, you will learn how to implement Azure Database. Topics will include understanding to design and deploy databases using SQL DB and SQL Datawarehouse along with more advanced topics of performance and troubleshooting for SQL.

5 (38)
3 Lectures
7 Labs
Intermediate
15h 6m
Jul 8 2018
Sep 17 2016
On-Demand Course
5 (12)

In the course Introduction to Azure SQL Database we will discuss the configuration, performance, security, availability, recovery and automation of Azure SQL Database. We will also review hybrid solutions with SQL Server Stretch Database. This course will partially help prepare you for exam 70-473 D...

0%
Skill Me Up
Apr 2 2019
Real Time Lab
4 (6)

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.

0%
Skill Me Up
Oct 10 2018
Real Time Lab
5 (4)

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.

0%
Skill Me Up
Feb 15 2019
Real Time Lab
5 (3)

In this lab, you will use PowerShell to manage Azure SQL Database. You will create a logical Azure SQL Server via PowerShell. You will then manage the firewall to allow remote connectivity to allow for client access. You will restore a database from an existing BACPAC file. Finally, you will use Pow...

0%
Aug 24 2016
On-Demand Course
5 (7)

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.

0%
Sep 15 2017
On-Demand Course
5 (3)

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.

0%
Skill Me Up
Sep 19 2017
Real Time Lab
5 (1)

In this lab, we will explore the use of columnstore indexes in Azure SQL Database. We will evaluate the performance improvements we get when we implement columnstore indexes on tables for with analytical workloads.

0%
Skill Me Up
Sep 19 2017
Real Time Lab
0 (0)

In this lab, you will explore real-time operational analytics using Azure SQL Database. You will evaluate the performance improvements you will get when you add updateable non-clustered columnstore indexes on top of standard tables as well as memory-optimized tables.

0%
Skill Me Up
Sep 19 2017
Real Time Lab
0 (0)

In this lab, we will examine the use of In-Memory OLTP in Azure SQL Database. We will compare performance across standard and in-memory architectures including memory optimized tables and natively compiled stored procedures.

0%
Skill Me Up
Sep 13 2018
Real Time Lab
5 (2)

In this lab, you will deploy and configure an on-premises gateway to work with Azure Logic Apps. The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApp...

0%