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 |
