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 (27)
INDIVIDUAL

For those who are on a technical journey of self improvement

TRY FREE FOR 10 DAYS
TEAMS

Ideal for 5 or more in need of upskilling

TRY FOR FOR FREE
(Trial or Pilot)
ENTERPRISE

Ideal for 200 or more in need of upskilling and scalability

LEARN MORE
3 Lectures
2 Labs
Advanced
9h 11m
Lecture
Sep 17 2016
1h 15m

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%
Real Time Lab
Feb 15 2019
Skill Me Up
1h 40m

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%
Lecture
Aug 24 2016
23m

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%
Lecture
Sep 15 2017
4h 42m

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%
Real Time Lab
Apr 7 2020
Skill Me Up
1h 10m

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%