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

YouTube

The Modern Data Warehouse

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the evolution of data warehousing in this 57-minute conference talk from PASS Data Community Summit. Learn about Microsoft's approach to adapting existing data warehouse infrastructure to handle the explosive growth in data volume, variety, and velocity. Discover how to scale out relational data to petabytes using Parallel Data Warehouse technologies, and non-relational data with HDInsight. Understand the benefits of in-memory columnstore for enhanced performance and how to manage mixed workloads effectively. Delve into big data concepts, including Hadoop and its various offerings for on-premise and cloud deployments. Examine the integration of relational data and Hadoop using PolyBase, and explore the flexibility of deployment options and hybrid solutions in modern data warehousing.

Syllabus

Intro
SQL Server 2014 Webinar Series
The traditional data warehouse
The modern data warehouse
Microsoft's modern data warehouse
Scale out relational data to petabytes Scale out technologies in the Parallel Data Warehouse
Scale out non-relational data Scale out non-relational data in HDinsight (for Azure or PDW)
In-memory performance In-memory columnstore for next-generation performance
Concurrency and mixed workloads Great performance for mixed workloads
What is big data?
What is Hadoop?
Hadoop Offerings On-Premise and Cloud Hadoop cluster in HDP for Windows, Appliance and Cloud
Integrate relational data and Hadoop Integrated query With PolyBase in the Parallel Data Warehouse
Freedom of deployment options and hybrid solutions

Taught by

PASS Data Community Summit

Reviews

Start your review of The Modern Data Warehouse

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.