Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 2 What you should know 00:00:31 Duration
Lecture 3 Set up the example databases 00:02:32 Duration

Section 2 : Data Warehouse Foundations

Lecture 1 Data warehouse core concepts 00:03:58 Duration
Lecture 2 Transactional databases vs 00:04:27 Duration
Lecture 3 Dimensions and facts 00:05:01 Duration
Lecture 4 Star and snowflake schemas 00:03:50 Duration
Lecture 5 Hardware and infrastructure 00:02:35 Duration

Section 3 : Create a Data Warehouse

Lecture 1 Create a data warehouse in SQL Server 00:05:12 Duration
Lecture 2 Design dimension tables 00:05:46 Duration
Lecture 3 Design fact tables 00:03:33 Duration
Lecture 4 Create an indexed view 00:03:28 Duration

Section 4 : Columnstore Indexes

Lecture 1 Advantages of columnstore indexes
Lecture 2 Memory-optimized columnstore table
Lecture 3 Rebuild columnstore indexes 00:03:03 Duration

Section 5 : Implement an Azure SQL Data Warehouse

Lecture 1 Hosting a data warehouse in the cloud 00:03:04 Duration
Lecture 2 Create an Azure SQL Data Warehouse project 00:04:32 Duration
Lecture 3 Develop tables in Azure SQL Data Warehouse 00:04:13 Duration
Lecture 4 The Data Warehouse Migration Utility 00:04:13 Duration
Lecture 5 Migrate a data warehouse to Azure
Lecture 6 Pause and remove an Azure data warehouse 00:01:46 Duration

Section 6 : Extract, Transform, and Load (ETL)

Lecture 1 What is ETL and SQL Server Integration Services (SSIS)
Lecture 2 Understand data flow 00:03:12 Duration
Lecture 3 Establish control flow 00:01:54 Duration

Section 7 : Enforce Data Quality

Lecture 1 SQL Server Data Quality Services (DQS) 00:03:59 Duration
Lecture 2 Cleanse data with DQS 00:06:48 Duration
Lecture 3 Create a custom knowledge base 00:06:46 Duration

Section 8 : Master Data Services

Lecture 1 Introduction to Master Data Services (MDS) 00:01:58 Duration
Lecture 2 Install MDS and IIS
Lecture 3 Configure Master Data Services 00:03:56 Duration
Lecture 4 Deploy a sample MDS model 00:06:35 Duration
Lecture 5 Install the MDS Excel add-in 00:02:28 Duration
Lecture 6 Update master data in Excel 00:03:40 Duration

Section 9 : Consume Data from the Warehouse

Lecture 1 Business intelligence applications 00:03:47 Duration