Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Azure SQL Data Warehouse: First Look

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Warehousing in the Cloud 20mins
  • Designing for Azure SQL Data Warehouse 23mins
  • Loading Azure SQL Data Warehouse 32mins
  • Querying and Tuning Azure SQL Data Warehouse 27mins

Taught by

Warner Chaves

Reviews

4.7 rating at Pluralsight based on 78 ratings

Start your review of Azure SQL Data Warehouse: First Look

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.