Azure SQL Data Warehouse: First Look

Azure SQL Data Warehouse is Microsoft Azure's Database as a Service offering. This course teaches the differences between this service and SQL Server, designing your database for the service, loading and migrating data, scaling and basic monitoring.
Course info
Rating
(52)
Level
Beginner
Updated
Aug 17, 2016
Duration
1h 45m
Table of contents
Description
Course info
Rating
(52)
Level
Beginner
Updated
Aug 17, 2016
Duration
1h 45m
Description

Businesses are accumulating more data than ever and continue to need more tools to properly store and analyze their ever-growing data sets. The cloud brings the power of data warehousing to the hands of every data professional by enabling Database as a Service offering that can efficiently store and process large amounts of structured data. In this course, Azure SQL Data Warehouse: First Look, you will learn the fundamental concepts and skills to start using this Data Warehouse as a Service offering from Microsoft. First, you will learn the concepts and differences between this service and SQL Server. Second, you will learn important planning considerations such as design, data loading and migration from an existing database. Finally, you'll learn about scaling the service and monitoring query performance. When you're finished with this course, you will have the skills and knowledge of Azure SQL Data Warehouse needed to properly evaluate the service and start a new warehousing project or a database migration. Software required: Azure subscription, SQL Server Management Studio.

About the author
About the author

Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.

More from the author
Azure SQL Database for the SQL Server DBA
Intermediate
2h 47m
20 Dec 2016
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Warner Chaves, and welcome to my course, Azure SQL Data Warehouse: First Look. I'm a Microsoft Data Platform MVP, and a principal consultant at Pythion. Data Warehousing projects have a reputation of being very expensive to start and very expensive to operate on an ongoing basis, however, the cloud has now come to change all that by providing a data warehouse that's a fully-managed service and making it easy to provision, load, and query your data warehouse cost-effectively, and with good performance. With a full T-SQL interface and compatibility with the rest of the Microsoft Data Stack, Azure SQL Data Warehouse can fit transparently into your business data strategy, and leverage already existent and familiar development and management skills. Some of the major topics that we're going to cover include differences with the classic SQL Server, the sign-in for Azure SQL Data Warehouse, methods for loading and migrating data, and workload management and scaling the system up or down. But by the end of the course, you'll have the information necessary to jump into the service for a new data warehousing project or a migration to the cloud. Before beginning the course, you only need to be familiar with basic concepts of data warehousing and SQL Server administration. I hope you'll join me on this journey to learn data warehousing in the cloud with Azure SQL Data Warehouse: First Look course at Pluralsight.

Warehousing in the Cloud
Hi. This is Warner Chaves with Pluralsight, and welcome to my course, Azure SQL Data Warehouse: First Look. This course is an introduction to the main concepts of SQL Data Warehouse; provisioning, designing, and maintaining the system. This is module 1, Warehousing in the Cloud. In this module, we're going to go over the main concepts of Azure SQL Data Warehouse that you need to understand in order to jump in and start using the service. We're also going to go through the biggest advantages of doing warehousing in the cloud, especially as opposed to doing traditional on-premises data warehousing. Finally, we're going to go into how the service is built, and how you can provision your data warehouse in the Microsoft Azure cloud environment.

Designing for Azure SQL Data Warehouse
Hi. I'm Warner Chaves from Pluralsight, and welcome to module 2 of the Azure SQL Data Warehouse: First Look course. This is Designing for Azure SQL Data Warehouse. In this module, we'll go through design choices that you have to consider for Azure SQL Data Warehouse. Even though the system is very similar to the SQL Server that you're used to, there are some design decisions that will likely be different. We're also going to go into the considerations on design for Fact Tables, we'll go through the considerations on design for Dimension Tables as well.

Loading Azure SQL Data Warehouse
Hi. This is Warner Chaves with Pluralsight, and welcome to module 3 of the Azure SQL Data Warehouse: First Look course. This is Loading Azure SQL Data Warehouse. In this module, we're going to look at the best practices for loading data into Azure SQL Data Warehouse. We're also going to look at the different methods available for loading data and their different characteristics. And finally, we're going to take a look at the Azure Data Warehouse Migration utility, a utility that will help you plan your migration and execute it from your on-premises database to Azure SQL Data Warehouse.

Querying and Tuning Azure SQL Data Warehouse
Hi. This is Warner Chaves with Pluralsight. Welcome to module 4 of the Azure SQL Data Warehouse: First Look course. This is Querying and Tuning Azure SQL Data Warehouse. In this module, we're going to go over the concurrency and transaction model of Azure SQL Data Warehouse, which is quite different from the on-premises SQL Server. Then we're going to go over maintenance operations that are still your responsibility as a user of the service. And finally, we're going to take a look at how we can track and scale query performance to get the biggest benefits out of our data warehouse.