Section 1 : Introduction

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

Section 2 : Data Warehouse Foundations

Lecture 4 Data warehouse core concepts 3:58
Lecture 5 Transactional databases vs 4:27
Lecture 6 Dimensions and facts 5:1
Lecture 7 Star and snowflake schemas 3:50
Lecture 8 Hardware and infrastructure 2:35

Section 3 : Create a Data Warehouse

Lecture 9 Create a data warehouse in SQL Server 5:12
Lecture 10 Design dimension tables 5:46
Lecture 11 Design fact tables 3:33
Lecture 12 Create an indexed view 3:28

Section 4 : Columnstore Indexes

Lecture 13 Advantages of columnstore indexes
Lecture 14 Memory-optimized columnstore table
Lecture 15 Rebuild columnstore indexes 3:3

Section 5 : Implement an Azure SQL Data Warehouse

Lecture 16 Hosting a data warehouse in the cloud 3:4
Lecture 17 Create an Azure SQL Data Warehouse project 4:32
Lecture 18 Develop tables in Azure SQL Data Warehouse 4:13
Lecture 19 The Data Warehouse Migration Utility 4:13
Lecture 20 Migrate a data warehouse to Azure
Lecture 21 Pause and remove an Azure data warehouse 1:46

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

Lecture 22 What is ETL and SQL Server Integration Services (SSIS)
Lecture 23 Understand data flow 3:12
Lecture 24 Establish control flow 1:54

Section 7 : Enforce Data Quality

Lecture 25 SQL Server Data Quality Services (DQS) 3:59
Lecture 26 Cleanse data with DQS 6:48
Lecture 27 Create a custom knowledge base 6:46

Section 8 : Master Data Services

Lecture 28 Introduction to Master Data Services (MDS) 1:58
Lecture 29 Install MDS and IIS
Lecture 30 Configure Master Data Services 3:56
Lecture 31 Deploy a sample MDS model 6:35
Lecture 32 Install the MDS Excel add-in 2:28
Lecture 33 Update master data in Excel 3:40

Section 9 : Consume Data from the Warehouse

Lecture 34 Business intelligence applications 3:47